MySQL user management

Trying to change logins

[ggrot]

Alright, I'm now starting to set up my first dedicated server. Fun stuff. I have a basic installation of most files and have configured most things the way I need them.

I'm having one big problem with mySQL though. The default setup had a user 'root', host 'localhost', and a null password set up in the user table. I changed this password to something a little more secure and added 1 more user for the time being, also with a non-null password. Now the user table has 2 users, neither of which have null passwords.

So, I login to the command line mysql with my new non-root user and password prompt. But I get an access denied. Same with root. But, if I login with no password for either of these users, I get right in. Or if I login with no password for any other user (even random strings), I get right in.

Any ideas what is causing this? I thought this was gonna be easy.

[ggrot]

Ok, I answered my own question. The root has to execute flush privileges; after changing the users table.

In my case, an old user w/ null name and null password was still registering w/ mysql.