Chat with us, powered by LiveChat
Access denied for user ‘root’@’localhost’ (using password: NO)

Access denied for user ‘root’@’localhost’ (using password: NO)

If you are getting the above mentioned error message while accessing mysql from the shell then make sure that you have done

su –

from the command prompt after that fire

mysql

if still you are getting that error message then you need to reset the mysql password

To reset the mysql password you can use following steps:

first locate your mysql hostname.pid file then

kill `cat /mysql-data-directory/host_name.pid`
mysqld_safe “skip-grant-tables &
mysqladmin -u root flush-privileges password newpassword

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

Sharing

Leave your comment

Pin It on Pinterest

Share This