Access denied for user ‘root’@’’ (using password: NO)-Linux OS

December 31, 2015 by Linux Guru

Filed under Database, MySQL

Last modified July 15, 2016

Access denied for user ‘root’ using password

If you are getting this error message while accessing mysql from the shell then make sure that you have done
$su –
from the command prompt after that fire
even if you are getting that error message then you need to reset the mysql password you can use following steps for it

first locate your mysql’s file then

#kill `cat /mysql-data-directory/`
Stop MySQL

#service mysqld stop

#mysqld_safe –skip-grant-tables &
#mysqladmin -u root flush-privileges password “newpassword”

New password will be the password that you want to set now.

Leave a Comment