紫苏水釉吧 关注:4贴子:143
  • 0回复贴,共1

Can't connect to local MySQL server through socket '/tmp/mys

只看楼主收藏回复

查看mysql 进程
linux-4pi9:/opt/mysql-5.1.30-linux-x86_64-glibc23/bin # ps -ef |grep mysql
root 3257 25233 0 19:26 pts/2 00:00:00 grep mysql
root 30829 1 0 18:29 ? 00:00:00 /bin/sh /opt/mysql-5.1.30-linux-x86_64-glibc23/bin/mysqld_safe --defaults-file=/opt/mysql-5.1.30-linux-x86_64-glibc23/my.cnf --datadir=/opt/mysql-5.1.30-linux-x86_64-glibc23/data --pid-file=/opt/mysql-5.1.30-linux-x86_64-glibc23/data/linux-4pi9.pid --user=mysql
mysql 30943 30829 0 18:29 ? 00:00:01 /opt/mysql-5.1.30-linux-x86_64-glibc23/bin/mysqld --defaults-file=/opt/mysql-5.1.30-linux-x86_64-glibc23/my.cnf --basedir=/opt/mysql-5.1.30-linux-x86_64-glibc23 --datadir=/opt/mysql-5.1.30-linux-x86_64-glibc23/data --user=mysql --log-error=/opt/mysql-5.1.30-linux-x86_64-glibc23/data/linux-4pi9.err --pid-file=/opt/mysql-5.1.30-linux-x86_64-glibc23/data/linux-4pi9.pid --socket=/tmp/my_mysql.sock --port=3309
登陆时候带上参数(上面查出来的)
mysql -u root -proot123 --socket=/tmp/my_mysql.sock


IP属地:江苏1楼2015-01-14 11:28回复