We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on v1 candidate and expect to engage more with the community over the coming months. We are committed to open source, and we encourage contributors to help us build the future of Vesta.
(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.