How to remove MySQL root password

Question

I want to remove the password for user root in localhost  How can I do that  By mistake I have set the password of root user  That s why phpmyadmin is giving an error    1045 - Access denied for user  root   localhost   using password  NO

User · Answer

I have also been through this problem   First i tried setting my password of root to blank using command    SET PASSWORD FOR root localhost PASSWORD        But don t be happy   PHPMYADMIN uses 127 0 0 1 not localhost   i know you would say both are same but that is not the case   use the command mentioned underneath and you are done   SET PASSWORD FOR root 127 0 0 1 PASSWORD        Just replace localhost with 127 0 0 1 and you are done

User · Answer

You need to set the password for root localhost to be blank  There are two ways    The MySQL SET PASSWORD command   SET PASSWORD FOR root localhost PASSWORD       Using the command-line mysqladmin tool   mysqladmin -u root -pType in your current password here password

[mysql] How to remove MySQL root password

Examples related to mysql

Examples related to mysql-error-1045