mysql小版本升级 5.7.31到5.7.36

官网下载5.7.36 linux 版本

停掉MySQL 并备份原有数据库/bin目录下所有文件

替换/bin目录下所有文件并重启mysql

如果报错：session权限不够，执行下列语句查询并修改表数据
SELECT SUM(count)=3 FROM ( SELECT COUNT() as count FROM mysql.tables_priv WHERE Table_priv='Select' and User='mysql.session' and Db='mysql' and Table_name='user' UNION ALL SELECT COUNT() as count FROM mysql.db WHERE Select_priv='Y' and User='mysql.session' and Db='performance_schema' UNION ALL SELECT COUNT(*) as count FROM mysql.user WHERE Super_priv='Y' and User='mysql.session') as user_priv;

mysql -V 查询版本