Here is the procedure to reset password of root user. 1) Stop mysql (Kill mysql process or run following command) sudo /usr/local/mysql/support-files/mysql.server stop 2) Start it in safe mode sudo mysqldsafe -skip-grant-tables 3) Open another terminal and run the following command (Keep last terminal open) mysql -u root 4) Run the following command with suitable new password on the mysql console mysql UPDATE mysql.user SET Password=PASSWORD('password') WHERE User='root'; 5) mysql FLUSH PRIVILEGES; 6) Quit from both terminals and open new terminal and connect to mysql with root user and new password mysql -uroot -p.
![Access Denied For User Access Denied For User](/uploads/1/2/5/4/125408156/398461132.png)
Mysql start ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password no) in OpenSuse 12.1 1 Access denied for user 'root'@'localhost' - WAMP server. Apr 27, 2014. It requires MySQL I was trying to login to root user 'root@localhost'. MySQL ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES). [Mac OS X] Unable to move/empty files from Trash.
I am stuck when trying to access mysql. It's my first time so please be patient with me. Initially I was try to set up Ruby and Rails and everything worked perfrectly expect access denied when connecting to the server, SO I ran this command. Mysql -uroot -p I've tried various passwords including leaving it blank and get this error.
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) I am assuming I need to reset the password for root user but I just can't seem to get it to work.