"Can't connect to MySQL server on" error when connecting to an external MySQL server

Question

We recently updated PHP to the latest version, and we had a PHP script that was running that is now broken.

Currently, it is not even allowing me to connect to the SQL database at all, and is returning this error:

Failed to connect to MySQL: Can't connect to MySQL server on mysql01.fau.edu (13) 2003

The database itself is located in a Linux environment and I currently cannot get even a simple script as the one below running:

$host = 'mysql01.fau.edu';
$username = '*****';
$password = '*****';
$database = '******';
$connect = mysqli_connect($host,$username,$password,$database);

if (mysqli_connect_errno()) {
    echo 'Failed to connect to MySQL: ' . mysqli_connect_error() . mysqli_connect_errno();
} else {
    echo 'Connected to MySQL! </ br>';
}

The database is running on a _remote_ machine, or on the same machine you're testing this PHP script from? — Michael Berkowski, Sep 04 '14 at 19:11
The error suggests the port is unavailable (firewalled, etc). If you just `telnet mysql01.fau.edu 3306` do you get a successful socket open? — Michael Berkowski, Sep 04 '14 at 19:12
The database is running on a remote machine. The exact script does work using an older version of PHP on my laptop. — Evan Beardsley-Dodd, Sep 04 '14 at 19:20
I did do the telnet, and it returned with an open connection. — Evan Beardsley-Dodd, Sep 04 '14 at 19:56

score 1 · Answer 1 · answered Sep 04 '14 at 19:36

1

For security purposes Mysql is not remotely accessible by default, unless you whitelist the allowed IP in the backend.

You have mentioned it used to work on your laptop which could very possibly change IP.

Use the same network when it was working

answered Sep 04 '14 at 19:36

meda

45,103
14
92
122

score -1 · Answer 2 · answered Sep 04 '14 at 19:15

-1

Just guessing...but check to make sure you can connect to mysql from the command line. If so...double check your php.ini. Sounds like php.ini may have been overwritten with the upgrade. Make sure you have the extensions for mysql enabled.

answered Sep 04 '14 at 19:15

ken koehler

464
4
12

score -1 · Answer 3 · answered Feb 24 '18 at 07:21

-1

mysqli connect stopped working from version 5.5 upwards, from php 7 updwards, it was removed and will give you a http ERROR 500 refer to the link below

"Call to undefined function mysql_connect()" after upgrade to php-7

answered Feb 24 '18 at 07:21

Chukwu Stanley

19
1
6

"Can't connect to MySQL server on" error when connecting to an external MySQL server

3 Answers3