Jump to content

Issue Accessing MySQL from Another Server


JasonHarper

Recommended Posts

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

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.