[Help] Connecting with external database server (MySQL)

[Binho®]

I have problems to connect this server with external database.
I change configurations in config.lua to MYSQL database.

-- Database
passwordType = "plain"
sqlType = "mysql"
sqliteDatabase = "forgottenserver.s3db"
mysqlHost = "thalassagame.com" -- (external server database, 66.7.215.233)
mysqlUser = "thalassa_max2"
mysqlPass = "xxxxxx"
mysqlDatabase = "thalassa_warcmb"
mysqlPort = 3306


Message error:

[03/06/2008 20:40:46] Failed to connect to database. MYSQL ERROR: Host 'xxx.xx.xx.xx' is not allowed to connect to this MySQL server
[03/06/2008 20:40:46] > ERROR: Couldn't estabilish connection to SQL database!

"xxx.xx.xx.xx" is my real ip. (IPS)
I do not know it with the handle my own IP.

 

[elf]

You have to allow your computers IP at your external MySQL server, else you won't be able to connect (MySQL security).

 

[ntmr]

Also, root access is disabled by default on MySQL remote connections.

 

[tatu hunter]

You have to create an user in your mysql which accepts remote connectios!
And dont forget to open ports in your firewall... the port of mysql is 3306

 

[Binho®]

Thanks all for help.

This problem was solved!

[04/06/2008 16:44:14] >> Loading RSA key
[04/06/2008 16:44:14] >> Testing SQL connection (success)
[04/06/2008 16:44:16] >> Loading vocations
[04/06/2008 16:44:16] >> Loading commands