Sounds like something that could appear in Kernel Panic. It's a good trick, deleting all the MySQL accounts. In really old versions of MySQL it was quite difficult to recover from, too.
Wade.
P.S. I work with MySQL for a living, can't ya tell? :-D
Is it enough to love Is it enough to breathe Somebody rip my heart out And leave me here to bleed
Is it enough to die Somebody save my life I'd rather be Anything but Ordinary Please
-- "Anything but Ordinary" by Avril Lavigne.
· my · · [link|http://staticsan.livejournal.com/|blog] · · [link|http://yceran.org/|website] ·
Definitely the easiest way to fix that problem if you have an otherwise empty database is just re-install it. But there is a script installed with MySQL that creates the empty permissions tables so you can recover. I can't find it mentioned in the online docs, that's all.
As for the problem with phpMyAdmin; that's the configuration of phpMyAdmin. It can do security a few different ways. It sounds like you want it to use the MySQL users, which by default I don't think it does. The configuration file has the information to change it.
Wade.
Is it enough to love Is it enough to breathe Somebody rip my heart out And leave me here to bleed
Is it enough to die Somebody save my life I'd rather be Anything but Ordinary Please
-- "Anything but Ordinary" by Avril Lavigne.
· my · · [link|http://staticsan.livejournal.com/|blog] · · [link|http://yceran.org/|website] ·
... I thought when I uninstalled phpmyadmin and then uninstalled mysql it would nuke all my existing databases (so I backed them up first!)
But when I reinstalled both I found that not only were the databases still intact, but all my users were still there as well -- only without the odd permissions problems!
All I had to do was give the root login a password.
"We are all born originals -- why is it so many of us die copies?" - Edward Young
Debconf specifically asks if you want it to remove all data if you remove and purge the config. Unfortunately, it is a question at *INSTALLATION* and not at removal... DUH!
-- [link|mailto:greg@gregfolkert.net|greg], [link|http://www.iwethey.org/ed_curry|REMEMBER ED CURRY!] @ iwethey Freedom is not FREE. Yeah, but 10s of Trillions of US Dollars?