ERROR 1018 (HY000): Can't read dir of './cmp/' (errno: 13)

小灰灰 2022-06-08 04:27 99阅读 0赞

1、错误描述

root@localhost 15:54:  [cmp]> show tables;
    ERROR 1018 (HY000): Can't read dir of './cmp/' (errno: 13)
    root@localhost 15:54:  [cmp]> show tables;
    ERROR 1018 (HY000): Can't read dir of './cmp/' (errno: 13)
    
    root@localhost 16:01:  [(none)]> show databases;
    +--------------------+
    | Database           |
    +--------------------+
    | information_schema |
    | cmp                |
    | mysql              |
    | student            |
    | test               |
    +--------------------+
    5 rows in set (0.00 sec)
    
    root@localhost 16:02:  [(none)]> drop database cmp;
    ERROR 1008 (HY000): Can't drop database 'cmp'; database doesn't exist
    root@localhost 16:02:  [(none)]> create database cmp;
    ERROR 1006 (HY000): Can't create database 'cmp' (errno: 13)
    root@localhost 16:02:  [(none)]> show databases;
    +--------------------+
    | Database           |
    +--------------------+
    | information_schema |
    | cmp                |
    | mysql              |
    | student            |
    | test               |
    +--------------------+
    5 rows in set (0.00 sec)
    
    [yhd@localhost 桌面]$ mysql -uroot -p
    Enter password: 
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
    [yhd@localhost 桌面]$ 
    
    [yhd@localhost 桌面]$ mysql -uroot -p
    Enter password: 
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
    [yhd@localhost 桌面]$ service mysqld start
    Starting MySQL. ERROR! Manager of pid-file quit without updating file.

2、错误原因

在CentOS系统上，创建和删除数据库cmp，但是数据库目录权限被限制了，导致出现这个错误

3、解决办法

修改mysql数据库目录文件权限

chown -R mysql:mysql /data/mysql