• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

[Help] Connecting with external database server (MySQL)

Binho®

KooL =D
Joined
May 27, 2008
Messages
344
Reaction score
0
Location
BrZ Style
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.
 
You have to allow your computers IP at your external MySQL server, else you won't be able to connect (MySQL security).
 
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
 
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
 

Similar threads

Back
Top