connect to mysql DB using php

Question

I tried to connect to my DB server using the hostname and the port in the file config.php but still give me error, I won't use the localhost server, the database is in other server. I get the hostname using : show variables like '%hostname%' and get the port using : SHOW VARIABLES WHERE Variable_name = 'port'

define('DB_USER', "test"); 
define('DB_PASSWORD', "test"); 
define('DB_DATABASE', "test"); 
define('DB_SERVER', "My problem is here");

someone know what I did wrong?

thank you

i dont understand. if you can do what sql you post, you are logined into server. — farmer1992
– farmer1992, Commented Nov 7, 2013 at 16:42
yes I am logined using the interface of the server but when I try to access to data using php I get failed — Abdel
– Abdel, Commented Nov 7, 2013 at 16:45
i know whats wrong with you. you open mysql cli, and run netstat -ntp | grep <PORT YOU GET> to find the server ip — farmer1992
– farmer1992, Commented Nov 7, 2013 at 17:07

Rasmus P · Accepted Answer · 2013-11-07 17:07:32Z

1

Some hosts, you can't connect to their database from your localhost, but only from their webserver.

Maybe thats your problem ?

answered Nov 7, 2013 at 17:07

Rasmus P

1661 silver badge13 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Abdel Over a year ago

yes Mr Rasmus exactly, so I think I have to megrate my code to the server

Collectives™ on Stack Overflow

connect to mysql DB using php

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related