porta Posted March 19, 2007 Share Posted March 19, 2007 Okay so Im setting this up and im at the part where I have to connect to Mysql Host. I set the Host Address as localhost, the username as root, my password ******, port 3306, and database as mangos_bc;realmd_bc When I click connect it gives me this. Error: 1045 SQLSTATE: 28000 (ER_ACCESS_DENIED_ERROR) Message: Access denied for user 'root'@'localhost' (using password: Yes) How do I get past this? Thanks for the help. Oh Im using version 5.0.37-win32 Quote Link to comment Share on other sites More sharing options...
btherl Posted March 19, 2007 Share Posted March 19, 2007 Can you post your code (with the password removed of course) The error means that it didn't recognize your username and password. It may be because they are incorrect, or it may be because they weren't passed correctly. There's other possibilities too, so first I want to see that your code is passing them to mysql correctly Quote Link to comment Share on other sites More sharing options...
porta Posted March 19, 2007 Author Share Posted March 19, 2007 Can you post your code (with the password removed of course) The error means that it didn't recognize your username and password. It may be because they are incorrect, or it may be because they weren't passed correctly. There's other possibilities too, so first I want to see that your code is passing them to mysql correctly Sorry Im an >extreme< noobie at this, what do you mean by code? =/ Quote Link to comment Share on other sites More sharing options...
cmgmyr Posted March 19, 2007 Share Posted March 19, 2007 how are you trying to connect? through the command line, or php? Quote Link to comment Share on other sites More sharing options...
btherl Posted March 19, 2007 Share Posted March 19, 2007 Sorry, I didn't read carefully. Which program are you using to connect to mysql? Quote Link to comment Share on other sites More sharing options...
porta Posted March 19, 2007 Author Share Posted March 19, 2007 Im setting up a World of Warcraft server to host on my computer. I am using Mangos, Mysql and SQLyog. Here is a screen shot of whats happening if this helps. http://i61.photobucket.com/albums/h49/Porta1992/Untitled.jpg Quote Link to comment Share on other sites More sharing options...
btherl Posted March 19, 2007 Share Posted March 19, 2007 Thanks, it does help I'm not familiar with the software you're using (apart from mysql), but I think the most likely problem is that the username or password is not what mysql is expecting. How did you set the root password initially? Quote Link to comment Share on other sites More sharing options...
cmgmyr Posted March 19, 2007 Share Posted March 19, 2007 you might have to verify that your password is still the same now as when you first installed mysql, you might need to reset it. Quote Link to comment Share on other sites More sharing options...
porta Posted March 19, 2007 Author Share Posted March 19, 2007 This is what happened. I originally downloaded MySQl and I set something up. And I followed a link onto a "personal" website of my server. It had a list of stuff where I can edit and all that. Then I edited something about a password, from no password to yes password, never had a chance to type anything in and if i did type anything it was my dogs name, as its my password for everything. WHen I set that it kicked me off and forever tells me access denied for error 1045 =/ Quote Link to comment Share on other sites More sharing options...
porta Posted March 19, 2007 Author Share Posted March 19, 2007 I never set anything up so if theres a master reset command I can easily use that, since I never did anything. Quote Link to comment Share on other sites More sharing options...
cmgmyr Posted March 19, 2007 Share Posted March 19, 2007 you can just try re-installing mysql, when you install it I think there is a "modify" or "repair" option...just do one of those and see if it works. Quote Link to comment Share on other sites More sharing options...
porta Posted March 19, 2007 Author Share Posted March 19, 2007 I tried reinstalling 3 times, that does nothing. Quote Link to comment Share on other sites More sharing options...
porta Posted March 19, 2007 Author Share Posted March 19, 2007 Any Idea? Quote Link to comment Share on other sites More sharing options...
fenway Posted March 20, 2007 Share Posted March 20, 2007 You'll have to skip the grants tables and add a new password. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.