Web Hosting Talk







View Full Version : Error: 1045 and 1044 re:MySQL


eee
04-30-2003, 06:39 AM
I keep on getting Error: 1045 when trying to access mysql from root.
root] # mysql -u root -p -h localhost
Enter Password:
Error 1045; access denied for user; 'root@localhost' (using password: YES) and also with (using password: NO)

I can get in using; mysql -u admin
Welcom to the mysql.........

When I try

mysql> GRANT ALL PRIVILEGES ON mysql.* TO ____@localhost
IDENTIFIED BY 'a_password' WITH GRANT OPTION;

Iget; Error 1044; access denied for user; '@localhost; to database mysql

Any name for user is not accepted.

Can anyone help?