There are many things "short of wiping the hard drive" that you can try.
I just had this happen and was able to find the answer quickly on www.mysql.com IE: http://www.mysql.com/doc/en/Resetting_permissions.html Just read, step back, think, then try something. You shouldn't need to rebuild everything though... this is a good learning experience for you! Dan > Okay, so this question may not indicate I'm smart enough to > administer MySQL > and I should slowly back away from the keyboard, but here goes... > > When using phpMyAdmin, I attempted to duplicate the root account, > which had > access to everything. I accidentally selected the wrong radio > button, which > didn't make a duplicate root account, it just took away all > privileges for > the root user. Now I can't give myself any rights to any database. > > I've tried completely removing and reinstalling from the RPMs, > but I still get > the same errors. I set it to replace all files and packages, but I still > don't have access to anything. I can't even change the root > password because > I don't have the privileges. I even receive the errors when using > the command > 'mysqld --skip-grant-tables -uroot". It complains even worse if I > don't add > the '-uroot'. > > So my question is: short of wiping the partiton and doing a > completely clean > install of EVERYTHING, what can I do to reset the privileges for the root > user? > > I'm running Slackware8.0, the MySQL 3.23.49 RPMs from the > Website, I have full > access to everything (it's my home computer) on a PentiumIII. I > have never > had a problem doing anything with MySQL on this machine, and it > seems to run > fine, I just can't do anything with it. > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
