ERROR 2002(HY000):Can't connect to local MySQL socket '/tmp/mysql.sock'
公司要使用MySQL,我就開始玩MySQL,可是跟想象中的不一樣,問題頗多,只能慢慢享受了。之前就透過編譯的方式安裝好MySQL5.7。
今天登陸的時候遇見一的問題,記錄一下
[root@testmysql bin]# ./mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
解決方法:
由於mysql 預設的mysql.sock 是在/usr/local/mysql/data/mysql.sock,但linux系統總是去/tmp/mysql.sock查詢,所以會報錯
1.直接指定mysql通道
據我知道的(ps:我是菜鳥,請糾正),老版本(5.4之前)的是:/var/lib/mysql/mysql.sock
在新版本中預設是在/usr/local/mysql/data/mysql.sock,具體的可以去檢視my.cnf檔案裡面
[root@testmysql bin]# ./mysql --socket=/usr/local/mysql/data/mysql.sock
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.4-m7 Source distribution
Copyright (c) 2000, 2011, 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>
2. 建立符號連線:
為mysql.sock增加軟連線(相當於windows中的快捷方式)。
ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
eg:
~]# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[root@testmysql bin]# ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
插曲:有可能你在建立連線的時候出現下面的情況,
[root@testmysql bin]# ln -vs /usr/local/mysql/data/mysql.sock /tmp/mysql.sock
ln: creating symbolic link `/tmp/mysql.sock': File exists
沒關係,加上-f引數就可以了。-f的主要過程:先將同名的軟連結dd刪除,然後再建立硬連結dd
[root@testmysql bin]# ln -f /usr/local/mysql/data/mysql.sock /tmp/mysql.sock
[root@testmysql bin]# ./mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.4-m7 Source distribution
Copyright (c) 2000, 2011, 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>
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/30936525/viewspace-2016620/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ERROR 2002 (HY000): Can't connect server socket /tmp/mysql.sockErrorServerMySql
- Can't connect to local MySQL server through socket '/tmp/mysql.sock'MySqlServer
- 解決Can 't connect to local MySQL server through socket '/tmp/mysql.sock '(2) "MySqlServer
- MySQL報錯'ERROR 2002 (HY000): Can't connect to local MySQL server through'MySqlErrorServer
- Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock錯誤MySqlServer
- linux下連線mysql報錯ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/var/lib/mysqLinuxMySqlErrorServer
- mysqldump: Got error: 2002: Can't connect to local MySQL server through.....MySqlGoErrorServer
- 更換mysql資料目錄後出現ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) 的解決辦法MySqlErrorServer
- ERROR 2002 (HY000): Can't connect server socket /var/run/mysqld/mysqld.sockErrorServerMySql
- Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)解決方法MySqlServer
- mysql 啟動報錯Can't connect to local MySQL server through socket '/data/mysql/mysql/mysql.sock'(111)MySqlServer
- MySQL連線提示Can't connect to local MySQL server through socketMySqlServer
- ERROR 2002 (HY000): Cant connect to local MySQL server through socket的解決方法ErrorMySqlServer
- MySQL 5.5 關閉資料庫報錯"Can't connect to local MySQL server through socket"MySql資料庫Server
- mysql [ERROR] Can't create IP socket: Permission deniedMySqlError
- ERROR 2003 (HY000)Can't connect to MySQL server on '192.168.8.247' (113)ErrorMySqlServer
- ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)ErrorMySqlServerlocalhost
- mysql can't connect error about privilege----not root userMySqlError
- 【MySQL】ERROR 1005 (HY000): Can't create table' (errno: 150)MySqlError
- error:'Can'tconnecttolocalMySQLserverthroughsocket'/var/lib/mysql/mysql.sock'(2)'ErrorMySqlServer
- MYSQL ERROR 2003 (HY000) CanMySqlError
- ERROR 1135 (HY000): Can't create a new threadErrorthread
- [ERROR] Can't open the mysql.plugin tableErrorMySqlPlugin
- MySQL "ERROR 1010(HY000):Error dropping database(canMySqlErrorDatabase
- MySQL 5.7向表匯入資料包錯"ERROR 13 (HY000): Can't get stat of"MySqlError
- Error:Can't connect to SOCKS proxy:Connection refused (Connection refused)Error
- ERROR 1135 (HY000): Can't create a new thread (errno 11)Errorthread
- 異常:Can't connect to MySQL server (10060)MySqlServer
- ERROR 1005 (HY000): Can't create table 'starive.SC' (errno: 150)"Error
- 連線MySQL錯誤:Can't connect to MySQL server (10060)MySqlServer
- [ERROR] mysqld: Can‘t open shared library ‘/usr/local/mysql/lib/plugin/validate_password.so‘ (errno:ErrorMySqlPlugin
- Mysql報錯Fatal error:Can't open and lock privilege tablesMySqlError
- MySQL5.6:mysql_secure_installation 報錯ERROR 2002 (HY000)MySqlError
- Can'tconnecttolocalMySQLserverthroughsocket'/var/lib/mysql/mysql.sock'(2)MySqlServer
- ERROR 1005 (HY000): Can't create table'matrix.system_log' (errno: 150)Error
- [root@mastermysql]#mysql-uroot-pjsbERROR2002(HY000):Can'tconnecttolocalMySQLserverthroASTMySqlJSErrorServer
- Error!: SQLSTATE[HY000] [2002] Connection refusedErrorSQL
- [jenkins]Can’t connect to window server – not enough permissionsJenkinsServer