Page 1 of 1

MySQL Password Useless

Posted: Fri May 14, 2004 11:45 pm
by Travis
Hey, first off let me say that this very problem happened to a friend of mine a while ago but he can't remember how he fixed it.

My problem is that if I try to change the password of the root, or create a new user with a password and try to login with that username and password, it says something like access denied blah blah blah. The weird thing is if I put the password as nothing when it asks for it, it lets me in just fine. This is all on my computer not on a regular web server btw. So does anybody have any idea of what's wrong?

Posted: Sat May 15, 2004 5:43 am
by launchcode
Err yeah, you're not resetting the password correctly. Post the mysqladmin command you've been using to try and do it.

Until the password actually changes, you'll always be able to login with nothing, because that's the default.

Posted: Mon May 17, 2004 6:37 am
by magicrobotmonkey
make sure you use PASSWORD(password) when you set it. Also make sure you restart mySQL each time