Connecting to MySQL from another IP/Website

Asked Aug 02 '15 at 19:59

Active Aug 02 '15 at 20:36

Viewed 66 times

I've newly set up a VPS and installed WHM.

I have a MySQL DB on this server which I am able to connect with using a desktop SQL application called Sequel Pro.

Using PHP I have set up a subdomain which I want to connect to this DB, I have used the same details as the Desktop Client but I keep receiving PHP Warning: mysqli::mysqli(): (HY000/2003) messages in my PHP error_log.

I'm completely stumped as I thought I would be able to connect to the DB from another website. I have add % to the cPanel Remote MySQL® and still no luck.

Could someone please point me in the right direction.

<?php
$mysqli = mysqli_connect("HOST_IP","DB_USER","DB_PASS","DB_NAME");

// Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }

$q = $mysqli->query("SELECT COUNT(*) FROM users");
print_r($q);

edited Aug 02 '15 at 20:36

asked Aug 02 '15 at 19:59

ngplayground

20,365
36
94
173

Does this help: http://stackoverflow.com/questions/22750724/mysqli-connect-hy000-2003-cant-connect-to-mysql-server-on-domain-name ? – Martin Aug 02 '15 at 20:06
any firewall in your vps? – Maytham Fahmi Aug 02 '15 at 20:07
@maytham I've disabled ConfigServer but still no luck – ngplayground Aug 02 '15 at 20:09
Can you post how you've setup your DB connection in PHP? – Lloyd Banks Aug 02 '15 at 20:34
@LloydBanks added to the post above – ngplayground Aug 02 '15 at 20:36
Can you post your my.cnf file? There could be a problem with the bind-address setting. One option that has security implications, but I'm usually fine with is to set it to 0.0.0.0 and thus bind to all IP addresses. – Nicholas Byfleet Aug 02 '15 at 20:40
@Donald I ran your code and it works fine for me. What do you get as the output from the `print_r($q)`? – Lloyd Banks Aug 02 '15 at 20:44

Connecting to MySQL from another IP/Website

0 Answers0