Hi I have ispconfig 3.1.6 multiserver setup on debian jessie, I have created a database user and database in ispconfig but cannot connect to phpmyadmin from within ispconfig, when I try to login it gives me a : I can login on the database server and see the newly created database using : and also remotely using also, should I be able to connect to phpmyadmin on the database server using : I have checked the /usr/local/ispconfig/server/lib/mysql_clientdb.conf file and it only contains an entry for root. Any help is greatly appreciated, thanks!
That's how it should be. What matters is that it contains the correct root password. But the password is correct when you are able to login to the database with the mysql command. Actually, you verified already that there is no issue with ispconfig or the created database, so the only thing that's left is that there is an issue with phpmyadmin or that phpmyadmin on a wrong server is accessed. Are you sure that you are using phpmyadmin on the right server? Are you able to logion to the database on the database server with 'mysql -h localhost -u user -p' as that#s the way phpmyadmin is doing it. Did you check in the phpmyadmin configuration file that phpmyadmin connects to the right database server?
Hi Till, thanks for the response, I have checked the phpmyadmin config files, and there seem to be a couple in question, config-db.php where and I see the following line : and in config.inc.php Should I change the $dbserver entry in config-db.php to the hostname of my db server, i.e $dbserver='db.mydomain.com' or put in the ip address of my database server? Thank you very much for your time!
localhost should work too, that's why I suggested testing if you can login with mysql command by using -h localhost. If not, try using IP 127.0.0.1 or the server IP or server hostname.
Hi Till, managed to get the login related issue resolved, but now when I login to phpmyadmin via ispconfig I get errors like : and It also seems that the user I login with doesn't have Privileges. Any ideas?
There seems to be a problem with the phpmyadmin installation then. phpmyadmin has its own database and mysql user which is created by the phpmyadmin package during installation, so not by ispconfig. Seems as if this somehow did not happen. If it's a Debian or Ubuntu system, try to run: dpkg-reconfigure phpmyadmin and let the Debain installer create a mysql user and database for phpmyadmin. You created a mysql user in ispconfig and then you created a database where this mysql user is attached to, right? The user shall have access then to this database only, so the permissions are limited to accessing this single database.
