ERROR: Couldn't estabilish connection to SQL database!

[Miricx]

FYI: I've played tibia since 2001 and have hosted many XML servers (I stopped play Tibia right after SQL became mainstream), so this is basically the first time I'm opening a SQL server.

I keep getting this error all the time I'm trying to run my Forgotten Server 8.60 server.

[23/10/2012 17:55:05] Failed connecting to database - MYSQL ERROR: Can't connect to MySQL server on 'localhost' (10061) (2003)

[23/10/2012 17:55:05] > ERROR: Couldn't estabilish connection to SQL database!

This is how my Config.lua looks like

	-- 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 = "MYPASS"
	sqlDatabase = "MYDATABASE"
	sqlFile = "schemas/mysql.sql"
	sqlKeepAlive = 0
	mysqlReadTimeout = 10
	mysqlWriteTimeout = 10
	encryptionType = "sha1"

 

[Evan]

Have you followed any tutorials?
Like this one: http://otland.net/f479/video-tutorial-nothing-fully-working-ot-server-website-shop-system-166818/

 

[Miricx]

I followed it, and did exactly as he did, but i still get the same error when I'm trying to open up the server.

 

[Runes]

Are you sure you are running MySQl? If then, try substituting "localhost' with '127.0.0.1" in your config.lua file.

 

[Evan]

If you followed the tutorial, then your sqlUser should be the same as sqlDatabase.
So, it would be something like this:

	-- 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 = "MYDATABASE"
	sqlPass = "MYPASS"
	sqlDatabase = "MYDATABASE"
	sqlFile = "schemas/mysql.sql"
	sqlKeepAlive = 0
	mysqlReadTimeout = 10
	mysqlWriteTimeout = 10
	encryptionType = "sha1"