Connecting to remote MYSQL Database

Thanks for reading ... totally blonde women here ... Running Worldbox Grid (Robust and Wifi configuration) - that all works fine but I would like to add the JOpenSim front end to our website.

The MySQL database (worldboxrobust) is on our own server which hosts the opensim grid, the Joomla website is on commercial shared hosting remotely from me.

I have created a MySQL user xusyou@xusyou - this user has full rights. My Hosting company has checked that they can access the databse from their end (as can I via my LAN) - but when i put the config into JOpenSim it says it cant access the databse.

I think I have done all the mods to GridCommon.ini and StandAloneCommon.ini - the databse has the presence field in it .....

Any idea ??

Thanks Karen

Hi Karen Mansour,

Have you try database host in jopensim without http:// ?

Make sure you have:
- configured bind-address with the correct ip (without http: //) in your my.ini
- authorized access from an external ip to your robust database
- authorized access from your external ip to your user of your robust database
- allowed external connections on port 3306 in your firewall

hiya - mmmm most I have tried but not sure how to authorized access from an external ip to your robust database - surely Robust wouldnt work otherwise?? sorry never tried this before

answer 1 - yes with and without the http:// I get the same error
answer 2 - removed the bind-address in my.ini (has a # at front of it now)
answer 3 - my hosting company can access the mysql database via Telnet(??)
answer 4 - not sure how i do that
answer 5 - port 3306 is open to all

Any more ideas?

♥Karen♥

1) without http:// is is good.
2) don't remove but configure (eg: bind-address = <REMOTE_IP>)
4) with phpMyAdmin, go to User "Accounts, select" a user and clic "Edit privileges"
On tab "Connection information", you can set the "Host name".

With mysql command prompt you can try;
1) For existi,g database:2) For new database: