macos – Reset MySQL root password using ALTER USER statement after install on Mac

macos – Reset MySQL root password using ALTER USER statement after install on Mac

If this is NOT your first time setting up the password, try this method:

mysql> UPDATE mysql.user SET Password=PASSWORD(your_new_password)
           WHERE User=root; 

And if you get the following error, there is a high chance that you have never set your password before:

ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement. 

To set up your password for the first time:

mysql> SET PASSWORD = PASSWORD(your_new_password);
Query OK, 0 rows affected, 1 warning (0.01 sec)

Reference: https://dev.mysql.com/doc/refman/5.6/en/alter-user.html

If you started mysql using mysql -u root -p

Try ALTER USER [email protected] IDENTIFIED BY MyNewPass;

Source: http://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html

macos – Reset MySQL root password using ALTER USER statement after install on Mac

I have same problem on Mac

First, log in mysql with sandbox mode

mysql -u <user> -p --connect-expired-password

Then, set password

SET PASSWORD FOR [email protected] = PASSWORD(XXXX);

Query OK, 0 rows affected, 1 warning (0.01 sec)

It works for me ~

via: https://dba.stackexchange.com/questions/118852/your-paswssword-has-expired-after-restart-mysql-when-updated-mysql-5-7-8-rcde

Leave a Reply

Your email address will not be published.