ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

  • Mac OS 無法連接mysql宏所,報錯如下:
xiaoyuan:~ xiaoyuan$ mysql -uroot;
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

  • 解決方法:
    經(jīng)排查命咐,發(fā)現(xiàn)/tmp/mysql.sock不存在。

mysqld.sock是mysql啟動以后自動生成的文件乙各,關閉MySQL服務后墨礁,這個文件又會被刪除。如果MySQL啟動異常觅丰,就有可能不生成這個文件饵溅,登錄的時候就會出現(xiàn)你這個錯誤。

可能是mysql未啟動妇萄,嘗試啟動:

sudo mysql.server start

如果無法啟動mysql蜕企,執(zhí)行以下操作
在終端中輸入

mysqld

結果

xiaoyuan:~ xiaoyuan$ mysqld
2019-05-20T04:25:34.410225Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-05-20T04:25:34.411304Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2019-05-20T04:25:34.411376Z 0 [Note] mysqld (mysqld 5.7.25) starting as process 6587 ...
2019-05-20T04:25:34.423971Z 0 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/var/mysql/ is case insensitive
2019-05-20T04:25:34.427017Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-05-20T04:25:34.427066Z 0 [Note] InnoDB: Uses event mutexes
2019-05-20T04:25:34.427073Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2019-05-20T04:25:34.427079Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-05-20T04:25:34.428012Z 0 [Note] InnoDB: Number of pools: 1
2019-05-20T04:25:34.428178Z 0 [Note] InnoDB: Using CPU crc32 instructions
2019-05-20T04:25:34.430772Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2019-05-20T04:25:34.445398Z 0 [Note] InnoDB: Completed initialization of buffer pool
2019-05-20T04:25:34.468575Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2019-05-20T04:25:34.521308Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-05-20T04:25:34.521509Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-05-20T04:25:34.565599Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2019-05-20T04:25:34.566708Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2019-05-20T04:25:34.566730Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2019-05-20T04:25:34.567038Z 0 [Note] InnoDB: Waiting for purge to start
2019-05-20T04:25:34.618519Z 0 [Note] InnoDB: 5.7.25 started; log sequence number 2524176
2019-05-20T04:25:34.619078Z 0 [Note] InnoDB: Loading buffer pool(s) from /usr/local/var/mysql/ib_buffer_pool
2019-05-20T04:25:34.619348Z 0 [Note] Plugin 'FEDERATED' is disabled.
2019-05-20T04:25:34.636033Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2019-05-20T04:25:34.636060Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2019-05-20T04:25:34.639962Z 0 [Warning] CA certificate ca.pem is self signed.
2019-05-20T04:25:34.640263Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2019-05-20T04:25:34.672800Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2019-05-20T04:25:34.672873Z 0 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
2019-05-20T04:25:34.672989Z 0 [Note] Server socket created on IP: '127.0.0.1'.
2019-05-20T04:25:34.696092Z 0 [Note] InnoDB: Buffer pool(s) load completed at 190520 12:25:34
2019-05-20T04:25:34.791494Z 0 [Note] Event Scheduler: Loaded 0 events
2019-05-20T04:25:34.791687Z 0 [Note] mysqld: ready for connections.
Version: '5.7.25'  socket: '/tmp/mysql.sock'  port: 3306  Homebrew

最后再輸入:

sudo mysqld_safe

結果:

sudo mysqld_safexiaoyuan:~ xiaoyuan$ sudo mysqld_safe
Password:
2019-05-20T04:36:23.6NZ mysqld_safe Logging to '/usr/local/var/mysql/xiaoyuan.local.err'.
2019-05-20T04:36:23.6NZ mysqld_safe Starting mysqld daemon with databases from /usr/local/var/mysql
2019-05-20T04:36:23.6NZ mysqld_safe mysqld from pid file /usr/local/var/mysql/xiaoyuan.local.pid ended

再連接mysql咬荷,問題解決:

xiaoyuan:~ xiaoyuan$ mysql -uroot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.25 Homebrew

Copyright (c) 2000, 2019, 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 root用戶的密碼
mysql>  set password for 'root'@'localhost' = password('root');

作者:多網(wǎng)
鏈接:http://www.reibang.com/p/d9790602b9d5
來源:簡書
著作權歸作者所有。商業(yè)轉載請聯(lián)系作者獲得授權轻掩,非商業(yè)轉載請注明出處幸乒。

?著作權歸作者所有,轉載或內容合作請聯(lián)系作者
  • 序言:七十年代末,一起剝皮案震驚了整個濱河市唇牧,隨后出現(xiàn)的幾起案子罕扎,更是在濱河造成了極大的恐慌,老刑警劉巖丐重,帶你破解...
    沈念sama閱讀 222,681評論 6 517
  • 序言:濱河連續(xù)發(fā)生了三起死亡事件腔召,死亡現(xiàn)場離奇詭異,居然都是意外死亡扮惦,警方通過查閱死者的電腦和手機臀蛛,發(fā)現(xiàn)死者居然都...
    沈念sama閱讀 95,205評論 3 399
  • 文/潘曉璐 我一進店門,熙熙樓的掌柜王于貴愁眉苦臉地迎上來崖蜜,“玉大人浊仆,你說我怎么就攤上這事≡チ欤” “怎么了抡柿?”我有些...
    開封第一講書人閱讀 169,421評論 0 362
  • 文/不壞的土叔 我叫張陵,是天一觀的道長等恐。 經(jīng)常有香客問我洲劣,道長,這世上最難降的妖魔是什么鼠锈? 我笑而不...
    開封第一講書人閱讀 60,114評論 1 300
  • 正文 為了忘掉前任闪檬,我火速辦了婚禮,結果婚禮上购笆,老公的妹妹穿的比我還像新娘粗悯。我一直安慰自己,他們只是感情好同欠,可當我...
    茶點故事閱讀 69,116評論 6 398
  • 文/花漫 我一把揭開白布样傍。 她就那樣靜靜地躺著,像睡著了一般铺遂。 火紅的嫁衣襯著肌膚如雪衫哥。 梳的紋絲不亂的頭發(fā)上,一...
    開封第一講書人閱讀 52,713評論 1 312
  • 那天襟锐,我揣著相機與錄音撤逢,去河邊找鬼。 笑死,一個胖子當著我的面吹牛蚊荣,可吹牛的內容都是我干的初狰。 我是一名探鬼主播,決...
    沈念sama閱讀 41,170評論 3 422
  • 文/蒼蘭香墨 我猛地睜開眼互例,長吁一口氣:“原來是場噩夢啊……” “哼奢入!你這毒婦竟也來了?” 一聲冷哼從身側響起媳叨,我...
    開封第一講書人閱讀 40,116評論 0 277
  • 序言:老撾萬榮一對情侶失蹤腥光,失蹤者是張志新(化名)和其女友劉穎,沒想到半個月后糊秆,有當?shù)厝嗽跇淞掷锇l(fā)現(xiàn)了一具尸體武福,經(jīng)...
    沈念sama閱讀 46,651評論 1 320
  • 正文 獨居荒郊野嶺守林人離奇死亡,尸身上長有42處帶血的膿包…… 初始之章·張勛 以下內容為張勛視角 年9月15日...
    茶點故事閱讀 38,714評論 3 342
  • 正文 我和宋清朗相戀三年扩然,在試婚紗的時候發(fā)現(xiàn)自己被綠了艘儒。 大學時的朋友給我發(fā)了我未婚夫和他白月光在一起吃飯的照片聋伦。...
    茶點故事閱讀 40,865評論 1 353
  • 序言:一個原本活蹦亂跳的男人離奇死亡夫偶,死狀恐怖,靈堂內的尸體忽然破棺而出觉增,到底是詐尸還是另有隱情兵拢,我是刑警寧澤,帶...
    沈念sama閱讀 36,527評論 5 351
  • 正文 年R本政府宣布逾礁,位于F島的核電站说铃,受9級特大地震影響,放射性物質發(fā)生泄漏嘹履。R本人自食惡果不足惜腻扇,卻給世界環(huán)境...
    茶點故事閱讀 42,211評論 3 336
  • 文/蒙蒙 一、第九天 我趴在偏房一處隱蔽的房頂上張望砾嫉。 院中可真熱鬧幼苛,春花似錦、人聲如沸焕刮。這莊子的主人今日做“春日...
    開封第一講書人閱讀 32,699評論 0 25
  • 文/蒼蘭香墨 我抬頭看了看天上的太陽配并。三九已至括荡,卻和暖如春,著一層夾襖步出監(jiān)牢的瞬間溉旋,已是汗流浹背畸冲。 一陣腳步聲響...
    開封第一講書人閱讀 33,814評論 1 274
  • 我被黑心中介騙來泰國打工, 沒想到剛下飛機就差點兒被人妖公主榨干…… 1. 我叫王不留,地道東北人邑闲。 一個月前我還...
    沈念sama閱讀 49,299評論 3 379
  • 正文 我出身青樓岩喷,卻偏偏與公主長得像,于是被迫代替她去往敵國和親监憎。 傳聞我的和親對象是個殘疾皇子纱意,可洞房花燭夜當晚...
    茶點故事閱讀 45,870評論 2 361

推薦閱讀更多精彩內容