create database from control panel

Hi,
i have a problem with isp control panel.
I have create a database user and a database, but i can't connect to this from browser. The user and the password isn't correct.
Instead via ssh i can see the new database.

Any suggestion for resolve the problem?

 

Unfortunately not.
In phpmyadmin i try to input root login and user database login, but neither one works.
But if i connect via ssh to mysql i can see the database that i create from ispconfig.

 

Which ISPConfig version did you install? and which OS?

You may have the same issue as I do with phpmyadmin

 

@anhlqn ISPConfig 3 o Unbuntu 12.04.

@till I have already try to reinstall phpmyadmin. I think I do something wrong.

This is user and host of databases. C1admin is the user that i create from ispconfig. Why there is a % in host? Is it normal?

+------------------+-----------+
| User | Host |
+------------------+-----------+
| root | localhost |
| root | vpsxxxxx |
| root | 127.0.0.1 |
| root | ::1 |
| | vpsxxxxx |
| debian-sys-maint | localhost |
| ispconfig | localhost |
| c1admin | localhost |
| c1admin | % |
+------------------+-----------+

 

% means that you can login with c1admin from any hosts, assuming that you have comment out the "bind 127.0.0.11" in my.cnf.

If it is a clean installation of ISPConfig with local mysql server, then you may try to do this:

Code:

cat /usr/share/phpmyadmin/config.sample.inc.php > /var/lib/phpmyadmin/config.inc.php
service apache2 restart

then try to login again.

Just to make sure, if you try to login and get this error

then I think the fix above will work. phpmyadmin in my Debian wheezy server looks for the config.inc.php file in /var/lib/phpmyadmin, even though the document says that we can adjust the configuration in /etc/phpmyadmin or /usr/share/phpmyadmin.
By default, /var/lib/phpmyadmin/config.inc.php is a blank file

 

Thank you anhlqn! Now it works!!

 

Glad it helps . I think this should be noted in the ISPConfig on Debian Wheezy setup guide on howtoforge even though it has nothing to do with ISPConfig.

 

I have installed using this guide on 6 servers, and phpmyadmin all failed. Maybe that was because my mysql servers were not localhost. I also tried modifying the config file (config.inc.php, db-config.conf) in /etc/phpmyadmin and /usr/share/phpmyadmin, but I still got the error:

Code:

#2002 Cannot log in to the MySQL server

I have never had such issue with phpmyadmin on CentOS.