I hope it's not in bad form to revive a old thread but, it's exactly the issue myself and others are grappling with this week. http://www.howtoforge.com/forums/showthread.php?t=51518
Would a dedicated MySQL server have access to a clients default_webserver as defined in the clients limits page? I noticed the default grants were all to localhost and looping through the remote IPs in:
In the above file on my dedicated database server I duplicated the localhost inserts, updates, etc. and added my webserver hostname. So, every time localhost gets a grant, update, delete, etc. so does the webserver. Seems to work fine in my one web server, one database server environment.
Anyway to determine the client's default_webserver and give it the grant automatically?