常见的mysql错误：mysql error:2002 cann,t conn..

时间：2008-05-24 来源：sdccf

来源：obwind的 Blog 作者：obwind的 Blog

">安装完系统后,想看看mysql行不行:

[root@obwind root]# mysql
ERROR 2002: Can''''t connect to local MySQL server through socket ''''/var/lib/mysql/mysql.sock'''' (2)

然后到开始菜单的系统设置里面,打开服务,但是没有mysqld这个服务.

听说是因为权限原因,需要mysql的用户组才可以启动server.

1.
[root@obwind root]# chmod 640 /etc/my.cnf
[root@obwind root]# chmod 644 /etc/my.cnf

这个时候还是提示同样错误

2.
[root@obwind root]# mysqladmin --print-defaults
mysqladmin would have been started with the following arguments:

然后:

[root@obwind root]# mysqladmin --socket=/tmp/mysqld.sock version
mysqladmin: connect to server at ''''localhost'''' failed
error: ''''Can''''t connect to local MySQL server through socket ''''/tmp/mysqld.sock'''' (2)''''
Check that mysqld is running and that the socket: ''''/tmp/mysqld.sock'''' exists!

看来还是不行...

这个时候进服务里面看,有了mysqld这个选项,打勾然后启动后:

[root@obwind cdrom]# mysql
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 3 to server version: 3.23.58

Type ''''help;'''' or ''''h'''' for help. Type ''''c'''' to clear the buffer.

mysql> quit
Bye

终于OK了,但是不知道具体是哪个步骤正确.

相关阅读更多 +