mysql Table is read only 的问题

今天导入数据库遇到了这个问题,总结下解决方案:

1.改可执行权限

1
chmod -R 777  /var/lib/mysql/ssbc2/

2.该用户组

1
chown root: -R /usr/lib/mysql/ssbc2

3.flush tables

1
mysqladmin -u root -p flush-tables

ok,问题解决

Author: y500
Link: https://www.y500.me/2015/12/24/mysql-table-is-read-only/
Copyright Notice: All articles in this blog are licensed under CC BY-NC-SA 4.0 unless stating additionally.