ERROR - Unable to connect to the database

Discussion in 'Installation/Configuration' started by doughold, Feb 1, 2009.

  1. doughold

    doughold New Member

    I spent about an hour looking for this answer and I might have just been searching for the wrong thing, but I changed my root password for MySQL in ISPConfig3 and now I can't create new databases using the CP. In ispconfig.log I am getting ERROR - Unable to connect to the database, leading me to believe that there is a config file that just needs a password updated, but I cant seem to find it. I have looked in the /usr/local/ispconfig/interface/lib folder but I didn't see anything in the config.inc.php file. The only file that had a "root" user was db_local.php.skel, but updating the password there didn't help. Any idea as to what went wrong here and where I can update the password? Thanks!
     
  2. falko

    falko Super Moderator ISPConfig Developer

    That's the correct file. Please take a second look.
     
  3. doughold

    doughold New Member

    Bad permissions in MySQL DB?

    The only username I see in this file is the "ispconfig" user with permissions on the dbispconfig database. In my MySQL database this user does not have permissions to create new databases. Maybe the permissions in my MySQL DB is wrong?
     
  4. falko

    falko Super Moderator ISPConfig Developer

    Try the root MySQL user instead.
     

Share This Page