mysql user/db not created

Discussion in 'Server Operation' started by tommsen, Dec 18, 2016.

  1. tommsen

    tommsen New Member

    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
     
  2. Tomislav Aurednik

    Tomislav Aurednik Member HowtoForge Supporter

    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?
     
  3. tommsen

    tommsen New Member

    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
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    Maybe the mysql root password in /usr/local/ispconfig/server/lib/mysql_clientdb.conf is not corrrect.
     
  5. tommsen

    tommsen New Member

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

Share This Page