When creating a database user it's trying to create on localhost

Discussion in 'Installation/Configuration' started by Aaron Russell, Jun 16, 2020.

Tags:
  1. Aaron Russell

    Aaron Russell New Member

    Hello,
    I'm having a problem where ISPConfig is working fine aside from creating database users.
    I am using a different server as a mysql server, when I create a new database in ISPConfig, it does create the database at the correct location however it tries to create the user on localhost rather than at the correct host.
    Hope someone can help,
    Thanks,
    Aaron
     
    Aaron Russell, Jun 16, 2020
    #1
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    If you want to allow access from another host to the database, then you must add these IP addresses in the remote access IP field of the database and enable the remote access checkbox.

    ISPConfig can not add the access IP of the webserver automatically as your system does not follow ispconfig setup requirements which include that the MySQL database always must be on localhost in relation to the ispconfig server process which configures it or in other words, an ISPConfig instance must be installed on the database node.
     
    till, Jun 16, 2020
    #2
  3. Aaron Russell

    Aaron Russell New Member

    It's not creating the user at all though, on any host.
     
    Aaron Russell, Jun 16, 2020
    #3
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    The user is created when you add the database. It is not created when you add just the user, as the system can not know on which host the database will reside later.
     
    till, Jun 16, 2020
    #4
    Th0m likes this.

Share This Page