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