• 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!

Couldn't establish connection to SQL Database!

Reaper7

dunno wat 2 rite here
Joined
Feb 18, 2011
Messages
133
Reaction score
1
hi!
im testing the tfs for tibia 8.54 (cryingdamson6pl1-gui) but ive got a problem.
ive made my database, ive done everything in config.lua and for some reason it doesnt want to work:(

i run my console with xampp turned on... after a while it says "Starting SQL Connection". it loads for about 3 minutes and then i receive an error which says "Couldn't establish connection to SQL Database!". in the console it also says:
Code:
Failed connecting to database - MYSQL ERROR: Can't connect to MySQL server on 'localhost' (10061) (2003)
unfortunately, i dont know what to do. can someone please help me?
that is how my config.lua looks like:
PHP:
-- Database
	-- NOTE: sqlFile is used only by sqlite database, and sqlKeepAlive by mysql database.
	-- To disable sqlKeepAlive such as mysqlReadTimeout use 0 value.
	sqlType = "mysql"
	sqlHost = "localhost"
	sqlPort = 3306
	sqlUser = "root"
	sqlPass = "mysexypassword"
	sqlDatabase = "testowyots" -- in polish, some of you may not understand it
	sqlFile = "forgottenserver.s3db"
	sqlKeepAlive = 0
	mysqlReadTimeout = 10
	mysqlWriteTimeout = 10
	encryptionType = "plain"

hope someone will help me :)
 
I have the same problem,
I've been setting password for mysql it self and not only in Config.lua
Mysql is running, but i get errors in phpmyadmin
i had the tables set up (imported the sql file from server)
opened up 7171,7172 not 80 since i dont have a webpage
still the server can't connect to mysql database.
 
I have the exact same problem. Do anyone see any problem?

sqlType = "mysql"
sqlHost = "127.0.0.1"
sqlPort = 3306
sqlUser = "yavari"
sqlPass = "password"
sqlDatabase = "yavari"
sqlFile = "forgottenserver.s3db"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
encryptionType = "sha1"
 
for all you users it may not be the config:

go to your server folder> server application file (the one you click to run it), right click> properties > compatibility > check run this program in compatibility mode for (chose your windows).

hope this helps
 
Back
Top