Can’t connect to local MySQL server through socket 解决办法

原创 2012年03月29日 13:30:33

启动mysql 报错:

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

1、先查看 /etc/rc.d/init.d/mysqld status 看看m y s q l 是否已经启动.
另外看看是不是权限问题.

2、确定你的mysql.sock是不是在那个位置,
mysql -u 你的mysql用户名 -p -S /var/lib/mysql/mysql.sock

3、试试:service mysqld start

4、如果是权限问题,则先改变权限 #chown -R mysql:mysql /var/lib/mysql

[root@localhost ~]# /etc/init.d/mysqld start
启动 MySQL: [ 确定 ]
[root@localhost ~]# mysql -uroot -p

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
原因是,/var/lib/mysql 的访问权限问题。

shell> chown -R mysql:mysql /var/lib/mysql

接着启动服务器

shell> /etc/init.d/mysql start

服务器正常启动后察看 /var/lib/mysql 自动生成mysql.sock文件。

但是我的问题仍然没有得到解决。

问题终于解决:
方法:    修改/etc/my.conf:
[mysqld]
datadir=/usr/local/mysql/data
socket=/var/lib/mysql/mysql.sock

[mysql.server]
user=mysql
basedir=/usr/local/mysql

If there is not currently a section called [client], add one at the bottom of the file and copy the socket= line under the [mysqld] section such as:

[client]
socket=/var/lib/mysql/mysql.sock


发现依旧如此,运行/etc/init.d/mysql start报错:    Starting MySQLCouldn't find MySQL manager or server
是mysqld服务没启,运行/usr/local/mysql/bin/mysqld_safe &

问题解决。


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

今天遇到 Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ 这个问题,在网上也找了一些相关的...

Linux上mysql登陆错误解决办法ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/

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

Linux下Mysql数据库 Can 't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock '

Mysql数据库安装到Linux的时候会在linux建立一个名为mysqld的服务。 可以使用命令:chkconfig --list ,查看linux系统中所有的服务。 可以看到上图倒...

MySQL安装和报错的解决'Can't connect to local MySQL server through socket

1、在光盘中找到MySQL的安装包一共有10个,但比并需要都安装。 libdbi-dbd-mysql-0.8.3-1.fc9.i386.rpm mysql-libs-5.0.51a-1.f...

MySQL 2002问题解决方案 - Can't connect to local MySQL server through socket...

mysql,mysqldump,mysqldump,php连接mysql服务常会提示下面错误:ERROR 2002 (HY000): Can't connect to local MySQL serv...

配置mysql默认编码格式 && 解决Can't connect to local MySQL server through socket 问题

配置mysql默认编码格式 Linux连接MySQL时的错误:Can’t connect to local MySQL server through socket ‘/var/run/mysqld/m...

启动SQL提示"Can't connect to local MySQL server through socket '/tmp/mysql.sock"参考解决方案

写了个脚本可以定时访问本地安装的mySQL,启动本地sql时,突然报下面错误: ERROR 2002 (HY000): Can't connect to local MySQL server ...
  • lizitao
  • lizitao
  • 2016年11月17日 14:09
  • 2092

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

本文摘自:http://blog.csdn.net/lmss82/article/details/4414178 输入 #mysql -u root -p   ERROR 2002 (HY00...

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'

今天服务器遇到了一个很熟悉的问题 输入 #mysql -u root -p ERROR 2002 (HY000):Can't connect to local MySQL server 随即上网找寻答...

关于 Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock的问题

我们在输入命令 mysq -u用户名 -p密码 时,会出现一些链接问题,本文参考网上之后,大概的解决流程,比较详细,希望能给大家一些帮助。...
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:Can’t connect to local MySQL server through socket 解决办法
举报原因:
原因补充:

(最多只允许输入30个字)