当前位置: 首页 > 知识 >正文

解决不能通过mysql.sock连接MySQL问题的办法

解决MySQL无法通过mysql.sock连接的问题,主要提示是无法通过'/tmp/mysql.sock '连接服务器,php的标准配置只是使用'/tmp/mysql.sock '

但是有些mysql的安装方式是把mysql.sock放在/var/lib/mysql.sock或者其他地方。可以通过修改/etc/my.cnf文件来修改,打开文件可以看到以下内容:

[mysqld]

socket=/var/lib/mysql.sock

改了是好的,但是也会造成其他问题,比如mysql程序连不上。再补充一点:

[mysql]

socket=/tmp/mysql.sock

或者可以修改php.ini中的配置,使php与其他mysql.sock连接,我们自己去了解一下。

或者这样:

ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock

并且:

Phpmyadmin的说明说

The error message 'Warning: MySQL Connection Failed: Can't connect to local Mysql server through socket '/tmp/mysql.sock' (111).' is displayed. What can I do?

For RedHat users, Harald Legner suggests this on the mailing list:

On my RedHat-Box the socket of mysql is /var/lib/mysql/mysql.sock. In your php.ini you will find a line

mysql.default_socket=/tmp/mysql.sock

change it to

mysql.default_socket=/var/lib/mysql/mysql.sock

Then restart apache and it will work.

Here is a fix suggested by Brad Ummer in the phpwizard forum:

First, you need to determine what socket is being used by MySQL.

To do this, telnet to your server and go to the MySQL bin directory. In this directory there should be a file named mysqladmin. Type ./mysqladmin variables, and this should give you a bunch of info about your MySQL server, including the socket (/tmp/mysql.sock, for example).

Then, you need to tell PHP to use this socket.

Assuming you are using PHP 3.0.10 or better, you can specify the socket to use when you open the connection. To do this in phpMyAdmin, you need to complete the socket information in the config.inc.php

3.

For example: $cfg['Servers'][$i]['socket']='/tmp/mysql.sock'; (T113)

相关文章:
  • 4月17日基金净值:建信臻选混合最新净值0.8943,涨0.58%
  • 6月28日基金净值:创金合信竞争优势混合A最新净值0.7295,跌0.42%
  • 5月23日基金净值:易方达沪深300发起式ETF最新净值1.8647,跌1.41%
  • 5月23日基金净值:华夏中证500指数增强A最新净值1.7549,跌0.86%
  • 4月7日基金净值:华富安华债券A最新净值1.0567,涨0.42%_基金频道_证券之星
  • 7月10日基金净值:东方红创新趋势混合最新净值0.6383,跌0.28%
  • 一季报密集发布 基金经理热议“AI+”
  • 3月24日基金净值:建信新能源行业股票A最新净值1.8351,涨0.31%_基金频道_证券之星
  • 5月26日基金净值:东兴兴源债券A最新净值0.9901,涨0.01%
  • 7月6日基金净值:中邮稳定收益债券A最新净值1.093