问题:mysql无法停止
> sudo /usr/local/mysql/support-files/mysql.server stop
(参考:)
问题: mysql -uroot -p 时报错:ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
> sudo /usr/local/mysql/bin/mysqld_safe --skip-grant-tables
(若出现“2019-06-03T06:33:53.6NZ mysqld_safe Logging to '/usr/local/mysql/data/wykaydeMacBook-Pro.local.err'.
2019-06-03T06:33:53.6NZ mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data”,不要关闭当前的终端窗口,新建一个终端窗口,输入如下命令,回车登录mysql/usr/local/mysql/bin/mysql
)
(参考:)
问题:MAC连接上数据库spider后,查看表结构时:desc user 报如下错误
error: 'File './spider/user.MYD' not found (Errcode: 13 - Permission denied)'
解决方法:更改该数据库权限 (参考:)
cd /usr/local/mysql/datasudo chown -R mysql spider