Question about multiserver with DB access

Discussion in 'Installation/Configuration' started by webguyz, Nov 6, 2012.

  1. webguyz

    webguyz Active Member HowtoForge Supporter

    I had a single ispc 3 server ( all services and added a web only server( to the primary server.

    Adding new clients I define their webserver to be on and their Mysql on Creating a db for this client works as expected and gets created on

    But when I try install an app like wp, and define the host ip as being it fails. Checking the mysql server ( using phpmyadmin I see the clients database login info in the priveleges section, but for the host it says localhost, which is not correct because the client is coming from Shouldn't the clients use/password show % instead of localhost so that it can access the remote db?

    After I manually changed the host entry for my client from 'localhost' to '%' I was able access my WP database.

  2. till

    till Super Moderator Staff Member ISPConfig Developer

    This depends on the settings that you choose while you created the database. If you enabled external access, then it will use % as host, if you did not enable exaternal access, then it will use localhost.
  3. webguyz

    webguyz Active Member HowtoForge Supporter

    Where do I see this option? At the client when creating the db? at the reseller or admin level?

    I see a remote option at the client level, is that what your talking about?


    Doah! That makes sense to check the Remote. for some reason I was thinking outside of our network access. To further add to the secuity I would put in my example.

    In an all multiserver environment that Remote option would always have to be checked. Any easy way to have that box checked by default and survive software updates of ISPC 3? Maybe even hide from view since it would have to be checked always.

    I shouldn't do these things until I have had at least 2 cups of coffee.

    Thanks Till!!
    Last edited: Nov 6, 2012

Share This Page