Cannot connect to remote mysql with error 500 "HY000"

Connecting to SQL
1

See the error below, I have searched and cannot understand the issue. I am able to telnet into the database and have added the ip to the remote mysql table. Any help is appreciated.

{
“error”: {
“code”: “HY000”,
“message”: “SQLSTATE[HY000]: General error: 1298 Unknown or incorrect time zone: ‘’ (SQL: SELECT DATABASE() FROM DUAL)”
}
}

2

Hey @Mike_Dawson. I know its kind of a late reply. But if the problem still persists, I think the problem here would be the SSL connection not being set in your PHP script. As you’ve set up SSL for MySQL you would also need to specify this in your PHP MySQL connection.

With mysqli you can use the mysqli_ssl_set() function. Below is an example:

<?php
$con=mysqli_init();
if (!$con)
  {
  die("mysqli_init failed");
  }

mysqli_ssl_set($con,"key.pem","cert.pem","cacert.pem",NULL,NULL);

if (!mysqli_real_connect($con,"localhost","my_user","my_password","my_db"))
  {
  die("Connect Error: " . mysqli_connect_error());
  }

// Some queries...

mysqli_close($con);
?>

Let me know if it helps.
Thanks