Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Cannot connect to MySQL

Initiate Mage
Joined
Apr 16, 2005
Messages
26
Reaction score
0
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.
 
Initiate Mage
Joined
Feb 1, 2007
Messages
1
Reaction score
0
127.0.0.1;3306;root;;mangos_bc

Is there any extra semicolon?
 
Initiate Mage
Joined
Jan 7, 2007
Messages
75
Reaction score
0
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
 
Initiate Mage
Joined
Feb 20, 2007
Messages
3
Reaction score
0
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.
 
Junior Spellweaver
Joined
Jul 11, 2006
Messages
139
Reaction score
0
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:
Code:
127.0.0.1;3306;root;yourpassword;mangos_bc
it's most likely
Code:
127.0.0.1;3306;root;root;mangos_bc
but if you set a custom password...hopefully you remember what it is, lol.
 
Initiate Mage
Joined
Feb 20, 2007
Messages
3
Reaction score
0
I reconfigured mysql and set my pass to root, now it works ;)
Kinda weird it didnt work without pass.
 
Junior Spellweaver
Joined
Mar 21, 2006
Messages
109
Reaction score
1
in wich file is the 127.0.0.1;3306;root;yourpassword;mangos_bc located? cause i have the same problem...
 
Junior Spellweaver
Joined
Jul 11, 2006
Messages
139
Reaction score
0
@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.
 
Back
Top