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

王朝mysql·作者佚名  2006-01-10
窄屏简体版  字體: |||超大  

安装完系统后,想看看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了,但是不知道具体是哪个步骤正确.

 
 
 
免责声明:本文为网络用户发布,其观点仅代表作者个人观点,与本站无关,本站仅提供信息存储服务。文中陈述内容未经本站证实,其真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
© 2005- 王朝網路 版權所有 導航