MySQL Password Useless

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Travis
Forum Newbie
Posts: 3
Joined: Sat Oct 04, 2003 8:57 pm

MySQL Password Useless

Post 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?
User avatar
launchcode
Forum Contributor
Posts: 401
Joined: Tue May 11, 2004 7:32 pm
Location: UK
Contact:

Post 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.
magicrobotmonkey
Forum Regular
Posts: 888
Joined: Sun Mar 21, 2004 1:09 pm
Location: Cambridge, MA

Post by magicrobotmonkey »

make sure you use PASSWORD(password) when you set it. Also make sure you restart mySQL each time
Post Reply