Windows Xampp / Website / MySql Problem

[Lava Titan]

Heya ppl i got a big problem with my server after i reset my comp
I had to install xampp and everyshit that i had again but now serv wont open
it says "> ERROR: Couldn't estabilish connection to SQL database!

Then i went on the db on localhost

Theres missing many things from my old db

Does any1 know how i can get them back without doing a reset?

 

[stian]

Did you have the table type set to "Memory"? If so, they are all gone. Otherwise I find it quite strange that the tables should just disappare like that.

 

[Feloth]

If you wont be able to retrive, please let this be a reminder to always make backup.

 

[Nerglexo]

It can be in the config.lua

-- MySQL
	mysqlHost = "localhost"
	mysqlUser = "root"
	mysqlPass = "---"
	mysqlDatabase = "---" [COLOR="red"](you have to put your database name there)[/COLOR]
	mysqlPort = 3306

 

[Lava Titan]

Nop i created a new database now but, server now says:

>> Starting SQL connection
Failed connecting to database - MYSQL ERROR: Access denied for user 'root'@'loca
lhost' (using password: YES) (1045)

> ERROR: Couldn't estabilish connection to SQL database!

Xampp Panel:



Database:



Ports opened:

3306, 80, 7171, 7172

Config.lua:

Everything right , pass , user, db name, port 3306 blabla

Does any1 know what must be the problem?

 

[Rexxar]

Are you running XAMPP on the same PC that you're hosting the server on?

Also, are you sure you have typed in the correct password for the MySQL root user?

Personally I would suggest creating another user with full access to said database, and then use that users log in information to access the database instead.

 

[Lava Titan]

ofc that i'm running xampp on the same pc that i have the server on -.-

ye i have typed the correct password

 

[Rexxar]

ofc that i'm running xampp on the same pc that i have the server on -.-

ye i have typed the correct password

No need to be rude, It is possible to install XAMPP/MySQL on a different computer than the one running TFS, and MySQL can be set to deny ROOT login on remote machines. Thus why I asked.

Try creating a new user with full previlegies to your database, and use that info for your server to connect, it should work just as well.