Tell me more ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 0 down vote favorite

How can I connect to my remote database using ip address? I have this code but evetime I load my site I get an error Could not connect to MySQL: Can't connect to MySQL server on 'xxx.xx.xxx.xx:80'

define ('DB_USER', 'user');
define ('DB_PASSWORD', 'password');
define ('DB_HOST', 'xxx.xx.xxx.xx:80');
define ('DB_NAME', 'databaseName'); 
$dbc=mysql_connect(DB_HOST, DB_USER, DB_PASSWORD) 
    OR die ('Could not connect to MySQL: '.mysql_error()); @mysql_select_db (DB_NAME) 
    OR die ('Could not select the database" '.mysql_error());;
share|improve this question
2  
What about port 3306? –  MS_SP Aug 16 at 8:02
 
Usually port 80 is used for webservers. –  DannyThunder Aug 16 at 8:04
 
Thanks I will try port 3306 –  user2658838 Aug 16 at 8:26

4 Answers

up vote 2 down vote

Try using port 3306 instead:

define ('DB_HOST', 'xxx.xx.xxx.xx:3306');

Port 3306 is the default MySQL port, whereas port 80 is HTTP.

share|improve this answer
 
I get a server error when I load my website. –  user2658838 Aug 16 at 9:56
up vote 1 down vote

The database server must be made available for remote access. As the usual MySQL server has no encryption, and it would generally be more of a security issue to make such a server available for the whole internet, any hosted mysql server usually is only available from the local network, if at all.

Check with your hosting company if you can access the database server from outside.

After that answer is yes, you must also know that user accounts in MySQL are not only username/password, but also contain a "source IP" component (which can be a wildcard "*", but usually is not), so there is another layer of protection to allow only dedicated IP addresses to gain access. Do you have a dynamic IP? That might be another problem to be solved.

share|improve this answer
 
I am using a static.. the IP of my router..then routes it to port 3306 –  user2658838 Aug 16 at 8:30
 
Then routes it to the pc where my remote database is located. –  user2658838 Aug 17 at 3:35
 
Are you saying that your setup is more complicated that you stated in your question? Having some NAT device in the chain might affect things. And you didn't say something to the accound IP setting you are using. –  Sven Aug 17 at 7:45
 
I am using the roter's static IP then port forward when port is used 3306 to my pc where the database is. –  user2658838 Aug 17 at 7:53
 
And why are you going to port 80? –  Sven Aug 17 at 7:58
show 7 more comments
up vote 0 down vote

If using port 3306, like the other answer says, still doesn't give you a connection, you could try two things:

Look in your /etc/mysql/my.cnf. You might find a line like this:

bind-address           = 127.0.0.1

Comment it out by putting a "#" in front. If that still didn't help, check if the user you are trying to connect with is allowed to connect from all hosts.

Oh, and another thing: Don't use PHP's mysql library. Use PDO or mysqli instead, as the mysql library is deprecated.

share|improve this answer
 
PS i am using xampp..where can i find the /etc/mysql/my.cnf? –  user2658838 Aug 16 at 8:17
 
Type mysql --help in command line, in the output block that follows there's a block of text which says which config file is used. Usually, it's c:\xampp\mysql\bin\my.ini. –  cuewizchris Aug 16 at 8:19
 
Thanks. the bind-address = 127.0.0.1 already has been commented out as default. I will try the PDO or mysqli –  user2658838 Aug 16 at 8:34
 
Where can I check if user is allowed to connect from all hosts? –  user2658838 Aug 16 at 9:27
 
Check the table user in database "mysql". If the user you're trying to connect with only has host "localhost", you can't connect with it from the outside. Change that to "%". –  cuewizchris Aug 16 at 9:30
show 5 more comments
up vote 0 down vote

Try using the default port number: 3306

share|improve this answer
 
I get a server error when I load my website –  user2658838 Aug 16 at 10:17
 
What error do you get? –  Mikkel Aug 17 at 10:42
 
Could not connect to MySQL: Host 'xxx.xxx.xxx.hostingprod.com' is not allowed to connect to this MySQL server –  user2658838 Aug 19 at 5:55

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.