问题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