MySQL报错'ERROR 2002 (HY000): Can't connect to local MySQL server through'

我会带着你远行 2024-04-18 01:29 106阅读 0赞

登陆数据库保存  
\[root@localhost Percona-Server-5.6.34-rel79.1-Linux.x86\_64.ssl101\]\# bin/mysql -h localhost -P 3306 -uroot  \-p  
Enter password:   
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)  
  
 查看数据库用户

在MySQL中，需要使用socket方式连接localhost；而当使用-h选项登陆数据库时，后面接的应该是IP地址或主机名。  
   
查询socket   
\[root@localhost Percona-Server-5.6.34-rel79.1-Linux.x86\_64.ssl101\]\# ps -ef|grep mysql  
root      2940  2917  0 15:31 pts/0    00:00:00 /bin/sh bin/mysqld\_safe --defaults-file=/u01/mysql\_data/my.cnf  
mysql     3837  2940  0 15:31 pts/0    00:00:07 /mysql5.6/Percona-Server-5.6.34-rel79.1-Linux.x86\_64.ssl101/bin/mysqld --defaults-file=/u01/mysql\_data/my.cnf --basedir=/database/percona --datadir=/u01/mysql\_data --plugin-dir=/database/percona/lib/mysql/plugin --user=mysql --log-error=/u01/mysql\_data/mysqld\_error.log --open-files-limit=8192 --pid-file=/u01/mysql\_data/localhost.localdomain.pid --socket=/u01/mysql\_data/mysql.sock --port=3306  
root      5346  2917  0 17:05 pts/0    00:00:00 grep mysql  
  
使用-S连接socket的方式登录数据库  
\[root@localhost Percona-Server-5.6.34-rel79.1-Linux.x86\_64.ssl101\]\# bin/mysql \-S /u01/mysql\_data/mysql.sock -uroot -p  
Enter password:   
Welcome to the MySQL monitor.  Commands end with ; or \\g.  
Your MySQL connection id is 29  
Server version: 5.6.34-79.1-log Percona Server (GPL), Release 79.1, Revision 1c589f9  
  
Copyright (c) 2009-2016 Percona LLC and/or its affiliates  
Copyright (c) 2000, 2016, 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.  
  
使用-h接主机名的方式连接到数据库  
\[root@localhost Percona-Server-5.6.34-rel79.1-Linux.x86\_64.ssl101\]\# bin/mysql -h localhost.localdomain -P 3306 -uroot -p  
Enter password:  
Welcome to the MySQL monitor.  Commands end with ; or \\g.  
Your MySQL connection id is 30  
Server version: 5.6.34-79.1-log Percona Server (GPL), Release 79.1, Revision 1c589f9  
  
Copyright (c) 2009-2016 Percona LLC and/or its affiliates  
Copyright (c) 2000, 2016, 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.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26506993/viewspace-2137045/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26506993/viewspace-2137045/