On Fri, 2 Mar 2001, Gerald L. Clark wrote:
> 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
>
Or alternatively kill mysqld and restart it with option --skip-grant-tables. Read the
manual about it (section 4.16.4 Command-line Options)
regards,
thalis
>
> 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
---------------------------------------------------------------------
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