Create mysql database uses host ip application uses hostname
I have ISPConfig running on a WebServer, and MYSQL running on a seperate server, behind a second firewall. It works and that is really night a problem.
When I create a new website, with a new database, the user is created in the database will all the IP addresses of the webserver.
I am trying to install phpBB3 into this database. When I attempt to access the database, it tells me access is denied for user@hostname. The hostname being the webserver name (not the sitename). How do I either force the username to use the ip, or have ISPConfig use the hostname to create the user account in MYSQL?