Remote MYSQL Not Creating Database

Discussion in 'Installation/Configuration' started by intelix, Aug 7, 2015.

  1. intelix

    intelix New Member

    I have added a dedicated MYSQL server to my ispconfig installation. I followed the guide on your website to set this up.
    The server shows in the web interface now. To test it I went and tried to create a new database on it. I checked the Remote Access checkbox.
    The database shows now on the interface but I checked the new DB server and the database is not there.
    I also created a remote user on the new DB server so the master server can connect to it but still no luck.
    Any idea on where I can look to find out what the issue is?
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

  3. intelix

    intelix New Member

    Here is an error I got on the Slave Mysql Server:
    PHP Warning: mysqli::mysqli(): (28000/1045): Access denied for user 'ispcsrv6'@'x.x.x.x' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 62
    DB::__construct Access denied for user 'ispcsrv6'@'x.x.x.x' (using password: YES)
    where x.x.x.x is the IP of the slave server.
     
  4. intelix

    intelix New Member

    Where do I update the password for this user?
     
  5. till

    till Super Moderator Staff Member ISPConfig Developer

    Passwords of mysql users are stored by mysql in the mysql.user table.
     

Share This Page