I dropped the mysql database - how do I resolve this?

Question

I went into my site's MySQL database via phpMyAdmin to look at privileges, and received a warning that the structure of the privilege tables seemed older than the version of MySQL that I was using. I hadn't changed / upgraded anything, but whatever (thanks, Yahoo). The warning also referred to a script to fix it, but I could not find that script anywhere.

While trying to figure out how to upgrade the mysql database, I accidentally dropped it - gone. Consequently, I am unable to log into phpMyAdmin or set a Database Administrator, because the target database (mysql) no longer exists. I've looked everywhere for the database as well as instructions for removing or resetting it - I can't find anything. The Database Setup menu still says the database is active, I just can't set an administrator or access it, because the database was actually dropped, and is now gone.

How can I recreate the mysql database so I can get back in there and start repairing the damage?

Answer 1

I've done some research, and I don't think there is anything you can do but start over.  If it was just a file, you could restore it by using SnapShot, but the SnapShot application doesn't not include MySql.

Answer 2

I have never seen a response like you got from JPTURBOPROP.  What did you do to irritate him so?  You should aplogise.  He was just trying to help.   I don't know anything about mysql database, but I am sure someone will help you.