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)