导入存储过程时报错:
Cannot load from mysql.proc. The table is probably corrupted
这是由于mysql更新不完整导致的问题,
执行:mysql_upgrade -u root -p --force
Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) while connecting to the MySQL server
首先查看mysql.sock 是否存在
find / -name mysql.sock
如果存在/var/lib/mysql/mysql.sock
只需要修改my.cnf文件即可
[client]
default-character-set = utf8
port = 3306
socket = /var/lib/mysql/mysql.sock
修改完成后重启mysql
然后再执行升级,就可以成功导入存储过程了。
网友评论