mysql user/db not created

Hi,
i'm on ubuntu 16.04 with ispconfig 3.1dev. I created a database user and and a database in ispconfig, but none of the both is visible if i login to phpMyAdmin as root user. But i can see both entries inside ispconfig. Do i miss something?

best regards

 

try loging in with the user you created... the db you create gets the client number in front of the name.
if you have create a DB with the name "myDB" in phpmy admin ti will be c1myDB. The c1 is client number. If you created it with APS installer it will be named for instance c1aps1.

Did you comment out #bind-address = 127.0.0.1 in /etc/mysql/my.cnf, restarted it and tested that it listens with: netstat -tap | grep mysql?

 

i logged in via phpmyadmin as root and all databases i see are

• dbispconfig
• information_schema
• mysql
• performance_schema
• phpmyadmin
• roundcube

no c0... tables in my case (no reseller account created). Also the db user i created in ispconfig is not in the list of users.
bind adress is commented(hash added). here is my netstat result:

netstat -tap | grep mysql
tcp 0 0 localhost.localdo:33374 localhost.localdo:mysql ESTABLISHED 24299/amavisd-new (
tcp6 0 0 [::]:mysql [::]:* LISTEN 1526/mysqld
tcp6 0 0 localhost.localdo:mysql localhost.localdo:33374 ESTABLISHED 1526/mysqld

 

yes, thats it. Typo in password. Thanks a lot for the pointer!