View Single Post
  #1  
Old 6th November 2012, 15:10
webguyz webguyz is offline
Senior Member
 
Join Date: Oct 2012
Location: Earth
Posts: 100
Thanks: 30
Thanked 13 Times in 11 Posts
Default 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.

Thanks!
__________________
= WebGuyz.Net =
VPS and Web Hosting
Reply With Quote
Sponsored Links