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啟動以后自動生成的文件叉弦,關(guān)閉MySQL服務(wù)后丐一,這個文件又會被刪除。如果MySQL啟動異常淹冰,就有可能不生成這個文件库车,登錄的時候就會出現(xiàn)你這個錯誤。

可能是mysql未啟動樱拴,嘗試啟動:

sudo mysql.server start

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

mysqld

結(jié)果

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

結(jié)果:

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');
最后編輯于
?著作權(quán)歸作者所有,轉(zhuǎn)載或內(nèi)容合作請聯(lián)系作者
  • 序言:七十年代末晶乔,一起剝皮案震驚了整個濱河市珍坊,隨后出現(xiàn)的幾起案子,更是在濱河造成了極大的恐慌正罢,老刑警劉巖阵漏,帶你破解...
    沈念sama閱讀 222,729評論 6 517
  • 序言:濱河連續(xù)發(fā)生了三起死亡事件,死亡現(xiàn)場離奇詭異翻具,居然都是意外死亡履怯,警方通過查閱死者的電腦和手機(jī),發(fā)現(xiàn)死者居然都...
    沈念sama閱讀 95,226評論 3 399
  • 文/潘曉璐 我一進(jìn)店門裆泳,熙熙樓的掌柜王于貴愁眉苦臉地迎上來叹洲,“玉大人,你說我怎么就攤上這事工禾≡颂幔” “怎么了?”我有些...
    開封第一講書人閱讀 169,461評論 0 362
  • 文/不壞的土叔 我叫張陵闻葵,是天一觀的道長糙捺。 經(jīng)常有香客問我,道長笙隙,這世上最難降的妖魔是什么洪灯? 我笑而不...
    開封第一講書人閱讀 60,135評論 1 300
  • 正文 為了忘掉前任,我火速辦了婚禮,結(jié)果婚禮上签钩,老公的妹妹穿的比我還像新娘掏呼。我一直安慰自己,他們只是感情好铅檩,可當(dāng)我...
    茶點(diǎn)故事閱讀 69,130評論 6 398
  • 文/花漫 我一把揭開白布憎夷。 她就那樣靜靜地躺著,像睡著了一般昧旨。 火紅的嫁衣襯著肌膚如雪拾给。 梳的紋絲不亂的頭發(fā)上,一...
    開封第一講書人閱讀 52,736評論 1 312
  • 那天兔沃,我揣著相機(jī)與錄音蒋得,去河邊找鬼。 笑死乒疏,一個胖子當(dāng)著我的面吹牛额衙,可吹牛的內(nèi)容都是我干的。 我是一名探鬼主播怕吴,決...
    沈念sama閱讀 41,179評論 3 422
  • 文/蒼蘭香墨 我猛地睜開眼窍侧,長吁一口氣:“原來是場噩夢啊……” “哼!你這毒婦竟也來了转绷?” 一聲冷哼從身側(cè)響起伟件,我...
    開封第一講書人閱讀 40,124評論 0 277
  • 序言:老撾萬榮一對情侶失蹤,失蹤者是張志新(化名)和其女友劉穎议经,沒想到半個月后锋爪,有當(dāng)?shù)厝嗽跇淞掷锇l(fā)現(xiàn)了一具尸體,經(jīng)...
    沈念sama閱讀 46,657評論 1 320
  • 正文 獨(dú)居荒郊野嶺守林人離奇死亡爸业,尸身上長有42處帶血的膿包…… 初始之章·張勛 以下內(nèi)容為張勛視角 年9月15日...
    茶點(diǎn)故事閱讀 38,723評論 3 342
  • 正文 我和宋清朗相戀三年,在試婚紗的時候發(fā)現(xiàn)自己被綠了亏镰。 大學(xué)時的朋友給我發(fā)了我未婚夫和他白月光在一起吃飯的照片扯旷。...
    茶點(diǎn)故事閱讀 40,872評論 1 353
  • 序言:一個原本活蹦亂跳的男人離奇死亡,死狀恐怖索抓,靈堂內(nèi)的尸體忽然破棺而出钧忽,到底是詐尸還是另有隱情,我是刑警寧澤逼肯,帶...
    沈念sama閱讀 36,533評論 5 351
  • 正文 年R本政府宣布耸黑,位于F島的核電站,受9級特大地震影響篮幢,放射性物質(zhì)發(fā)生泄漏大刊。R本人自食惡果不足惜,卻給世界環(huán)境...
    茶點(diǎn)故事閱讀 42,213評論 3 336
  • 文/蒙蒙 一三椿、第九天 我趴在偏房一處隱蔽的房頂上張望缺菌。 院中可真熱鬧葫辐,春花似錦、人聲如沸伴郁。這莊子的主人今日做“春日...
    開封第一講書人閱讀 32,700評論 0 25
  • 文/蒼蘭香墨 我抬頭看了看天上的太陽焊傅。三九已至剂陡,卻和暖如春,著一層夾襖步出監(jiān)牢的瞬間狐胎,已是汗流浹背鸭栖。 一陣腳步聲響...
    開封第一講書人閱讀 33,819評論 1 274
  • 我被黑心中介騙來泰國打工, 沒想到剛下飛機(jī)就差點(diǎn)兒被人妖公主榨干…… 1. 我叫王不留顽爹,地道東北人纤泵。 一個月前我還...
    沈念sama閱讀 49,304評論 3 379
  • 正文 我出身青樓,卻偏偏與公主長得像镜粤,于是被迫代替她去往敵國和親捏题。 傳聞我的和親對象是個殘疾皇子,可洞房花燭夜當(dāng)晚...
    茶點(diǎn)故事閱讀 45,876評論 2 361

推薦閱讀更多精彩內(nèi)容