SQL connection from another server

[sibbe]

I have paid for a webhotel and domain in order to run a website. The webhotel has a phpmyadmin function so I can run a database.
I would like to run the OT server from my computer, but I want the OT server to connect to the database on my webhotel.

I have created a database on my webhotel but I don't know what info to enter in config.php so that my OT server can connect to the database.

sqlType = "mysql"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = ""
sqlPass = ""
sqlDatabase = "sibbe"
sqlFile = "forgottenserver.s3db"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
encryptionType = "plain"

(Here is a picture of some info on my phpmyadmin, but when I enter the info it still says "Could'nt estabilish connection to SQL database!" when I run the Tibia-server.

 

[kosan100]

where did you locate your database?

 

[sibbe]

where did you locate your database?

On a webhotel called one.com

I use their phpmyadmin interface.

 

[Aklovo]

Mmm? Are you trying to setup your mysql in a Web Hosting service?
I havent heard that before o.0

 

[sibbe]

Mmm? Are you trying to setup your mysql in a Web Hosting service?
I havent heard that before o.0

Yeah.
Is it not possible to do this?

I found this information on phpmyadmin on the webhost:

So I figured that I should enter that information in config.lua;

sqlType = "mysql"
sqlHost = "10.246.16.32"
sqlPort = 3306
sqlUser = "[email protected]"
sqlPass = ""
sqlDatabase = "dailyevents_se"
sqlFile = "forgottenserver.s3db"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
encryptionType = "plain"

But when I started the server it still cannot locate the database.

 

[sibbe]

Contacted my webhost service and they said external SQL is not possible. This thread may be closed.