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 acce
Try the manual.
It has a section on resetting the root password.
Basically you restart the server with --skip-grant-tables option
Check out chapter 20.11
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. T
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