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;
+-----------------------------------------------------------------------
-------------------------------+
| Grants for root@localhost
|
+-----------------------------------------------------------------------
-------------------------------+
| GRANT USAGE ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD
'5555555555' WITH GRANT OPTION |
+-----------------------------------------------------------------------
-------------------------------+
1 row in set (0.00 sec)
mysql>
I can set the USAGE setting but anything else I get access denied, I
have run out of options please help. I am guessing next thing would be
to re-install mysql and rebuild the server? If I copy my tables from my
var directory can I copy them back after and have it work?
