«
»

SQLSTATE[HY000] [2003] Can’t connect to MySQL server on ‘xxx.xxx.xxx.xxx’ (13)

One of the things I wish I had found in Google faster when trying to figure out why PHP script refuses to connect to remote MySQL server issuing an error
SQLSTATE[HY000] [2003] Can't connect to MySQL server on 'xxx.xxxx.xxx.xxx' (13)

I am able to connect from local shell, so first thought was if something wrong with recent Zend Framework upgrade, but after a while I figured out that answer is very simple – SELinux was blocking remote connections from PHP scripts executed by Apache web server. The error code (13) at the end of error message means “permission denied”, so that’s the indication to see if you have similar issue or not.

Anyway, login as root and do
setsebool -P httpd_can_network_connect=1
to make it work.

Of course, think twice because you make web server a bit less secure, so don’t do that unless you are sure you need it.

Tags: , , , ,

This entry was posted on Friday, August 7th, 2009 at 7:34 am and is filed under Web development. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

5 Responses to “SQLSTATE[HY000] [2003] Can’t connect to MySQL server on ‘xxx.xxx.xxx.xxx’ (13)”

  1. Jonathan Nieto says:
    December 27, 2009 at 11:27 pm

    Thanks! you saved me so much time!

  2. Sanjay Malunjkar says:
    February 22, 2010 at 11:27 am

    That was exactly my problem. I would imagine that phpmyadmin talking to remote mysql will require this change.

  3. Dan Thomas says:
    March 17, 2010 at 5:29 am

    Thanks very much.. spent ages trying to sort this problem out!!
    Thanks Again :)

  4. Philip Ramirez says:
    April 3, 2010 at 9:23 pm

    This came in handy just now. Thankfully I found your blog before I spent even more time debugging.

    Thanks again.

  5. Ashutosh says:
    June 24, 2010 at 12:15 pm

    Thanks a lot. Really helped and saved some time

Leave a Reply