-
官网下载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 查询版本
网友评论