ERROR 1820 (HY000): You must reset your password using ALTER USER statement befo

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

°²×°Íêmysql Ö®ºó，µÇ½ÒÔºó，²»¹ÜÔËÐÐÈκÎÃüÁî，×ÜÊÇÌáʾÕâ¸ö

Ö´ÐÐÈçÏÂÃüÁî

step 1: SET PASSWORD = PASSWORD('your new password');

step 2: ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;

step 3: flush privileges;