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.
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.