• Register
Welcome to Kodlogs, programming questions and answer website.
0 votes
7 views

Solution:

 I am on Mac and installed MySQL and as password reset is required after install, i followed following lines:

update user set password = password('XXX') where user = root;

     But i get message saying that:

       "You must reset your password using ALTER USER statement before executing this statement."

by (550 points)  

1 Answer

0 votes

Solution:

        Try following commands

        mysql> alter user 'root'@'localhost' identified by 'root'

        mysql> flush privileges;

by (3.5k points)  
...