mysql5.6 Upgrade to 5.7 considerations

mysql5.6 Upgrade to 5.7 considerations

After the new upgrade of MySQL to 5.7, it was found that by default, if you do not make changes, you will find that the Telnet account before MySQL cannot log in.

Viewing the MySQL log shows a whole bunch of similar:

650) this.width=650; "Src=" Http://s1.51cto.com/wyfs02/M02/8A/B0/wKioL1g39MaBr70FAAJXQOC_ikU002.png-wh_500x0-wm_3 -wmp_4-s_1459966678.png "title=" QQ Pinyin ddfdfdf name. png "alt=" wkiol1g39mabr70faajxqoc_iku002.png-wh_50 "/>

Workaround:

Step1, upgrade data dictionary

The process of checking can be seen by executing mysql_upgrade.

Step2, restart MySQL

Note After restarting MySQL, check the error log for any errors.

STEP3, check before SQL user can log in

If you cannot log in, you need to drop the original user, re-create the account, and give the relevant database authorization.

Official Note: http://dev.mysql.com/doc/refman/5.7/en/upgrading-from-previous-series.html

mysql5.6 Upgrade to 5.7 considerations