mysql 报错 Can‘t connect to local MySQL server through socket ‘/tmp/mysql.sock‘ (2)

mysql 报错 Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)

Mac版, 数据库莫名报错

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

尝试重新安装最新版本的数据库,8.0。并未解决。

解决方案:

1.cmd打开到mysql下:

cd /usr/local/mysql/bin

2.运行mysqld, 报错如下:

2021-12-23T06:25:39.163473Z 0 [ERROR] [MY-000077] [Server] /usr/local/mysql-8.0.27-macos11-x86_64/bin/mysqld: Error while setting value 'STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' to 'sql_mode'.
2021-12-23T06:25:39.163510Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-12-23T06:25:39.163574Z 0 [Note] [MY-010120] [Server] Binlog end

3.初步定位是在设置值的时候,出现的了错误。

查看其他博客,定位问题在 Mysql 8.0以上已经取消了NO_AUTO_CREATE_USER这个关键字，windows 系统在mysql.ini中的sql_mode中删掉这个关键字即可; Mac系统,则找到 /etc/my.cnf,打开删除掉这个关键字即可。

4.到这一步,查看下问题解决了没有。如果没有,则继续。

bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

报错:

2021-12-23T06:27:04.364602Z 0 [ERROR] [MY-000077] [Server] /usr/local/mysql-8.0.27-macos11-x86_64/bin/mysqld: Error while setting value 'STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' to 'sql_mode'.
2021-12-23T06:27:04.364621Z 0 [ERROR] [MY-013236] [Server] The designated data directory data is unusable. You can remove all files that the server added to it.
2021-12-23T06:27:04.364680Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-12-23T06:27:04.364776Z 0 [Note] [MY-010120] [Server] Binlog end

5.看报错信息, 我们需要删除data目录下的文件。这个目录的访问需要权限,如果需要,则su获取权限。

cd /usr/local/mysql/data

删除目录下的文件

rm -rf *

6.回退目录,继续执行

bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

输出:

2021-12-23T06:32:49.510459Z 0 [System] [MY-013169] [Server] /usr/local/mysql-8.0.27-macos11-x86_64/bin/mysqld (mysqld 8.0.27) initializing of server in progress as process 4099
2021-12-23T06:32:49.512814Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive
2021-12-23T06:32:49.520416Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-12-23T06:32:49.674060Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-12-23T06:32:50.271883Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2021-12-23T06:32:50.271900Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2021-12-23T06:32:50.440144Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: 5n6u22SD=z.#
2021-12-23T06:32:51.003939Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.27).

生成了一个临时的密码 A temporary password is generated for root@localhost: 5n6u22SD=z.#

这个我并没有用到。

7.正常启动Mysql

mysql -u root -p

最后:

报错信息,很难做到完全的一致,毕竟涉及版本等等…

慢慢的逐步尝试排查,终会到达Rome。