MySQL常见问题解决方案

问题1：Mysql启动问题

1.1 使用mysqld命令启动mysql报错 [ERROR] [MY-010119] [Server] Aborting

问题详情：

2022-01-14T05:43:12.932662Z 0 [ERROR] [MY-013276] [Server] Failed to set datadir to 
'/usr/local/mysql-8.0.26-macos11-x86_64/data/' (OS errno: 13 - Permission denied)
2022-01-14T05:43:12.932849Z 0 [ERROR] [MY-010119] [Server] Aborting

解决方案：

• 给data目录授权：sudo chmod -R a+rwx /usr/local/mysql-8.0.26-macos11-x86_64/data
• 启动Mysql：mysqld

问题2: Mysql登陆问题

问题详情：

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

原因：Mysql服务未启动
解决方案：启动mysql服务：mysqld