• notice
  • Congratulations on the launch of the Sought Tech site

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.

Tags

Technical otaku

Sought technology together

Related Topic

1 Comments

author

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

Leave a Reply

+