MySQL's TableisreadOnly solution
Today, under centos6, copy the database folder that mysql cannot be started to/usr/local/mysql/var, the result shows the error "table isreadonly" when modifying the table.
The first thing that came to my mind was that I encountered a permission problem, so I went to/usr/local/mysql/var to check it.Sure enough, the owner was not mysql, and the permissions were not correct.Go through the following steps
Problem solved:
1.Enter the mysql database directory and use the commands "chown-R mysql <database folder name>" and "chgrp-R mysql <database folder name>" to change the folder owner and group to mysql
2.Use the command "chmod-R 760 <database folder name>" to change the permission settings
3.Use the command "mysqladmin-uroot-p reload" to reload the table
4.Use the command "mysqladmin-uroot-p flush-tables" to perform a flush
Tip: The owner and group of the mysql database file must be mysql.
Problem solved:
1.Enter the mysql database directory and use the commands "chown-R mysql <database folder name>" and "chgrp-R mysql <database folder name>" to change the folder owner and group to mysql
2.Use the command "chmod-R 760 <database folder name>" to change the permission settings
3.Use the command "mysqladmin-uroot-p reload" to reload the table
4.Use the command "mysqladmin-uroot-p flush-tables" to perform a flush
Tip: The owner and group of the mysql database file must be mysql.
order lipitor 80mg generic & lt;a href="https://lipiws.top/"& gt;where can i buy atorvastatin& lt;/a& gt; atorvastatin 80mg cheap
Mlqhkl
2024-03-08