Restart mysqld with --skip-grant-tables option and reset password and
flush privileges..
See: http://www.mysql.com/doc/en/Resetting_permissions.html
Hope this helps..
Gurhan
On Fri, 2002-09-06 at 10:37, Adam Cripps wrote:
> I'm locked out of mysql database - it seems that all my users can't access
> it, through lack of privileges, even root. This means that I can't get
> through and change the privileges.
>
> How can I start with a fresh users database?
>
> I'm only setting the database up at the moment, so there's no data to lose.
>
>
> I've tried mysqladmin_fix_privileges_tables and I've tried
> mysqladmin_install_db
>
> but nothing seems to work.
>
> Also, the actual mysql database itself has no tables. How can I restore
> that?
>
> Any ideas?
>
> Thanks in advance.
>
>
>
> This message has been checked for all known viruses. For further
> information please e-mail the CfBT IT Help Desk at helpdesk@stripped.
> http://www.cfbt.com
>
> ---------------------------------------------------------------------
> 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 <mysql-thread118949@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-ergenekon=starpower.net@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
