Hi , i got a wordpress database which want to be share with another server of another ip. so instead of using localhost for the wp config, i use the server ip. I setup mysql additional host on my whm with the remote server ip but still cant establish connection. Payment : $15 usd Paypal Sorry but i cant let u go in my whm or root.
you will need to enable mysql external connections on the ip on which your database exists. This can be done in my.cnf file on your mysql server. u will need to comment the skip-networking line and change bind-address to your external IP address. U will also need to grant privileges to external users by executing the grant privileges query.
domainsurfer is correct, just enabling remote connection to mysql ( where your wp database exists ) and granting user privileges, you can make the work done!!