MYSQL ERROR - I have tried alot, please help.

[phokuz]

[[THIS QUESTION IS SOLVED]], IT WORKS NOW, I DONT KNOW WHAT THE PROBLEM WAS BUT IT WORKS NOW SOMEHOW

[12/12/2008 10:35:11] >> Loading config
[12/12/2008 10:35:11] > Using plaintext passwords
[12/12/2008 10:35:11] >> Loading RSA key
[12/12/2008 10:35:11] >> Starting SQL connection
[12/12/2008 10:35:11] Failed connecting to database. MYSQL ERROR: Access denied for user 'root'@'localhost' (using password: NO)
[12/12/2008 10:35:11] > ERROR: Couldn't estabilish connection to SQL database!

What am I doing wrong? I have tried to figure out the problem by myself for too long time now and now I need your help! I tried following with no positive results; REinstall/Install Xampp and XamppLite several times, also the whole OT once. Ive read all the SQL-Tutorials in the tutorial forum..

Im using Xampp, I sucesfull loaded the .sql-files, both schema.mysql and database.sql from xampp\htdocs which I got from Nicaws Acc manager.

After that was going to try to host my server (0.3b1pl2-gui - TFS v0.3 alpha 4) when the above error occured.

This is how my config.lua looks like;

-- Database
passwordType = "plain"
sqlType = "mysql"
sqliteDatabase = "forgottenserver.s3db"
mysqlHost = "localhost"
mysqlUser = "root"
mysqlPass = "123" *
mysqlDatabase = "otserv"
mysqlPort = 3306

-- Connection Config
ip = "127.0.0.1"
port = 7171
.......... and so forth..

* = Same password i typed in the Security console MySQL & XAMPP directory protection. As I have the same password in my config.inc file.

 

[Fare]

mysqlPass = "*", I dont think what it is "ok" password, just leave it blank: mysqlPass = "", and don't set password on xammp. Or just set both password to somethingmore friendly, like "phokuz123".

Also i see "Failed connecting to database. MYSQL ERROR: Access denied for user 'root'@'localhost' (using password: NO)" This mean what you don't useing password... idk where it is, but just delete "*" to "", and try again :>

 

[phokuz]

thank you but the password i use is not "*" symbol its 123123 i just made a star to indicate that i used the same password everywhere i use 123123 in all the files.

this is how it looks:

mysqlPass = "123123"

and its the same password i use in the config.ini file and in the Security console MySQL & XAMPP directory protection.

 

[christiandb]

got mysql running?

 

[phokuz]

yes, i think so I atleast got the XAMPP control panel with MySQL and Apache running.

 

[christiandb]

how did u set your pass?

 

[Fare]

just try without passwords ;> it will be more easier to found error then

 

[phokuz]

just try without passwords ;> it will be more easier to found error then

I cant;

"ERROR: The string for the user name and password must have at least three characters and not more then 15 characters. Special characters like <öäü (usw.) and empty characters are not allowed!"

 

[phokuz]

I tried without password too, cmon people someone should know how to do it? all i want to do is to be able to create a character and log on to my ot.

 

[phokuz]

now i got a new error, when I reinstalled xampp

[13/12/2008 01:59:19] >> Starting SQL connection
[13/12/2008 01:59:19] Failed connecting to database. MYSQL ERROR: Unknown database 'theforgottenserver'
[13/12/2008 01:59:19] > ERROR: Couldn't estabilish connection to SQL database!

The database in the PHPadmin is called otserv
and the databse in the config.lua is called otserv
as is the one in config.ini

 

[phokuz]

and when i typed in a password in the files and in the PHPadmin and the XAMPP security center i went back to the initial problem:

Failed connecting to database. MYSQL ERROR: Access denied for user 'root'@'localhost' (using password: NO)
[13/12/2008 02:07:30] > ERROR: Couldn't estabilish connection to SQL database

 

[kornholi]

You are editing the wrong config.lua file?

 

[phokuz]

You are editing the wrong config.lua file?

But there only exists one? I have one config.lua file and it belongs to my OT servers root directory, in this case "0.3b1pl2-gui".

 

[Teddy]

remove it from winrar/winzip folder

 

[phokuz]

remove it from winrar/winzip folder

i dont have it in its zip folder i have it extracted in a regular windows folder, with the same name as the zip archive.

im getting so frustrated over this, i will never be able to make an ot if i cant even get trought the first step, and no one here knows how to solve it.

 

[phokuz]

Edited my post with a better explanation since no one has yet solved it. bomp!

 

[Matoxewu]

I'm having the same problem I've had a server online and people could join but all sudden after a few characters made bam this problem and I have not done anything to change it

 

[Donio]

I got the exakt same problem, pleas help us anyone?

 

[Belthazor]

[[THIS QUESTION IS SOLVED]],

This is how my config.lua looks like;

-- Database
passwordType = "plain"
sqlType = "mysql"
sqliteDatabase = "forgottenserver.s3db"
mysqlHost = "localhost"
mysqlUser = "root"
mysqlPass = "123" *
mysqlDatabase = "otserv"
mysqlPort = 3306

do it like this and it will word

	sqlType = "mysql"
	sqlHost = "localhost"
	sqlUser = "root"
	sqlPass = "pass"
	sqlDatabase = "dbname"
	sqlPort = 3306
	sqlFile = "forgottenserver.s3db"
	sqlKeepAlive = 60
	passwordType = "plain"

you hade every thing Mysqlpass Mysqluser Mysqlhost that was wrong ;p