On Fri, 2003-01-10 at 06:21, Cory wrote: > I have a small problem where a power outage has corrupted the user database > for mysql, now no users can authenticate/manipulate any databases hosted by > the MySQL Engine... This is rather annoying since I am no longer able to > administer the databases, and I appear to be unable to modify, or create > users all together. > The engine is running, and the availability of data is still there, but in a > read only manner. I can pull data out, but unless I can authenticate, I cant > enter any in! How can I fix this? Almost all of the admin tools I have found > will not work without logging in. > If there is no other solution, is it possible to import the existing > database I have (used for inventory purposes) into a fresh mysql install? I > cant export anything, and the database files are basically flat files at > this point... A good web resource would also be appreciated! > any help would be appreciated. >
Are you able to access the MySQL adminsitration applet through Webmin? Have you tried running /usr/bin/mysql_fix_privilege_tables ? -- Fri Jan 10 07:55:01 EST 2003 7:55am up 21:37, 5 users, load average: 0.60, 0.48, 0.39 ------------------------------------------------------------------ | __ __ | kuhn media australia | | / ,, /| |'-. | http://kma.0catch.com | | .\__/ || | | |=================================| | _ / `._ \|_|_.-' | stephen kuhn | | | / \__.`=._) (_ | email: [EMAIL PROTECTED] | | |/ ._/ |"""""""""| | email: [EMAIL PROTECTED] | | |'. `\ | | | icq: 5483808 | | ;"""/ / | | | | | smk ) /_/| |.-------.| | mobile: 0410-728-389 | | ' `-`' " " | Berkeley, New South Wales, AU | ------------------------------------------------------------------ * linux user:267497 * RH 7.3+ * PC/Mac/Linux/Networking/Consulting ------------------------------------------------------------------ Nobody can be as agreeable as an uninvited guest.
Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com
