在执行数据库脚本时提示:
The MySQL server is running with the --read-only option so it cannot execute this statement
查看read_only属性,在MySQL中执行:
show variables like '%read_only%';
如果属性为on
解决方法,在MySQL中执行:
set GLOBAL read_only = false;
flush privileges;
再次查看属性变更为off
在修改read_only属性时提示:
you need the SUPER privilege for this operation
解决方法,在命令窗口中输入:
service mysqld stop;
mysqld_safe skip-grant-tables;
service mysqld start;
再次执行数据库脚本时提示:
Access denied for user 'root'@'localhost' to database 'xx'
查看MySQL的user表:
use user;
select * from user;
可以将查询结果复制到notepad++方便查看权限
update所有需要的权限