Remote connection to a MySQL database

[dejoslav]

I tried to access my sql database from a different server, but it doesn't work. Didn't get any error/warrning messages... just a blank page...

I heard that I need to add a user in mysql.db file or something?! Could anyone explain that to me?

[filburt1]

Ask your host to grant a given user remote access rights. Not all hosts support this but many do.

[DrkFusion]

To access you database remotly, your host must change or add how a user will access the database. Usually its localhost, but now you will have to add the url. It should work after that has been modified. On one of my databases its set with full address through out the whole database so extra users will not have to be added.

[dejoslav]

Can you tell me what exactly I need to do? I have root access and everything...

[DrkFusion]

You can try adding a new user, and setting the hostname for that user to the adress of your site.

If you wish I can explore the way my host does it. When I used to administor fully my database I would do that and it would work.

I did a quick search in the mysql documentations at mysql.com but common keywords did not bring anything up useful. I will ask my host though if you wish.

[dejoslav]

Thanks. I've found out that there is a command GRANT that does that...

Now I'll try to figure it out...