Question about multiserver with DB access
I had a single ispc 3 server (ispmain.test.com)with all services and added a web only server(web2.test.com) to the primary server.
Adding new clients I define their webserver to be on web2.test.com and their Mysql on ispmain.test.com. Creating a db for this client works as expected and gets created on ispmain.test.com.
But when I try install an app like wp, and define the host ip as being ispmain.test.com it fails. Checking the mysql server (ispmain.test.com) 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 web2.test.com. 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.