Shans-Macbook:~ Shanshan$ sudo cp /usr/local/mysql/support-files/my-small.cnf /etc/my.cnf
Password:
cp: /usr/local/mysql/support-files/my-small.cnf: No such file or directory
Shans-Macbook:~ Shanshan$ sudo cd /usr/local/mysql/support-files/my-small.cnf /etc/my.cnf
/usr/bin/cd: line 4: cd: /usr/local/mysql/support-files/my-small.cnf: No such file or directory
Shans-Macbook:~ Shanshan$ sudo /usr/local/mysql/support-files/mysql.server start
Starting MySQL
.................................................................................................... ERROR! The server quit without updating PID file (/usr/local/mysql/data/Shans-Macbook.pid).
Shans-Macbook:~ Shanshan$ mysqld_safe --skip-grant-tables &
[1] 15852
Shans-Macbook:~ Shanshan$ 2017-03-31T07:16:22.6NZ mysqld_safe Logging to '/usr/local/var/mysql/Shans-Macbook.err'.
2017-03-31T07:16:22.6NZ mysqld_safe Logging to '/usr/local/var/mysql/Shans-Macbook.err'.
/usr/local/bin/mysqld_safe: line 139: /usr/local/var/mysql/Shans-Macbook.err: Permission denied
2017-03-31T07:16:22.6NZ mysqld_safe Starting mysqld daemon with databases from /usr/local/var/mysql
/usr/local/bin/mysqld_safe: line 139: /usr/local/var/mysql/Shans-Macbook.err: Permission denied
/usr/local/bin/mysqld_safe: line 193: /usr/local/var/mysql/Shans-Macbook.err: Permission denied
2017-03-31T07:16:22.6NZ mysqld_safe mysqld from pid file /usr/local/var/mysql/Shans-Macbook.pid ended
/usr/local/bin/mysqld_safe: line 139: /usr/local/var/mysql/Shans-Macbook.err: Permission denied
Shans-Macbook:~ Shanshan$ mysql -u root
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[1]+ Done mysqld_safe --skip-grant-tables
Shans-Macbook:~ Shanshan$ mysql.server start
Starting MySQL
./usr/local/Cellar/mysql/5.7.17/bin/mysqld_safe: line 139:
/usr/local/var/mysql/Shans-Macbook.err: Permission denied
/usr/local/Cellar/mysql/5.7.17/bin/mysqld_safe: line 139:
/usr/local/var/mysql/Shans-Macbook.err: Permission denied
/usr/local/Cellar/mysql/5.7.17/bin/mysqld_safe: line 193:
/usr/local/var/mysql/Shans-Macbook.err: Permission denied
/usr/local/Cellar/mysql/5.7.17/bin/mysqld_safe: line 139:
/usr/local/var/mysql/Shans-Macbook.err: Permission denied
ERROR! The server quit without updating PID file (/usr/local/var/mysql/Shans-Macbook.pid).
我花了 2 天时间在线搜索和尝试每个帖子,但它仍然不起作用。
我的Mac系统是macOS Sierra。
Shans-Macbook:~ Shanshan$ mysql -V
mysql Ver 14.14 Distrib 5.7.17, for osx10.12 (x86_64) using EditLine wrapper
我想你不想使用MySQL工作台。如果您下载 DMG 文件:https://dev.mysql.com/downloads/workbench/
那么你可能还需要服务器:https://dev.mysql.com/downloads/mysql/
看看吧,有很多论坛,提供这个问题。