Mysql – Remote Server can’t access RDS Database

amazon-rdsamazon-web-servicesMySQLPHPrds

I'm having problems accessing my Amazon RDS MySQL Database from my server.

I get this:-

[Thu Sep 22 13:45:33 2011] [error] [client xx.xx.xx.xx] PHP Warning:  mysqli::mysqli() [<a href='function.mysqli-mysqli'>fqli-mysqli</a>]: (HY000/2003): Can't connect to MySQL server on 'xxxx-1.rds.amazonaws.com' (110) xxx.php on line 22, referer: xxx**

I've tried manually accessing via cmdline on server with:-

mysql -h xxxx.rds.amazonaws.com -p –port=3306

I then asks for password – which I put in, and it hangs and says

ERROR 2003 (HY000): Can't connect to MySQL server on 'xxxx.rds.amazonaws.com' (110)

Is this a port and/or firewall related problem? If so, what should I be addressing?

Is it because I'm already running a mysql srvr on this box, on port 3306?

Best Answer

Possible reasons are - Firewall is blocking access to port 3306 - database server is not running on default port (3306) - the MySQL daemon is configured to accept connections only from localhost, not from remote host. (can be tested by "netstat -ntlp").

Related Solutions

Mysql – how to diagnose a remote thesql database connection

Error 2003 indicates that the connection has been refused. This could be because a firewall blocks it, or because the mysql server is configured only to allow unix socket connections which can only be local, or only local ip connections via the 127.0.0.1 interface.

You need to examine the mysql configuration file in /etc to see how it is configured if you have the access rights for it. Otherwise you probably will not be able to change it anyway, since you might need to change this file if it is configured in this way.

However, you should be very careful if you allow remote connections, since they could also be a security problem.

Can’t authorize a server for Amazon RDS

If it works from your laptop, apparently you have authorized the IP at which your laptop appears on the Internet to connect to RDS. Browse whatismyip.com to see that public IP. If you browse to whatismyip from your dedicated server, you can verify that server's public IP, and make sure it is authorized in AWS. If it's just one IP, enter it as x.x.x.x/32.

If you use tcp port 3306 for MySQL, from a shell/cmd prompt on the dedicated server, enter

telnet db.address.us-east-1.rds.amazonaws.com 3306

If the connection times out instead of opening a new window, and you confirm that your dedicated server's public IP is authorized, then something in your server or hosting provider's network is probably blocking your connection. Support should be able to help find and fix it.

Best Answer

Related Solutions

Mysql – how to diagnose a remote thesql database connection

Can’t authorize a server for Amazon RDS

Related Topic