mysql ERROR 1018 (HY000): Can't read dir of '.' (errno: 24)

1、

查看mysql的进程
lsof -u mysql

2、

edit the file in /etc/security/limits.conf and add these two mysql lines in at the bottom

#@student        -       maxlogins       4
mysql   soft    nofile  4096
mysql   hard    nofile  8192
# End of file

3、

Once this is set you need to make some changes in the mysql file as well. Assuming yours lives in /etc/mysql/my.cnf - edit or add these values

open-files-limit = 2048
table_cache            = 512

这样就解决了

转载于:https://www.cnblogs.com/win-and-first/archive/2013/04/21/3033867.html