|
|
|
|
|
|
| 常见的mysql错误：mysql error:2002 cann,t connect ... |
|
| 作者：武汉SEO闵涛 文章来源：敏韬网 点击数1082 更新时间：2009/4/22 20:48:41 文章录入：mintao 责任编辑：mintao |
|
|
|
安装完系统后,想看看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了,但是不知道具体是哪个步骤正确.
|
|
|
|
|
|
|
|
|
|
