美文网首页
mysql小版本升级 5.7.31到5.7.36

mysql小版本升级 5.7.31到5.7.36

作者: 络筱矶 | 来源:发表于2021-11-17 11:29 被阅读0次
    1. 官网下载5.7.36 linux 版本

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

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

    4. 如果报错: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;

    5. mysql -V 查询版本

    相关文章

      网友评论

          本文标题:mysql小版本升级 5.7.31到5.7.36

          本文链接:https://www.haomeiwen.com/subject/qngxuhtx.html