Chapter 5.  Solve error
Prev   Next

Chapter 5.  Solve error

Table of Contents

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
复制data文件夹方式复制数据库出现找不到数据库的问题
启动时错误：Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13)

常见问题的解决

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) 


   1. 权限问题：有很多人直接输入mysql 而用户列表里不存在密码为空的root用户，所以报此错误
   2. 这是没启动mysql的守护进程，执行service mysqld start就行了
Prev   Next
创建索引和删除索引  Home  复制data文件夹方式复制数据库出现找不到数据库的问题