Issue Accessing MySQL from Another Server

[JasonHarper]

Hello!

For a year now I've been using MySQL and Apache (with PHP code) on the same server. I've decided to build a separate MySQL server but I can't seem to access that server from my PHP applications on the other box.

 

PHP returns an error that it can't connect to the MySQL server. I've tried creating users with the IP address of the web server (user@x.x.x.x) and without (user@%) and I still can't seem to access.

 

I'm not an expert by any means so is there any kind of log or place I can look to tell me what's happening? Can the user @ be by IP address or does it need to be a hostname? The MySQL server has multiple IP's but the bind-address is set to 0.0.0.0.

 

Thank you so much for any help!

 

Jason