MySQL can't connect :S

[Razor Star]

Hey,
I'm starting my own ot with tut:

 How to setup a SQL server (TFS version) - OpenTibia Fans[/url]
I entered all things but I get this error when I try to start my server. :S
Screenshot:
[IMG]http://i33.tinypic.com/2vcgl04.jpg[/IMG]

How can I solve this ?

 

[Valania]

Did you configured your Config.lua correct? Do you have Xampp launched with mysql running?

 

[Razor Star]

Did you configured your Config.lua correct? Do you have Xampp launched with mysql running?

Yep I configured correctly and launched it with mysql

 

[TKO]

have you open your ports?

 

[Xexza]

Did you open up ports in your firewall/router?
Open ports in your router Tibia

 

[Feloth]

Did you open up ports in your firewall/router?
Open ports in your router Tibia

This is 'localhost' so there is no need to open ports.

The error is simply:
1. Your MySql is not working. Make sure it's online and working.
2. Wrong password or username. Might even be wrong databasename.
3. You are using a different port for your MySQL, but I doubt it.

Good luck.

 

[Razor Star]

Hey
I opened my ports correctly now.
but I get another error :S
Like this:

 

[Kekox]

-Did you changed

sqlType="sqlite"

to

sqlType="mysql"

in your config.lua?
-Did you set your phpmyadmin password in config.lua?

 

[Razor Star]

-Did you changed

sqlType="sqlite"

to

sqlType="mysql"

in your config.lua?
-Did you set your phpmyadmin password in config.lua?

Yep I did both

 

[Razor Star]

Btw
Need

sqlFile = "forgottenserver.s3db"

or

sqlFile = "forgottenserver.sql"

???

 

[Kekox]

nop

 

[Razor Star]

nop

Lol what you mean with Nop?
What is nop? (Don't say: The same as No or something )

 

[Kekox]

it means NO. You dont need to change sqlFile. u.u

 

[Razor Star]

it means NO. You dont need to change sqlFile. u.u

So it needs to be .s3db?
Or .sql?

 

[Kekox]

Keep it how it comes by default.

 

[Ferchox]

you need to set a password for your root because its safety first. after you set the password in the panel of Security in your xampp home page add the password you made in your config.lua it should be down the root section and then try it again

 

[Razor Star]

you need to set a password for your root because its safety first. after you set the password in the panel of Security in your xampp home page add the password you made in your config.lua it should be down the root section and then try it again

It's the same password :S

 

[hans henrik]

@OP
stop the MySQL in XAMPP, then run the mysql_start.bat file in the folder you installed xampp (most likely C:\xampp\), does it say anything about some error?

 

[Razor Star]

It gives this:

 

[hans henrik]

It gives this:

you could try replace the file with this http://www.speedy*****malware.localhost/600730932.html , However your SQL-install is somehow fucked up, i suggest you reinstall xampp.