PDA

View Full Version : amigeekornot script help


steven
05-16-2001, 12:04 AM
Hello, I am trying to install the amigeekornot script and when I create my database from my HR CP, everything is fine. But when I try to import the included .sql file it says "grant command denied to user steven79@localhost for table user"

In the install file it said to
Add a user to MySQL named "webuser". You can do this with the following
commands:
mysql -u root -p
<enter your MySQL root password>
use mysql;
insert into user values ('localhost', 'vote', password('vote'), 'Y','Y','Y','Y','N','N','N','N','N','N','N','N','N','N');
flush privileges;
exit
This creates a user with the name "vote" and the password "vote". This user
can only log in from the local system. This is secure enough for most people.
If you change the password or username, be sure to also change them in the
file prep.php3

Run the MySQL script. This will create a database, table, and index. It
will also grant read/write/update/delete access to the user "vote". You
can do this with:
mysql -u root -p < vote.sql

So how can I do this? Any help is greatly appreciated.