2019年3月6日
mysqldump: Couldn't execute 'SHOW VARIABLES LIKE 'ndbinfo_version'': Native table 'performance_schema'.'session_variables' has the wrong structure (1682)
摘要： centos7.5 导出整个数据库报错 问题: [root@db01 ~] mysqldump uroot pBgx123.com all databases single transaction master data=1 flush logs /root/db_$(date +%F)_all.s 阅读全文
posted @ 2019-03-06 19:59 吕涵之 阅读(1996) 评论(0) 推荐(1) 编辑
ERROR 3009 (HY000): Column count of mysql.user is wrong. Expected 45, found 42. Created with MySQL 50560, now running 50725. Please use mysql_upgrade to fix this error.
摘要： centos7.5 登入mysql,进行授权报错 问题: mysql grant all privileges on . to 'lvhanzhi'@'%' identified by 'Bgx123.com'; ERROR 3009 (HY000): Column count of mysql.u 阅读全文
posted @ 2019-03-06 19:29 吕涵之 阅读(1892) 评论(0) 推荐(0) 编辑
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
摘要： centos7.5 连接数据库失败 问题: [root@jumpserver ~] mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) 阅读全文
posted @ 2019-03-06 15:04 吕涵之 阅读(4105) 评论(0) 推荐(0) 编辑