Most Effective Way To Reset Your Lost Password Or Forgotten Password Of MySQL.

You have to reset the password! steps for mac osx(tested and working) and Ubuntu

Stop MySQL

$ sudo /usr/local/mysql/support-files/mysql.server stop

Start mysql in safe mode:

$ sudo mysqld_safe –skip-grant-tables

(above line is one whole command)

This will be an ongoing command until the process is finished so open another shell/terminal window, log in without a password:

$ mysql -u root
mysql> UPDATE mysql.user SET Password=PASSWORD(‘password’) WHERE User=‘root’;

$ sudo /usr/local/mysql/support-files/mysql.server start

your new password is ‘password’.

Start a Conversation

Your email address will not be published. Required fields are marked *