I have been using MySQL for sometime now. However, i had been experimenting with
MySQL priviliges and have locked myself out. I cannot access the database to perform
any function. I cannot issue any command like mysqladmin ping or mysqlshow. Somehow
the command mysqlaccess doesnt execute either.
The message i get trying to access mysql is:
Access denied to user root@localhost using (password=NO)
If i try to connect to the DB using mysql -p and give any password the message is:
Access denied to user root@localhost using (password=YES)
Unfortunately, i didnt note down the changes i made to the host, DB and user tables.
Any help would be really appreciated.
Thanks
Asaf Maruf
PING
