Re: Locked out

2001-12-17 Thread David VanHorn
At 08:06 PM 12/17/01 +, Kevin Donnelly wrote: >On Monday 17 December 2001 15:04, David VanHorn wrote: > > I killed all Mysql processes, and confirmed that they are killed (ps -ef | > > grep mysql) > > Then I restart with safe_mysqld --skip-grant-tables > > Tryin

Re: Locked out

2001-12-17 Thread David VanHorn
At 09:20 AM 12/17/01 +, Carl Troein wrote: >David VanHorn writes: > > > At 08:58 PM 12/16/01 -0700, Doug Thompson wrote: > > >This should help: > > > > > >A.4.2 How to Reset a Forgotten Password > > >http://www.mysql.com/doc/R/e/Resetting_per

Re: Locked out

2001-12-16 Thread David VanHorn
At 08:58 PM 12/16/01 -0700, Doug Thompson wrote: >This should help: > >A.4.2 How to Reset a Forgotten Password >http://www.mysql.com/doc/R/e/Resetting_permissions.html Works ok up through step 2. mysql -h localhost mysql gives me error 1045 again. Can't get in with mysqladmin either. -- Dave'

Locked out

2001-12-16 Thread David VanHorn
I'm root on a small server. My co-sysop has managed to lock us out of mysql. I can't get in with -u root and the root password, or anything else I can think of. Error 1045: Access denied for user" 'root@localhost' So how do I slip a key under the door, without nuking the databases? -- Dave's E