Hi, I can not access phpMyAdmin unless the root credentials are used. I have tried creating DB users and adding them to a database in ISPConfig but I can not log in to phpMyAdmin with these details. Any ideas what may cause this issue? I am on a CentOS virtual server and used http://www.howtoforge.com/perfect-server-centos-6.4-x86_64-apache2-dovecot-ispconfig-3-p6 for set up Thanks
Hi Please try the login for dbusers at http://yourIP/phpmyadmin Try to login with the database-username. Check that what error you are getting there? Try login with the ISPConfig-admin console & check that whether the user exists or not. Change your password for the database-user & try to do login with the new password. Br// Srijan
I have tried the IP address, tried changing the passwords, creating new users with no difference made. When I log in as root and view the user table in the mysql database the only users in the table are ispconfig and root
Did you use the full mysql username incl. prefix, like it is displayed in the mysql user list in ispconfig? If you add a mysql user "joe" to a client, then the full username is something like c1joe. Please be aware that a mysql user is created when you add a database for him, so you can not use a mysql user without having a database. If you ware sure that you sued the correct username, then take a look at the file /usr/local/ispconfig/server/lib/mysql_clientdb.conf, it must contain the correct mysql root password. if the password is wrong, ispconfig will not be able to create a mysql db and user.
I have tried changing the password in /usr/local/ispconfig/server/lib/mysql_clientdb.conf and mysql_secure_installation, rebooting the server. Adding a new user and still no luck When I log in as root and view the user table in the mysql database the only users in the table are still ispconfig and root. And yes the correct credentials are being used i.e c0blahblah
Did you try to make new user inside database with phpMyAdmin (after login as root) and check if it will work or not? How about MySQL and phpMyAdmin configuration?
I seem to have resolved the issue following the advice above. Even though it did not work instantly which I find bizarre. Thanks for the help guys.
