这个错误怎么解决啊

levelhy

如果实在搞不定的话，可以在my.cnf里增加一个参数，绕过这个错误

[mysqld]
skip-name-resolve

yhqtxy1314

各位，我昨天也遇到类似的问题，是在我修改了mysql data的路径后出现的
[root@localhost mysql]# cd /var/lib/mysql/
[root@localhost mysql]# ll
总计 110760
-rw-rw---- 1 mysql mysql       56 05-13 15:44 auto.cnf
-rw-rw---- 1 mysql mysql 12582912 05-13 16:20 ibdata1
-rw-rw---- 1 mysql mysql 50331648 05-13 16:20 ib_logfile0
-rw-rw---- 1 mysql mysql 50331648 05-13 14:59 ib_logfile1
-rw-r----- 1 mysql mysql    19668 05-13 16:47 localhost.localdomain.err
-rw-rw---- 1 mysql mysql        6 05-13 16:20 localhost.localdomain.pid
drwx--x--x 2 mysql mysql     4096 05-13 14:59 mysql
srwxrwxrwx 1 mysql mysql        0 05-13 16:20 mysql.sock
drwx------ 2 mysql mysql     4096 05-13 14:59 performance_schema
-rw-r--r-- 1 mysql mysql      686 05-13 16:10 RPM_UPGRADE_HISTORY
-rw-r--r-- 1 mysql mysql      565 05-13 16:10 RPM_UPGRADE_MARKER-LAST
drwxr-xr-x 2 mysql mysql     4096 05-13 14:59 test
[root@localhost mysql]# pwd
/var/lib/mysql
[root@localhost mysql]# cd /mountdisk2/mysql/
[root@localhost mysql]# ll
总计 672996
-rw-r--r-- 1 root root  22916652 04-10 10:34 MySQL-client-advanced-5.6.18-1.rhel5.i386.rpm
-rw-r--r-- 1 root root   4195753 04-10 10:34 MySQL-devel-advanced-5.6.18-1.rhel5.i386.rpm
-rw-r--r-- 1 root root 110099842 04-10 10:34 MySQL-embedded-advanced-5.6.18-1.rhel5.i386.rpm
-rw-r--r-- 1 root root  95567627 04-10 10:34 MySQL-server-advanced-5.6.18-1.rhel5.i386.rpm
-rw-r--r-- 1 root root   2447323 04-10 10:34 MySQL-shared-advanced-5.6.18-1.rhel5.i386.rpm
-rw-r--r-- 1 root root   5439467 04-10 10:34 MySQL-shared-compat-advanced-5.6.18-1.rhel5.i386.rpm
-rw-r--r-- 1 root root  74070430 04-10 10:35 MySQL-test-advanced-5.6.18-1.rhel5.i386.rpm
-rw-r--r-- 1 root root  29459708 04-14 08:59 mysql-workbench-commercial-6.1.5-1.el6.i686.rpm
-rw-r--r-- 1 root root       990 04-14 18:22 README.txt
-rw-r--r-- 1 root root      1137 04-15 21:35 rname
-rw-r--r-- 1 root root 314739376 05-12 15:45 V44511-01.zip
-rw-r--r-- 1 root root  29461133 05-12 15:46 V44603-01.zip
[root@localhost mysql]# mkdir mysqldata
[root@localhost mysql]# mysqladmin -u root -p shutdown
Enter password:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'
[root@localhost mysql]# mysqladmin -u root -p shutdown
Enter password:
[root@localhost mysql]# mv /var/lib/mysql /mountdisk2/mysql/mysqldata

找到[root@localhost etc]# cd /usr/share/mysql/
*文件.cnf
[root@localhost mysql]# cp my-default.cnf /etc/my.cnf
[root@localhost mysql]# vi /etc/my.cnf
port = 3306
     #server_id = .....
     # socket = .....
#socket= /mountdisk2/mysql/mysqldata/mysql.sock
socket= /mountdisk2/mysql/mysqldata/mysql/mysql.sock
修改mysql启动脚本
[root@localhost mysql]# vi /etc/rc.d/init.d/mysql
#--datadir=/mountdisk2/mysql
datadir=/mountdisk2/mysql/mysqldata/mysql

------------------------------

[root@localhost mysqldata]# mysql -u root -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
telnet: Unable to connect to remote host: Connection refused
[root@localhost mysqldata]# telnet 127.0.0.1 3306
Trying 127.0.0.1...
Connected to 127.0.0.1 (127.0.0.1).
Escape character is '^]'.
i
5.6.18-enterprise-commercial-advancedH]}{qFH

yhqtxy1314

[root@localhost mysqldata]# mysql -u mysql -p 'mysql' -h 127.0.0.1 -P 3306
Enter password:
ERROR 1045 (28000): Access denied for user 'mysql'@'127.0.0.1' (using password: YES)
[root@localhost mysqldata]# mysql -h 127.0.0.1 -P 3306 -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.6.18-enterprise-commercial-advanced

Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show database;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| test               |
+--------------------+
4 rows in set (0.05 sec)

clientor

通过 tcp/ip 登陆，或者用 -S 指定socket 文件路径。