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. Alex the dummy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
