Xampp step 2 error help please!!?!?

[lucasfg]

Hi i need help on step 2 because says have some error this is what shows in the step 2.

STEP 2
Check database connection
If you don't see any errors press link to STEP 3 - Add tables and columns to DB. If you see some errors it mean server has wrong configuration. Check FAQ or ask author of acc. maker.Database error - can't connect to MySQL database.

Possible reasons:
1. MySQL server is not running on host.
2. MySQL user, password, database or host isn't configured in: C:/otserv/config.lua .
3. MySQL user, password, database or host is wrong.

can any one help me pleasee i realy need this fixedd =[[ thanksseace:

 

[Rexxar]

I'm fairly sure the red text gives a hint to what might be wrong...

Do you use MySQL or SQLite?

 

[gruceqq]

Hi i need help on step 2 because says have some error this is what shows in the step 2.

STEP 2
Check database connection
If you don't see any errors press link to STEP 3 - Add tables and columns to DB. If you see some errors it mean server has wrong configuration. Check FAQ or ask author of acc. maker.Database error - can't connect to MySQL database.

Possible reasons:
1. MySQL server is not running on host.
2. MySQL user, password, database or host isn't configured in: C:/otserv/config.lua .
3. MySQL user, password, database or host is wrong.

can any one help me pleasee i realy need this fixedd =[[ thanksseace:

1. open control Panel of xamp and look MYSQL - it must be "RUNNING".
2. go to config.lua in your ot folder and look at lines:

ip = "127.0.0.1"

fill it with your ip adress, but remember " is before and after ip adress.

sqlType = "mysql"
	sqlHost = "localhost"[B] - it should stay as localhost - don't change that[/B]
	sqlPort = 3306 [B]- don't change that[/B]
	sqlUser = "root" - fill it with your database root user
	sqlPass = "" - and here type your pass to the database for your "sqlUser"

3.Second thing is a root user and password - did you set it in your xamp installation??

 

[lucasfg]

yeah i did all this =[[

 

[lucasfg]

Solved thank you!