Connecting to remote MySQL

[Anon]

Hi everybody,

I urgently need to connect to a remote MySQL-server and wondered if anybody had success in doing so? I searched a lot to find something out about this problem but I didn't find anything useful. Can anybody give me some advice?

[[deleted]]

What's the problem?

[Anon]

how do mean 'connect'? via ODBC or just command line? Can you telnet or SSH to the server? are you in control of the server or is it hosted somewhere? more info needed.

[Anon]

Here is my code:

<?php
$db = "";
$host = "..:3306";
$user = "";
$password = "*";

$dblink = mysql_pconnect ($host, $user, $password);
mysql_select_db($db, $dblink);

$record_set=db_send($db, "SELECT * FROM ".$table);
?>

I get the following error:

Warning: Access denied for user: '@.*' (Using password: YES)

But the username and password are OK. They work fine if the PHP-script is executed on the same server-machine as MySQL ($host="localhost").

Any suggestions?

[Anon]

that means your permissions aren't set up correctly on the server.

[[deleted]]

"But the username and password are OK."

MySQL does not only authenticate by username and password, it also uses the hostname.

When you logon locally, you have access for user 'bla@localhost'

To connect from remote, you must have access for 'user@hostyouareconnectingfrom'

If this is your own server, and you have administrative rights on the mysql server, you can use the GRANT statement in SQL to add the rights, something like

GRANT all ON database.* TO user@remotehost IDENTIFIED BY 'password';

I urge you to read the MySQL documentation about the GRANT statement and about how the MySQL 'privileges system' works.

Doing this 'badly' can create serious security holes which hackers will find.

[Anon]

Thanks a lot guys

that was exactly what I was missing...
I think my problem is solved now.