Solved: Urgent Mysql problem

[Steven L. Brendtro]

The problem has been solved...

I ran across an older copy of the database and copied specifically the files
for the db called "mysql", containing the user and grant priviedges,
restarted mysql and logged in fine.  I just had to add a few mysql users.  I
have since made a few backup copies of the databases, as they contain pretty
volitile info.

Thanks again guys,
Steve Brendtro

-----Original Message-----
From: Jim Herrmann [mailto:b3d at kc.rr.com]
Sent: Thursday, August 23, 2001 11:03 PM
To: Steven L. Brendtro
Subject: Re: Urgent Mysql problem

Did you delete all the users from MySQL?  Unix access and MySQL access
are, of course, two different things.  Thus what you did in the shell
shouldn't really matter.  You could try using the root accout to look at
the user table file and edit it directly.  Not a good idea, but could be
a last resort.  Is this a data base with useful information?  Can you
simply reinstall?  That's really the last option.  I'll keep searching
my book, and if I find anything, I'll let you know.

Steven L. Brendtro wrote:

> I was just maintaining my database, changed an access priviledge for a
> specific user through MyPHPAdmin and then flushed the privileges from the
> shell client for Mysql.
>
> I tried reloading my web application and it couldn't connect to MySQL.  I
> did some checking and found that I couldn't even log in anymore....
>
> Out of 10 accounts, none allows me to log in, though I can see mysql
> processes running.  I restarted the server but that didnt help either.
>
> I tried restarting with --skip-grant-tables and logging in as root... that
> was fine, but then I couldn't access any tables (ie the User table was not
> there).
>
> I am lost here... How do I get back into the database to reset things if I
> am completely locked out?
>
> Any suggestions are greatly appreciated!
>
> Steve B.
>
>
>
>
>