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
Maybe the mysql root password in /usr/local/ispconfig/server/lib/mysql_clientdb.conf is not corrrect.