Use Remote mysql Database?

[matthewamzn]

I'm trying to retrieve data from a remote mysql database, but I can't connect to it.

$conn = mysql_connect ("remoteserverip", db_username, db_password)
or die ('could not connect. ' . mysql_error());
mysql_select_db (db_name, $conn);

[coopster]

Are you certain the MySQL server is setup to allow remote connections?

[matthewamzn]

I'm using the Plesk control panel. I do ssh into the server to create mysqldumps, but I haven't connected in this way before.

[coopster]

If you must use remote connections you should check into the security implications and permissions [dev.mysql.com] required to make remote connections. You may also want to have a closer look at the optional

MYSQL_CLIENT_SSL

client flag during mysql_connect() [php.net].

[matthewamzn]

Do I need to login to the remote database (phpmyadmin) and enable connection from the originating server?

GRANT ALL PRIVILEGES ON db.* TO matt@'originserverip';