Sorry if this is old/documented problem. Did not see any info for list
archives.
Problem:
1. had two terminal windows open, two login sessions open as root on
redhat 6.3 running mysqld
2. used one root login session to login to sql server (as root), and
changed the root password in the mysql database
3. In other root login session, used "mysqladmin -u -p root reload" and
entered old password to update the User table and make new password
effective. Looked ok, but when I tried to login to msyql again with the
new root password - no dice. Tried old password - no dice. Then I
realized I was still logged into mysql as root in the first login
session -- so that session was alive when I changed the password and
reloaded the grant tables. I have since logged out and no cannot get
back in with the root password.
Did I just FUBAR my grant tables?
