Re: Locked out of my own database...

2002-09-06 Thread Gurhan Ozen
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

Re: Locked out of my own database...

2002-09-06 Thread Gerald Clark
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

Locked out of my own database...

2002-09-06 Thread Adam Cripps
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