Cannot connect to MySQL

[hawk16]

2007-02-24 01:36:40 World Database: 127.0.0.1;3306;root;;mangos_bc
2007-02-24 01:36:40 ERROR:Could not connect to MySQL database at 127.0.0.1: Access denied for user 'root'@'localhost' (using password: YES)

2007-02-24 01:36:40 ERROR:Cannot connect to world database 127.0.0.1;3306;root;;mangos_bc



I get this error everytime I try to connect. I have double and triple checked the MySQL info, and the MySQL of curse is running.

Both realmd and mangos.exe crash immediately since they cannot connect. I don't know why its not connecting, please any tips. I already tried searching and could not find anything.

 

[Zealotto]

127.0.0.1;3306;root;;mangos_bc

Is there any extra semicolon?

 

[raul.roland]

Guess U forget to add your db password:
127.0.0.1;3306;root;;mangos_bc

should be
127.0.0.1;3306;root;yourpassword;mangos_bc

 

[MadPixy]

I have the same problem, my logfile looks exactly the same too.
I didn't set a password for my sql and it worked fine for an L2 emulator.

 

[Cobra101]

MySQL by itself always wants a password. How-ever, most people set it up as root;root so a lot of people make their conf files in that manner. As roland said it needs to be in this format:

127.0.0.1;3306;root;yourpassword;mangos_bc

it's most likely

127.0.0.1;3306;root;root;mangos_bc

but if you set a custom password...hopefully you remember what it is, lol.

 

[MadPixy]

I reconfigured mysql and set my pass to root, now it works
Kinda weird it didnt work without pass.

 

[Lioner]

in wich file is the 127.0.0.1;3306;root;yourpassword;mangos_bc located? cause i have the same problem...

 

[Cobra101]

@madpixy Well, not really, you needed a password and didn't use one...welcome to MySQL, lol.
@lioner Look for the files named Realmd.conf and Mangos.conf.