I think you can start safe_mysqld with a switch called
"--skip-grant-tables" or something like that - once mysqld is
started with that, you should be able to log in as root with
NO password - get your stuff straightened out, then stop and
start safe_mysqld without "--skip-grant-tables".
The other option, assuming you have a backup of your tables, is
to re-run mysql_install_db, which will re-create the "mysql"
database. Read up on this *before* doing it - it may reinitialize
the whole mysql data directory(may wipe out all your databases).
HTH.
--
Hardy Merrill
Mission Critical Linux, Inc.
http://www.missioncriticallinux.com
Dexter Coelho [[EMAIL PROTECTED]] wrote:
> Hi Perlsters & dbi-users,
>
>
> Accidentally took out the admin privs , cant get back into mysql permission
> tables.
>
> Tried to use "mysql_fix_privilege_tables" script to fix it.
> Reported "Access denied" . Tried to re-install the package . Cobalt server
> has
> binary that install easily but when it finds previous install , it exits.
>
> There must a file it looks for , a config file that I probably can delete.
>
> Dexter
