Harumph

I have been having this problem for a couple of days now and have tried the mentioned solutions to no end. while running MySQL instance configuration wizard and following the instructions in this guide i get an: Error No. 1045 Access denied for user 'root'@'localhost' (using password : NO) i am running win7 and my firewall is off, i have tried running with admin rights, i have tried compatibility with XP SP3 and have tried using no password but nothing seems to work. i have also tried this on an XP machine and it had similar problem where it fails on applying security settings. if anyone could give me some more information to help me get this sorted i would really appreciate it. Edit: After some time i managed to come up with a solution, after installing mysql i chose not to configure mysql through the configuration wizard, but instead used the command line method of installing and making mysql a service and added my own password for root and created other user names. i have finally got to the point where i can open the game and join the server, the only problem being that the server is empty (No NPC's or mobs) so time for me to start looking for a solution or if anyone knows what i missed the help would be appreciated. Edit 2: again a little effort and i sorted my NPC problem, i can connect fine but only on a local machine. i just have an issue with section 18 in the guide where adding a lan server (I am assuming), but once i get into the game client i can see the new server but it is grayed out on both the host and other machines but the original MaNGOs server is available but only host machine can connect to that. will tinker some more later but any clarification on how exactly to go about section 18 would be helpful as i am unsure if i used the correct method. Edit 3: seems i was creating a new realm instead of editing the ip adress, i have set the mangos server ip to my machines ip with sqlyog and now i can connect with both local machine and another machine. thanks for the guide and for all those with problems... perseverance is the key