Hello, I have been facing this issue since I installed ISPCONFIG and it hasn't bothered me much until today. No one can login to PHPMYADMIN using their database credentials
Do the database credentials work otherwise, e.g. in the website cms systems? If yes, then they must work in PHPMyAmin as well as. So maybe you connect to the wrong PHPMyAdmin instance, in case you are using a multiserver setup.
Everything with the database works perfectly. All databases are accessible, accounts login, everything. The only issue that I have is when i go to controlpanel.com/phpmyadmin I can only login with the root users account and I can only see the databases that are associated with the server and nothing concerning users databases. Also, if I login into the db server itself all the databases and users are there. They just aren't visible from phpymadmin What did you mean by connected to wrong instance?
If I understand you correctly, then you have a multiserver system. The controlpanel server is not the database server and phpmyadmin connects to localhost. so when you connect to phpmyadmin on the controlpabel server, then this phpmyadmin connects to the mysql instance of the controlpanel server and not your database server or in other words, you connect to the wrong phpmyadmin installation. There are two solutions, either you install phpmyadmin on the database server and connect to that phpmyadmin when you want to edit a client database or you install phpmyadmin on the web server that hosts the client websites and change its configuration to connect to the database server and then let your customers use that phpmyadmin. If you have multiple db servers and install phpmyadmin on each of them, then you can use a placeholder for the server name in the phpmyadmin url in ispconfig under System > Interface config so a user that clicks on the db icon in ispconfig gets redirected to the right phpmyadmin instance.
I knew it had to be something along those lines. Would it be possible to request this be documented for future references
