Mysql

[Michelle]

Hi again everyone,

I have some problems in mysql.

Whilst I'm in there as root I give this command to give permission to michshelly to access the employee database:

GRANT ALL ON employees.* TO michshelly@localhost IDENTIFIED BY "eagle"

Apparantely the "eagle" is the password according to a tutorial I am following.
Then when I get out of mysql as root and try to log in as michshelly by using:

mysql -u user_name -p

It says 'Access Denied'. However I can just log in by typing:

mysql -u michshelly

I can see databases but not the employee database that was created by root.

Can someone help me please? It would be much appreciated!

Thanks thanks
Michelle

[Igi_BG]

These are coppied from MYSQL manual. I use exactly the same syntax and it works fine. try it.

mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost'
-> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%'
-> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
mysql> GRANT RELOAD,PROCESS ON *.* TO 'admin'@'localhost';
mysql> GRANT USAGE ON *.* TO 'dummy'@'localhost';