ERROR 1045 (28000): Access denied
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
Gaetano
Subject
Views
Written By
Posted
ERROR 1045 (28000): Access denied
22330
January 14, 2012 07:52AM
6759
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.