MySQL 5 lost all privileges
am 10.08.2006 23:04:56 von razedk
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 ?
Re: MySQL 5 lost all privileges
am 11.08.2006 00:25:25 von razedk
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 ?