OK, did I just destroy my database?

[Coderifous]

A little background info: working on 'localhost' developing a website with Perl/MySQL/Apache. The box isn't on a network or anything so whatever is wrong should be fixable from my keyboard...

In attempting to alter user access, I deleted a couple of lines from my "user" table in the mysql database. I thought they were just stray entries I had entered in my naivety.

Now I can't access the mysql client or interact with the MySQL server at all becuase it says:

ERROR 1130: Host 'localhost' is not allowed to connect to this MySQL server

For the love of god some one tell me how to fix this!!!!!

--Jim

 

[cDevX99]

I am not certain how to un-do it, but the mysql file structure is pretty straight forward, so you could probably copy all the db and table files to another location, reinstall mysql, then copy back the table files, ommiting the user files.

There is probably an easier way to do this, but I don't know what it is

 

[Broccoli2]

An easier means of recovery is to shutdown the MySQL server, then restart with the

--skip-grant-tables

option. This will allow universal access into your database so you'll be able to get back in and fix your

user

table. Then restart the server again.

-Rob