Here are some results from what I have tried in a addition to my
previous post.
mysql> GRANT ALL ON *.* TO root@localhost IDENTIFIED BY 'pasword';
ERROR 1045: Access denied for user: 'root@localhost' (Using password:
YES)
mysql> show GRANTS for root@localhost;
+--
I was revoking a users access when I accidentally ran the following:
REVOKE all on *.* from root@localhost;
Now I can't seem to get it to work in reverse and grant permission back.
I have reset the server and done the following:
afe_mysqld --skip-grant-tables
mysqladmin -h localhost flush-pr