MySQL Forums
Forum List  »  Oracle

ERROR 1045 (28000): Access denied
Posted by: Gaetano Nicosia
Date: January 14, 2012 07:52AM

Hi Guys,
I have installed from source Mysql on suse machine.
When I execute mysql, the message ERROR 1045 (28000): Access denied for user ‘root’@'localhost’ (using password: NO) is displayed.

Searching in Internet I have founded an article that suggest:
1) Run /etc/init.d/mysql stop
2) Run mysqld_safe --skip-grant-tables
3) Because the previous command not return to prompt, I have opened a new terminal window.
4) In the new window I execute mysql -u root and next use mysql
5) After I change the password with update user set password=PASSWORD('mynewpassword') where User='root';

I run newly mysql and the command work without problem; but if I reboot the machine, the ERROR 1045 is newly displayed.

Can You help me ?

Thank You

Options: ReplyQuote

Written By
ERROR 1045 (28000): Access denied
January 14, 2012 07:52AM
January 16, 2012 09:34AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.