Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

tianyadic

系统发生错误

[ 错误信息 ]

Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

怎么办啊

sonyr

mysql-restart
注意把工具的字符集换成utf-8看提示

tianyadic

120130 18:33:35 mysqld_safe Logging to '/home/mysql_data/02_01.y2yy1314.13638674295.err'.
120130 18:33:35 mysqld_safe Starting mysqld daemon with databases from /home/mysql_data
120130 18:33:35 mysqld_safe mysqld from pid file /home/mysql_data/02_01.y2yy1314.13638674295.pid ended

MySQL 启动成功！
MySQL was started successfully.
[root@02_01 cmd]# 120130 18:33:38 mysqld_safe Logging to '/home/mysql_data/02_01.y2yy1314.13638674295.err'.
120130 18:33:38 mysqld_safe Starting mysqld daemon with databases from /home/mysql_data
120130 18:33:38 mysqld_safe mysqld from pid file /home/mysql_data/02_01.y2yy1314.13638674295.pid ended

tianyadic

就这还是启动不了

tianyadic

错误文件：


120130 18:33:35 mysqld_safe Starting mysqld daemon with databases from /home/mysql_data
Unknown suffix 'B' used for variable 'query_cache_size' (value '0B')
120130 18:33:35 [ERROR] /usr/local/mysql/bin/mysqld: Error while setting value '0B' to 'query_cache_size'
120130 18:33:35 [ERROR] Aborting

120130 18:33:35 mysqld_safe mysqld from pid file /home/mysql_data/02_01.y2yy1314.13638674295.pid ended
120130 18:33:38 mysqld_safe Starting mysqld daemon with databases from /home/mysql_data
Unknown suffix 'B' used for variable 'query_cache_size' (value '0B')
120130 18:33:38 [ERROR] /usr/local/mysql/bin/mysqld: Error while setting value '0B' to 'query_cache_size'
120130 18:33:38 [ERROR] Aborting

120130 18:33:38 mysqld_safe mysqld from pid file /home/mysql_data/02_01.y2yy1314.13638674295.pid ended

爱洞特漏

编辑一下/etc/my.cnf，把含有0B的那行去掉，然后重启mysql
然后再升级到2.0.28

tianyadic

头疼的问题终于搞定了 谢谢老大

清净心-国丰

把含有0B的那行去掉     没找到这个啊

天下lee

爱洞特漏 发表于 2012-1-30 23:46
编辑一下/etc/my.cnf，把含有0B的那行去掉，然后重启mysql
然后再升级到2.0.28

把含有0B的那行去掉     没找到这个啊