[phpdoctor]

Hay,
I know this is possible by something like this:

PHP Code:

mysql_connect('http://www.mysite.com', 'user', 'pass') ; 

And use this in sql for permissions:

GRANT ALL PRIVILEGES ON [database].* TO [user]@"%" IDENTIFIED BY '[password]';

But is there a way to do it securely...?
I know its not efficient this way but I have no choice.

Anyway can someone help me out with this stuff?
Thanks,
Lex

[jexxie]

Yup, you can do this:
http://ca3.php.net/mysql_connect

You can only use an IP address to specify the remote MySQL server.

Also, it's best to limit which IPs can login to a database remotely, you can do this like so:
GRANT ALL PRIVILEGES ON *.* TO USERNAME@IP IDENTIFIED BY "PASSWORD";

Hope that helps.

[Nico]

Note that most servers don't allow that. Try to contact your host and ask them for more info.

[jexxie]

If you can connect connect to the remote MySQL server, like this, it should work fine.

If you're using Windows, Start->Run-> cmd.exe
Type:
telnet IPADDRESSOFYOURHOST 3306

IF that pops up with a connected message, you're good to go.

[phpdoctor]

Thanks guys il contact my host for some info.
But is it secure?

Also by limiting IP address access, what ip do you mean?
Thanks alot,
Lex

[fyrestrtr]

You cannot do mysql_connect('http://server.com') it must be mysql_connect('server.com') or mysql_connect('some.ip.address')

[phpdoctor]

ok thanks, but is it secure?
What if I used a SSL or something?
The information needs to be secure

Lex

[jexxie]

Hi there,

The information would be transmitted plan-text, so the information wouldn't be safe from prying eyes. If you're wanting to have it safe, I would suggest getting a local MySQL server.

[phpdoctor]

Ye I got a local mySQL server and i need to connect to a remote also.
I dont much choice with the remote sql servers.

Thanks anyway

[mab]

The mysql manual contains a section on connecting and transferring data through an SSL connection - http://dev.mysql.com/doc/refman/5.0/...using-ssl.html