ERROR 1018 (HY000): Can't read dir of './jiradb/' (errno: 13)
现象：数据库无法正常读表.
[root@jiradb ~]# mysql -ujirakpi -p
Welcome to the MySQL monitor.? Commands end with ; or \g.
Your MySQL connection id is 13366
Server version: 5.5.9-log MySQL Community Server (GPL)
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases
? ? -> ;
+--------------------+
| Database? ? ? ? ? |
+--------------------+
| information_schema |
| bamboo? ? ? ? ? ? |
| confluence? ? ? ? |
| crowd? ? ? ? ? ? ? |
| crucible? ? ? ? ? |
| crucibledb? ? ? ? |
| jiradb? ? ? ? ? ? |
| mysql? ? ? ? ? ? ? |
| nagiosql? ? ? ? ? |
| performance_schema |
+--------------------+
10 rows in set (0.00 sec)
mysql> use jiradb
Database changed
mysql> show tables;
ERROR 1018 (HY000): Can't read dir of './jiradb/' (errno: 13)
mysql>
mysql> show variables like '%data%';
+----------------------------+----------------------------+
| Variable_name? ? ? ? ? ? ? | Value? ? ? ? ? ? ? ? ? ? ? |
+----------------------------+----------------------------+
| character_set_database? ? | utf8? ? ? ? ? ? ? ? ? ? ? |
| collation_database? ? ? ? | utf8_bin? ? ? ? ? ? ? ? ? |
| datadir? ? ? ? ? ? ? ? ? ? | /dataDisk/MysqlData/mysql/ |
| innodb_data_file_path? ? ? | ibdata1:10M:autoextend? ? |
| innodb_data_home_dir? ? ? |? ? ? ? ? ? ? ? ? ? ? ? ? ? |
| innodb_stats_on_metadata? | ON? ? ? ? ? ? ? ? ? ? ? ? |
| max_length_for_sort_data? | 1024? ? ? ? ? ? ? ? ? ? ? |
| myisam_data_pointer_size? | 6? ? ? ? ? ? ? ? ? ? ? ? ? |
| skip_show_database? ? ? ? | OFF? ? ? ? ? ? ? ? ? ? ? ? |
| updatable_views_with_limit | YES? ? ? ? ? ? ? ? ? ? ? ? |
+----------------------------+----------------------------+
10 rows in set (0.00 sec)
mysql>
mysql> use crowd;
Database changed
mysql> show tables;
ERROR 1018 (HY000): Can't read dir of './crowd/' (errno: 13)
mysql>
分析：
人为修改了data目录权限导致：
[root@jiradb mysql]# ls -ld /dataDisk/MysqlData/mysql/jiradb
drwx------ 2 jira mysql 4096 08-28 08:07 /dataDisk/MysqlData/mysql/jiradb
Data目录权限被修改为非mysql账号属主，导致Mysql无权限读取文件，自然获取不到表信息。
解决方案：
修改data目录属主为mysql。
[root@jiradb mysql]# chown -R mysql:mysql /dataDisk/MysqlData/mysql/jiradb
[root@jiradb mysql]#
修改后可正常访问表：
mysql> use jiradb
Database changed
mysql> show tables;
+------------------------------+
| Tables_in_jiradb? ? ? ? ? ? |
+------------------------------+
| OS_CURRENTSTEP? ? ? ? ? ? ? |
| OS_CURRENTSTEP_PREV? ? ? ? ? |
| OS_HISTORYSTEP? ? ? ? ? ? ? |
| OS_HISTORYSTEP_PREV? ? ? ? ? |
| OS_WFENTRY? ? ? ? ? ? ? ? ? |
| SEQUENCE_VALUE_ITEM? ? ? ? ? |
| avatar? ? ? ? ? ? ? ? ? ? ? |
| changegroup? ? ? ? ? ? ? ? ? |
| changeitem? ? ? ? ? ? ? ? ? |
| columnlayout? ? ? ? ? ? ? ? |
| columnlayoutitem? ? ? ? ? ? |
| component? ? ? ? ? ? ? ? ? ? |
| configurationcontext? ? ? ? |
| customfield? ? ? ? ? ? ? ? ? |
| customfieldoption? ? ? ? ? ? |
| customfieldvalue? ? ? ? ? ? |
| cwd_application? ? ? ? ? ? ? |
| cwd_application_address? ? ? |
| cwd_directory? ? ? ? ? ? ? ? |
| cwd_directory_attribute? ? ? |
| cwd_directory_operation? ? ? |
| cwd_group? ? ? ? ? ? ? ? ? ? |
| cwd_group_attributes? ? ? ? |
| cwd_membership? ? ? ? ? ? ? |
| cwd_user? ? ? ? ? ? ? ? ? ? |
| cwd_user_0815? ? ? ? ? ? ? ? |
| cwd_user_0816? ? ? ? ? ? ? ? |
| cwd_user_attributes? ? ? ? ? |
| external_entities? ? ? ? ? ? |
| externalgadget? ? ? ? ? ? ? |
| favouriteassociations? ? ? ? |
| fieldconfigscheme? ? ? ? ? ? |
| fieldconfigschemeissuetype? |
| fieldconfiguration? ? ? ? ? |
| fieldlayout? ? ? ? ? ? ? ? ? |
| fieldlayoutitem? ? ? ? ? ? ? |
| fieldlayoutscheme? ? ? ? ? ? |
| fieldlayoutschemeassociation |
| fieldlayoutschemeentity? ? ? |
| fieldscree