金莎娱乐手机版ETiggoROENCORE 二〇〇四 (HY000卡塔尔: Cant connect to local MySQL server through socket /var/lib/mysql/mysql.sock

Enter password:

Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2),connectmysql.sock

检查配置文件/etc/my.cnf发现供应商修改了mysql数据库的数据存储目录,另外mysql.sock文件位置也变更为了/dat/data/mysql/mysql.sock

第一种方法,修改my.cnf的配置项,修改到'/var/lib/mysql/mysql.sock‘
第二种方法:建立mysql.sock文件的软连接

$ more /etc/my.cnf

# For advice on how to change settings please see

# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html

 

[mysqld]

#

# Remove leading # and set to the amount of RAM for the most important data

# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.

# innodb_buffer_pool_size = 128M

innodb_buffer_pool_size = 2048M

 

#

# Remove leading # to turn on a very important data integrity option: logging

# changes to the binary log between backups.

# log_bin

#

# Remove leading # to set options mainly useful for reporting servers.

# The server defaults are faster for transactions and fast SELECTs.

# Adjust sizes as needed, experiment to find the optimal values.

# join_buffer_size = 128M

# sort_buffer_size = 2M

# read_rnd_buffer_size = 2M

#datadir=/var/lib/mysql

#socket=/var/lib/mysql/mysql.sock

 

datadir=/dat/data/mysql

socket=/dat/data/mysql/mysql.sock

 

# Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0

 

# Recommended in standard MySQL setup

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 

 

[mysqld_safe]

log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid

反省开掘/var/lib/mysql.sock文件不真实,能够经过成立mysql.sock文件的软连接。然后登陆数据库,难题消除。

[[email protected] ~]# ls /var/lib/mysql.sock

 

ls: cannot access /var/lib/mysql.sock: No such file or director

 

[[email protected] ~]# ln -s /dat/data/mysql/mysql.sock /var/lib/mysql/mysql.sock

connect to local MySQL server through socket
/var/lib/mysql/mysql.sock (2State of Qatar,connectmysql.sock
检查安排文件/etc/my.cnf开掘供应商改过了mysql数据库的数据存储…

金莎娱乐手机版 1

$ more /etc/my.cnf

# For advice on how to change settings please see

# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html

 

[mysqld]

#

# Remove leading # and set to the amount of RAM for the most important data

# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.

# innodb_buffer_pool_size = 128M

innodb_buffer_pool_size = 2048M

 

#

# Remove leading # to turn on a very important data integrity option: logging

# changes to the binary log between backups.

# log_bin

#

# Remove leading # to set options mainly useful for reporting servers.

# The server defaults are faster for transactions and fast SELECTs.

# Adjust sizes as needed, experiment to find the optimal values.

# join_buffer_size = 128M

# sort_buffer_size = 2M

# read_rnd_buffer_size = 2M

#datadir=/var/lib/mysql

#socket=/var/lib/mysql/mysql.sock

 

datadir=/dat/data/mysql

socket=/dat/data/mysql/mysql.sock

 

# Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0

 

# Recommended in standard MySQL setup

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 

 

[mysqld_safe]

log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid

  >mysqld_safe &

自己斟酌安插文件/etc/my.cnf开采代理商改正了mysql数据库的数额存款和储蓄目录,其它mysql.sock文件地方也改造为了/dat/data/mysql/mysql.sock

  显示为空,未查询到mysql.sock文件,mysql.sock文件遗失了。

从当中间商手中接任一个云平台(Windwos
Azure)上的MySQL数据库,登陆数据库时遇上错误:

  >chown -R mysql:mysql /……/mysql/var

反省发现/var/lib/mysql.sock文件空中楼阁,能够经过创设mysql.sock文件的软连接。然后登入数据库,难题解决。

  在错误日志中,运维退步的案由极为鲜明,file ‘./mysql-bin。000004’ not
found,failed to open金莎娱乐手机版,!

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

  STOPPING server from pid file …….pid

$mysql -uroot -p

  于是,我检察mysql状态:

[root@GETAZLNX005 ~]# ls /var/lib/mysql.sock

 

ls: cannot access /var/lib/mysql.sock: No such file or director

 

[root@GETAZLNX005 ~]# ln -s /dat/data/mysql/mysql.sock /var/lib/mysql/mysql.sock

  小编起来排错,首先开掘/tmp/mysql.sock子虚乌有

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

  消亡这几个似是而非相当粗略,因为/tmp/mysql.sock不设有,用那样的措施:

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

  Starting mysqld: [ OK]

  root 28221 27474 0 14:18 pts/0 00:00:00 grep mysql 独有这一条

  Stopping mysqld: [ OK ]

金莎娱乐手机版 2

  Starting mysqld: [ FAILED]

  正是如此一个难点折腾了自己这么久,错误日志让它无所遁形。查看错误日志能够明显难点所在,实际不是像本身事情未发生前那么盲目标找错。

  笔者看网络有的人讲mysql.sock套接字文件可以回顾地通过重启服务注重新创建拿到它,

相关文章