mysql> update user set authentication_string=password(‘mysql123′) where user=’root’ ;
Query OK, 1 row affected, 1 warning (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)
mysql> exit
After changing the password and restarting, prompt this:
mysql> show databases ;
ERROR 1820 (HY000): Unknown error 1820
mysql> show databases;
ERROR 1820 (HY000): Unknown error 1820
mysql> select version();
ERROR 1820 (HY000): Unknown error 1820
You need to execute this command to change the password to take effect.
mysql> SET PASSWORD = PASSWORD(‘mysql123’) ;
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> flush privilges ;
ERROR 1064 (42000):
mysql> flush privileges ;
Query OK, 0 rows affected (0.00 sec)