The manual tells you how to reset a forgotten password.
It also tells you not to mess with these tables, but to use.
GRANT and REVOKE. We all have to explore everything,
dont't we?
Worst case, kill mysqld and reinstall privilege tables with
mysql_install_db --user=mysql
Asaf Maruf Ali wrote:
>
> 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
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
