Connecting to remote MySQL server using PHP

Question

I am attempting to connect to a remote MySQL server from my local machine virtualhost using the following code    conn   mysql connect   dbhost     dbuser     dbpass   or die mysql error             mysql select db  dbname   conn  or die mysql error       My problem is that I am unable to connect locally  receiving the error      Can t connect to MySQL server on  xxx xxx xxx xxx   10060    This is not the case when I upload the same PHP file to the server  I am able to query the database with no problems at all   I am unable to connect via command line either  but I can access cPanel which rules out the chance of my IP being banned accidentally   My local server is running PHP 5 2 9  the remote server 5 2 12

User · Answer

It is very easy to connect remote MySQL Server Using PHP, what you have to do is:

Create a MySQL User in remote server.
Give Full privilege to the User.
Connect to the Server using PHP Code (Sample Given Below)

$link = mysql_connect('your_my_sql_servername or IP Address', 'new_user_which_u_created', 'password');
if (!$link) {
    die('Could not connect: ' . mysql_error());
}

echo 'Connected successfully';

mysql_select_db('sandsbtob',$link) or die ("could not open db".mysql_error());
// we connect to localhost at port 3306

User · Answer

firewall of the server must be set-up to enable incomming connections on port 3306 you must have a user in MySQL who is allowed to connect from    any host   see manual for details    The current problem is the first one  but right after you resolve it you will likely get the second one

User · Answer

This maybe not the answer to poster s question But this may helpful to people whose face same situation with me   The client have two network cards a wireless one and a normal one  The ping to server can be succeed However telnet serverAddress 3306 would fail   And would complain     Can t connect to MySQL server on  xxx xxx xxx xxx   10060    when try to connect to server So I forbidden the normal network adapters  And tried telnet serverAddress 3306 it works And then it work when connect to MySQL server

User · Answer

I just solved this kind of a problem  What I ve learned is    you ll have to edit the my cnf and set the bind-address   your mysql server address under  mysqld  comment out skip-networking field restart mysqld check if it s running  mysql -u root -h your mysql server address    p   create a user  usr or anything  with   as domain and grant her access to the database in question   mysql gt  CREATE USER  usr      IDENTIFIED BY  some pass   mysql gt  GRANT ALL PRIVILEGES ON testDb   TO  monty      WITH GRANT OPTION   open firewall for port 3306  you can use iptables  make sure to open port for eithe reveryone  or if you re in tight securety  then only allow the client address  restart firewall iptables   you should be able to now connect mysql server form  your client server php script

[php] Connecting to remote MySQL server using PHP

Examples related to php

Examples related to mysql

Examples related to mysql-connect

Examples related to remote-server

Examples related to mysql-error-2002