hi
i follow your instruction on the DJG's Setting up MySQL users and databases Guide. the following is what i got.
i got an error when i try to create the database at the end.
if u are suggesting me to visit this site for your info, its dead. i can't access it. so if you dont mind, pls post the help for me here. pls specify how to do the grant stuff step by step.
thanx
mysqladmin -u root password 'mypassword'
mysql -u root -p
mysql> use mysql;
Database changed
mysql>
mysql> insert into
-> host(host,db,Select_priv, Insert_priv, Update_priv,
-> Delete_priv, Create_priv, Drop_priv)
-> values('localhost','%','Y','Y','Y','Y','Y','Y');
mysql> insert into
-> user (host, user, password)
-> values('localhost','djg',password('mypassword'));
mysql> insert into
-> db (host,db,user,Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv)
-> values ('localhost','mydatabase','djg','Y','Y','Y','Y','Y','Y');
mysql> quit
mysqladmin -u -p create mydatabase
mysqladmin: CREATE DATABASE failed; error: Access denied for user: 'localhost' to database 'databasename'
i follow your instruction on the DJG's Setting up MySQL users and databases Guide. the following is what i got.
i got an error when i try to create the database at the end.
if u are suggesting me to visit this site for your info, its dead. i can't access it. so if you dont mind, pls post the help for me here. pls specify how to do the grant stuff step by step.
thanx
mysqladmin -u root password 'mypassword'
mysql -u root -p
mysql> use mysql;
Database changed
mysql>
mysql> insert into
-> host(host,db,Select_priv, Insert_priv, Update_priv,
-> Delete_priv, Create_priv, Drop_priv)
-> values('localhost','%','Y','Y','Y','Y','Y','Y');
mysql> insert into
-> user (host, user, password)
-> values('localhost','djg',password('mypassword'));
mysql> insert into
-> db (host,db,user,Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv)
-> values ('localhost','mydatabase','djg','Y','Y','Y','Y','Y','Y');
mysql> quit
mysqladmin -u -p create mydatabase
mysqladmin: CREATE DATABASE failed; error: Access denied for user: 'localhost' to database 'databasename'