MySQL 5 lost all privileges

After creating a new user and executing "mysqladmin flush-privileges" I
have lost all my privileges, I cant connect as root or any other user.

Any idea why ?

What can I do to restore or recreate my privileges ?
razedk [ Do, 10 August 2006 23:04 ] [ ID #1425187 ]

Re: MySQL 5 lost all privileges

razedk skrev:

> After creating a new user and executing "mysqladmin flush-privileges" I
> have lost all my privileges, I cant connect as root or any other user.
>
> Any idea why ?
>
> What can I do to restore or recreate my privileges ?

Problem solved using this link
http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions .html.

I still don't know why all my privileges got lost, could it be a bug ?
razedk [ Fr, 11 August 2006 00:25 ] [ ID #1425188 ]
Datenbanken » mailing.database.mysql » MySQL 5 lost all privileges

Vorheriges Thema: Table with searchable string fields
Nächstes Thema: My web hosting company lost my data from mysql database