MySQL Database File Permissions

We port the MySQL database from one server to another. The operating system is Red Hat Linux.

1. view system status

> Show status

2. view the current process

> Show processlist

There is no other problem, but all the tables are read-only. At first, we thought it was a problem with user permission settings. After viewing the table, there was no problem.

Finally, we thought that we copied the table file directly, which must involve the Linux system permissions. The check results are also like this. At the beginning, I did not really think of it. after the system permission is changed, the database is normal.

The above is a little bit of experience, but it is worth record.