Windows MySQL Database Issue..

[Naxtie]

Heres the error that I get in the console.. Anyone know whats wrong?
And YES! I have put the exactly same password and database name etc.. (I already checked those stuffs -.-')

Failed connection to database - MYSQL ERROR: Can't connect to MySQL server on 'localhost' (10061) (2003)

	sqlType = "mysql"
	sqlHost = "localhost"
	sqlPort = 3306
	sqlUser = "******"
	sqlPass = "******"
	sqlDatabase = "otserv"
	sqlFile = "mysql.s3db"
	sqlKeepAlive = 0
	mysqlReadTimeout = 10
	mysqlWriteTimeout = 10
	encryptionType = "sha1"

 

[tklucas]

Maybe your server is running in another port. But i guess your mysql service isn't started.

 

[Naxtie]

It is started.. and my server is running on port 7171 and 7172 i guess

OFFTOPIC: 200 POST! WOHO!

 

[rxrob]

firewall.. are you using a router? how did u set up you database? xamp or uniserver?

 

[Naxtie]

I'm using xampp and yes i'm using a router and I did allow both mysql, apache and port 7171, 7172 on the firewall.. There should be no problems? :s

 

[socio]

The mysql service don't have started

 

[Krim]

Pretty sure your MySQL service isn't running. Verify it and then come back?

 

[Naxtie]

The website works, XAMPP says it is running.. Then how the f*ck isn't it running?

 

[Cyro]

Probably wrong pass or so lol

 

[ChiSka]

change

sqlHost = "localhost"

to

sqlHost = "127.0.0.1"

and try

REP++ if helped

 

[Naxtie]

change

sqlHost = "localhost"

to

sqlHost = "127.0.0.1"

and try

REP++ if helped

Yeah it starts, but it wont load any tables when using "127.0.0.1" as sqlHost

 

[Tachi]

I have the error 10061 when trying to login to my server from client, now i managed to fix the error for like 5 seconds, then i logged out and tryed to relog and it happened again, only difference was i created a bran new database.. not even recreating character's and accounts wouldn't let me login again.. What could be the cauz of this problem?!?!

I KNOW ALL PORTS ARE OPEN, and why the F would that even matter for me to login on the pc im running the server from.......
I tryed Changing ALL IP'S to localhost and to 127.0.0.1 .......

ALSO there for a min i got it to work when putting ip = "localhost"... and again once i logged out and tryed to log back in it gave me the 10061 error, and once i managed to get error 10060... -.- PLEASE HELP

 

[Naxtie]

I have no idea what the problem is.. It never happened to me. I can't help you with this, i'm sorry.

 

[TGYoshi]

Verify your mysql server runs on 3306 by starting cmd and running:

netstat -b -a

Run cmd as administrator.