Our database migration, I entered the database directory all need to copy what to the new database can be used, I directly copy the library error
"" Beijing-2016/1/26 16:07:33
mysql> use payment;
Database changed
Mysql> Show tables;
ERROR 1018 (HY000): Can ' t read dir of './payment/' (errno:13)
"" Beijing-2016/1/26 16:08:08
This is the old database mysql> show tables;
ERROR 1018 (HY000): Can ' t read dir of './crowd/' (errno:13)
Mysql>
Analysis:
The human modification of the Data directory permission resulted in:
[Email protected] mysql]# ls-ld/datadisk/mysqldata/mysql/jiradb
DRWX------2 Jira mysql 4096 08-28 08:07/datadisk/mysqldata/mysql/jiradb
Data directory permissions are modified to non-MySQL account owner, resulting in MySQL without permission to read the file, naturally not get table information.
Solution:
Modify the Data directory owner is MySQL.
"Empty Hades" Hebei-Liu Jianzo 2016/1/26 16:24:19
MySQL Check list failed
