Solution:
mysql> set global read_only=0; (Turn off the read-only attribute of the new main library)
flush privileges;
set global read_only=1;(Read and write attributes)
If it fails:
Check my.ini, open it to see if there is skip-grant-tables, delete it if there is.
If it still doesn’t work:
Uninstall cleanly and reinstall.
Baidu said that at this time we only need to flush privileges and it will be OK. You'd better look at the log or Baidu, there should be a detailed answer. This has nothing to do with phpStudy, it is mainly a problem with MySql execution.
Solution:
mysql> set global read_only=0;
(Turn off the read-only attribute of the new main library)
flush privileges;
set global read_only=1;(Read and write attributes)
flush privileges;
If it fails:
Check my.ini, open it to see if there is skip-grant-tables, delete it if there is.
If it still doesn’t work:
Uninstall cleanly and reinstall.
Baidu said that at this time we only need to flush privileges and it will be OK. You'd better look at the log or Baidu, there should be a detailed answer. This has nothing to do with phpStudy, it is mainly a problem with MySql execution.