List:General Discussion« Previous MessageNext Message »
From:Sasha Pachev Date:May 27 1999 4:52pm
Subject:Re: user table deleted
View as plain text  
Scott Mackie wrote:
> 
> Hello,
> I had someone delete the user table from the mysql database and now we
> cannot connect.
> I'm going to try copying a backup of this table to the data directory
> and running mysql reload.
> 
> Does anyone know of a good way to solve this problem?
> Thanks in advance.
> 
> Swampy
> Virtual Service
> 
>

Start mysqld with --skip-grant and it will let you
connect with no authentication. Then re-create the user
table

Alternatively, restore user.* files from the backup.

-- 
Sasha Pachev
http://www.sashanet.com/ (home)
http://www.direct1.com/ (work)
Thread
user table deletedScott Mackie27 May
  • Re: user table deletedSasha Pachev27 May