Couldn't establish connection to SQL Database!

[Misha123]

hi!
im testing the tfs for tibia 8.6 (distro crying damson 0.3.6.) 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(Uniform Server Zero) 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)
Confiq Lua:
sqlType = "mysql"
sqlHost = "127.0.0.1"
sqlPort = 3306
sqlUser = "mishasot"
sqlPass = "***************"
sqlDatabase = "mishasot"
sqlFile = "mysql.sql"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
encryptionType = "sha1"
Please can somebody help me

 

[Pteryx]

Probably something else has the port, or you've blocked it with a firewall setting.

The delay is TCP retries.

 

[Misha123]

Bump!

 

[Pteryx]

Google "mysql error 10061 connection refused" and read one of the articles.
(The 10061 is an SQL error code from MySql; the 2003 error is from PHP)

Check the XAMPP admin console - MySql should be started and listening on 3306.

If it's not on 3306, run netstat -a, see if something else has port 3306.

If the ports are ok, check your firewall definitions. It would be weird to block localhost, but it's possible.
Check the userid setup in MySql - you can get it wrong and get rejected by MySql. I don't remember if you get this particular error though ... but if the permissions in the DB are wrong you do get a message saying which userid@host was rejected.

 

[dchampag]

Make sure the SQL server is started, it's not detecting one.

 

[lolxdx]

What SQL are you using?

 

[Misha123]

What SQL are you using?

I'm using MYSQL.sql

 

[Misha123]

Google "mysql error 10061 connection refused" and read one of the articles.
(The 10061 is an SQL error code from MySql; the 2003 error is from PHP)

Check the XAMPP admin console - MySql should be started and listening on 3306.

If it's not on 3306, run netstat -a, see if something else has port 3306.

If the ports are ok, check your firewall definitions. It would be weird to block localhost, but it's possible.
Check the userid setup in MySql - you can get it wrong and get rejected by MySql. I don't remember if you get this particular error though ... but if the permissions in the DB are wrong you do get a message saying which userid@host was rejected.

Thanks alot friend, u helped me m8! Everything got fixed thanks alot!

 

[Misha123]

bump