In this post we will see the resolution of MySQL “permission denied” error due to movement of database to a different partition on CentOS.
ERROR 1018 (HY000): Can’t read dir of ‘./sakila/’ (errno: 13 – Permission denied)
Recently, a friend was stuck on following issue and he was not able to access the tables under ‘sakila’ database. Though he was able to read all other databases!
ERROR 1018 (HY000): Can't read dir of './sakila/' (errno: 13 - Permission denied)
This is what happens when he try accessing the tables from sakila database:
mysql>use sakila; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> show tables; ERROR 1018 (HY000): Can't read dir of './sakila/' (errno: 13 - Permission denied)