(SOLVED) Unable to see databases in PHPMYADMIN
(SOLVED) Unable to see databases in PHPMYADMIN
I just completed migrating about 50 sites over and started setting up subdomains. After creating the final database, I log into phpmyadmin and nothing is there. on the left it shows "No databases".
I have probably set up about 40 databases before this, they were all visible but now everything is not visible. My sites are still functional, I just can't databases through phpmyadmin.
Logging in as root on phpmyadmin does not show any databases either.
I have probably set up about 40 databases before this, they were all visible but now everything is not visible. My sites are still functional, I just can't databases through phpmyadmin.
Logging in as root on phpmyadmin does not show any databases either.
Last edited by egglan on Wed Sep 24, 2014 1:30 am, edited 1 time in total.
Re: Unable to see databases in PHPMYADMIN
If I reboot the server the databases show up again until view a database. After everything is not visible until a fresh reboot.
Re: Unable to see databases in PHPMYADMIN
I solved my problem. I opened mysql and ran SHOW TABLES;
It had "Error 1018 (HY000): Can't read dir of '.' (Errno: 24) - so I hit my limit for open files.
I ran "sudo lsof -u mysql" to confirm and I had 1060 files. I increased my limit by adding "open-files-limit = 2048 " in my.cnf
After restarting mysql service I can now see all of my database / tables.
It had "Error 1018 (HY000): Can't read dir of '.' (Errno: 24) - so I hit my limit for open files.
I ran "sudo lsof -u mysql" to confirm and I had 1060 files. I increased my limit by adding "open-files-limit = 2048 " in my.cnf
After restarting mysql service I can now see all of my database / tables.