MySQL安装后出现
[root@raylocke etc]# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)MySQL server 应该已经启动起来来。以下是我安装server 后的情况,当然server 是在MySQL 客户端安装之前启动的。
[root@raylocke etc]# netstat -nat
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address State
tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN
tcp 0 0 127.0.0.1:631 0.0.0.0:* LISTEN
tcp 0 0 127.0.0.1:25 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:35043 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:111 0.0.0.0:* LISTEN
tcp 0 0 :::22 :::* LISTEN
tcp 0 0 ::1:631 :::* LISTEN
tcp 0 0 :::36759 :::* LISTEN
tcp 0 0 :::111 :::* LISTEN
我看MySQL 的默认端口是3306 ,而我的从上面的列表看来不是那个情况吧,应该怎么改阿
在网上看了好多解决方法,有好多是MySQL 启动后出问题了,好像不适合我的情况。我的 /etc/my.cnf 文件如下:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
另外:
我的/tmp中没有 mysql.sock
[root@raylocke etc]# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)MySQL server 应该已经启动起来来。以下是我安装server 后的情况,当然server 是在MySQL 客户端安装之前启动的。
[root@raylocke etc]# netstat -nat
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address State
tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN
tcp 0 0 127.0.0.1:631 0.0.0.0:* LISTEN
tcp 0 0 127.0.0.1:25 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:35043 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:111 0.0.0.0:* LISTEN
tcp 0 0 :::22 :::* LISTEN
tcp 0 0 ::1:631 :::* LISTEN
tcp 0 0 :::36759 :::* LISTEN
tcp 0 0 :::111 :::* LISTEN
我看MySQL 的默认端口是3306 ,而我的从上面的列表看来不是那个情况吧,应该怎么改阿
在网上看了好多解决方法,有好多是MySQL 启动后出问题了,好像不适合我的情况。我的 /etc/my.cnf 文件如下:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
另外:
我的/tmp中没有 mysql.sock
[root@wvlm mysql]# service mysqld start
Initializing MySQL database: [ OK ]
Starting MySQL: [ OK ]
试了各种方法,均无解!!
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)到底都是做什么的??
能用CMD本地登录不?
chkconfig --add mysqld 在服务清单中添加mysql服务
service mysqld start 服务启动
最后就可以使用了