Mysql笔记

1.还原数据库时，数据包过大无法还原，需要设置set global max_allowed_packet = 200*1024*1024*10;

2.给账户赋XA权限GRANT XA_RECOVER_ADMIN ON *.* TO 'root'@'%';

3.升级数据库之后升级数据表 mysql_upgrade -u root -p ，否则创建账户和赋权操作不成功，

　　grant all privileges on *.* to test@localhost identified by "test" ;

　　grant all privileges on *.* to test@"%" identified by "test" ;