Solution to MySQL unable to read table error (MySQL 1018 error)

1. Error reproduction

I can access the MySQL database, but I cannot read the database table. The error message is as follows: When accessing the database, an inexplicable error message 1018 is reported: ERROR 1018 (HY000): Can't read dir of './cnapscips/' (errno: 13).

2. Solution

Check the MySQL data directory. Generally, the tables that cannot be read are copied databases. Even the root user cannot read the tables. You need to modify the directory permissions.

Modify the directory permissions, use the command: chown -R mysql:mysql /var/lib/mysql/cnapscips (executed by the root user)

Note: cnapscips here is my database name. When modifying permissions, be sure to change it to a database name that you cannot read.

Use show cnapscips again;

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.