随笔分类 - mysql
摘要:创建用户创建失败。报错ERROR 1728 (HY000): Cannot load from mysql.procs_priv. The table is probably corrupted 【解决办法】:在命令行中执行mysql_upgrade -uroot -p 即可~
阅读全文
摘要:安装查找mysql相关安装并卸载rpm -qa|grep -i mysqlrpm –ev {包名},如:rpm -ev mysql-community-common-5.7.23-1.el7.x86_64 解压mysql安装包shell> tar xzvf mysql-5.7.31-linux-gl
阅读全文
摘要:#!/bin/bashdate=KaTeX parse error: Expected group after '_' at position 151: …sql/backup/full_̲date.sql if [ $? -eq 0 ];then echo “数据备份完成” scp /softwa
阅读全文