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?

 

I use version 2.2.29

 

You can either enable remote access for the database, or, if phpBB is installed on the same server, use localhost or 127.0.0.1 as the database server.