MySQL报错:Can’tconnecttolocalMySQLserverthroughsocket‘/var/lib/mysql/mysql.sock’解决办法

53人阅读 评论(0) 收藏 举报
分类:

启动mysql 报错: 

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


刚开始学习MySQL时遇到的问题,后来发现是启动MySQL服务时权限不够 尴尬

1. sudo service mysql start 

2. mysql -u root -p

查看评论

MySQL数据库管理

这是关于MySQL dba的课程,从MySQL历史到适用场景到机器选型到备份优化到监控和HA等等。
  • 2015年01月08日 23:57

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock

[root@localhost template_c]# mysql -uroot -p Enter password: ERROR 2002 (HY000): Can't connect to lo...
  • zhezhebie
  • zhezhebie
  • 2017-06-26 19:05:14
  • 991

Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’解决方法

转自: http://www.cnblogs.com/eoiioe/archive/2008/12/28/1363947.html
  • u010956354
  • u010956354
  • 2014-09-10 17:15:23
  • 3230

zabbix到安装界面报错" Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock"

mysql和zabbix正常安装后在,zabbix安装页面(连接数据库的界面)时,提示“”Error connecting to database: Can't connect to local My...
  • wzqzhq
  • wzqzhq
  • 2017-02-21 13:48:04
  • 6479

zabbix启动web界面提示:Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

问题zabbix启动web界面提示:Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)...
  • lamyuqingcsdn
  • lamyuqingcsdn
  • 2016-08-08 11:06:41
  • 6428

解决mysql报错Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’

启动mysql 报错: ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysq...
  • chuang3344
  • chuang3344
  • 2017-06-27 23:16:50
  • 5153

zabbix安装 报错 socket '/var/lib/mysql/mysql.sock' (13)]

安装界面提示:Error connecting to database: Can't connect to local MySQL server through socket '/var/lib/my...
  • fanren224
  • fanren224
  • 2017-02-24 15:26:31
  • 205

MySQL连接报错:Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

MySQL连接报错:Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (111)报错原因 :...
  • a630895452
  • a630895452
  • 2017-08-20 02:52:12
  • 527

MYSQL启动异常:Can 't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock '(2) "

一次异常关机之后,再次启动mysql服务,报出异常Can 't connect to local MySQL server through socket '/var/lib/mysql/mysql.s...
  • lissdy
  • lissdy
  • 2014-04-17 23:15:43
  • 2093

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

mysql启动失败:Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) 10 请...
  • boshuzhang
  • boshuzhang
  • 2017-03-29 15:56:16
  • 535
    个人资料
    等级:
    访问量: 34
    积分: 51
    排名: 168万+
    阅读排行