[mqcarpenter]

I have a client who's host does not have MySQL support, but has PHP (weird, I know).

I want to use a PHP script and let it access a MySQL DB that I have at another location. Do you know what the syntax for that would be? Sample code would be:

$isearch_sql_server = "localhost";
$isearch_sql_username = "user_name";
$isearch_sql_password = "password";
$isearch_sql_database = "database_name";

For the server, can I just put in the web address? Like, "www.mydomain.com" and put the DB name, user, etc?

TIA

[mdhall]

Yes its possible, but not recommended. Theres a post already on this forum covering this same question, and explaining how and why.

[mqcarpenter]

Originally Posted by mdhall

Yes its possible, but not recommended. Theres a post already on this forum covering this same question, and explaining how and why.

Sometimes you do what you have to.

Any idea when it was posted, or what reference? I tried a few searchs and could not find it.

Thanks

[mdhall]

http://www.programmingtalk.com/showthread.php?t=3282

[Squid44th]

Should be able, instead of:

$isearch_sql_server = "localhost";

use:

$isearch_sql_server = "http://www.mysqlhost.com";

[NeverMind]

Originally Posted by Squid44th

Should be able, instead of:

$isearch_sql_server = "localhost";

use:

$isearch_sql_server = "http://www.mysqlhost.com";

actually some servers don't allow remote mysql connections ... and some others accept them but you have to use special port for that ..
like :
http://www.mysql-server.com:2602 or whatever was the port ..
ask the host about it ...

[mqcarpenter]

I tried it and it is passing a username from the localhost instead of the one I specified, so it won't authenticate. Back to the drawing board!

[jstanden]

You should also make sure the user you create has permission from remote domains.

Here's a quick SQL example of how to allow a user to connect from any remote domain:

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

You can replace "ALL PRIVILEGES" with a specific list if you desire, such as "SELECT,CREATE,UPDATE,ALTER,DELETE". You can also replace the '%' with a specific domain or mask -- the % is a wildcard or anything.

If you intend to connect from localhost as well, you'll need to create a separate account.

The above assumes you have MySQL console access, though you should be able to do the same thing with good control panels or a GUI like phpMyAdmin.

Thanks!

[mqcarpenter]

Originally Posted by jstanden

You should also make sure the user you create has permission from remote domains.

Here's a quick SQL example of how to allow a user to connect from any remote domain:

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

You can replace "ALL PRIVILEGES" with a specific list if you desire, such as "SELECT,CREATE,UPDATE,ALTER,DELETE". You can also replace the '%' with a specific domain or mask -- the % is a wildcard or anything.

If you intend to connect from localhost as well, you'll need to create a separate account.

The above assumes you have MySQL console access, though you should be able to do the same thing with good control panels or a GUI like phpMyAdmin.

Thanks!

Good information. I will try that. Thank you