Solved MYSQL ERROR: Can't connect to MySQL server on 'localhost' --please help!

[kird]

I solved the problem, scroll down to Lolaye's post for the solution.

I downloaded the 0.3.9pl1 version of forgottenserver sources
I could compile the server with no problem, configured the config.lua perfectly but when i try to start the server im getting the folowing error:

[03/07/2010 18:01:34] Failed connecting to database - MYSQL ERROR: Can't connect to MySQL server on 'localhost' (10061) (2003)

[03/07/2010 18:01:34] > ERROR: Couldn't estabilish connection to SQL database!

this is how my config.lua looks like:

sqlType = "mysql"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "root"
sqlPass = "xxxx"
sqlDatabase = "warot"
sqlFile = "mysql.sql" --I picked this file from the schema folder (might be the problem?)
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
encryptionType = "plain"

I have xampp ON also, both mysql and Apache are "running"

can any of you spot the problem?
Thanks in advance

yours~

Kird

 

[KylerXX]

I think the problem is sqlFile line, remove the content and test.

 

[kird]

Thnx for the reply but that didnt solve the problem

 

[Rayeko]

I don't know if this is the problem, but, at least in my config.lua I have it like this:

sqlFile = "forgottenserver.s3db"

 

[kird]

i tried that but still doesnt work

Do i have to import this forgottenserver.s3db on the myPhpAdmin database?
right now im useing the mysql.sql file that comes on the schema folder

again, thnx for the fast reply

bump

 

[KylerXX]

Hmm you create the database "warot"?

 

[kird]

yes, i created a database named warot and linked the mysql.sql to it.
Dunno whats wrong :s

 

[LoLaye]

If you compiled your server to support 8.54-7 use

sqlHost = "127.0.0.1"

instead of

sqlHost = "localhost"

 

[Siramix]

He may as well use his local ip adress, perhaps 127.0.0.1 is not his corret local adress.

 

[Onizuka]

Correct config should look like this

        sqlType = "mysql"
	sqlHost = "localhost"
	sqlPort = 3306
	sqlUser = "root"
	sqlPass = "anco"
	sqlDatabase = "server1"
	sqlFile = "theforgottenserver.s3db"
	sqlKeepAlive = 0
	mysqlReadTimeout = 10
	mysqlWriteTimeout = 10
	encryptionType = "plain"

Make sure you can access database by going to

ip/phpmyadmin

with the name user root and pass you have. And make sure its correct with same in config.lua

 

[kird]

If you compiled your server to support 8.54-7 use



instead of

OMFG, dude it worked! i love you haha
never thought that could be the problem!.

I'll change the thread title as [SOLVED]

Again, thnx!

 

[LoLaye]

You're welcome, glad i could help

 

[Siramix]

Great guy! Thanks for your supporting side, and change the thread to solved.
Very appreciated. As well, good work Lolaye, thumbs up!

 

[Tyveck]

haha thank god for this post Lolaye you helped me out alot was having the same problems thank you.

 

[verenko]

Thx LoLaye

 

[darragh11]

can anyone help me plz

[12/06/2018 14:25:12] Failed connecting to database - MYSQL ERROR: Can't connect to MySQL server on 'localhost' (10061) (2003)

[12/06/2018 14:25:12] > ERROR: Couldn't estabilish connection to SQL database!