performance_schema 修复

/usr/local/mysql/bin/mysql_upgrade -h127.0.0.1 -uroot -p'111111'

ibdata1文件占用过大瘦身

mysqldump -uroot -ppassword --all-databases  > all_mysql.sql 
innodb_file_per_table=1
rm -rf ibdata1
rm -rf ib_logfile*
source all_mysql.sql

IP address 'xxxx' could not be resolved: Name or service not known

[mysqld]
skip-name-resolve

TIMESTAMP with implicit DEFAULT value is deprecated

[mysqld]
explicit_defaults_for_timestamp=true