Managed to hose my MySQL install

SouperComputer

Pretty pathetic, I made the mistake of using PHPMyAdmin and removed all privlidges from my root account hehe. I can login of course, but even from the command line I am unable to grant privlidges.....

So how do I fix this? I tried to uninstall and reinstall MySQL, but the issue persists, to I guess there is a config file I need to scratch somewhere?

feylya

http://community.postnuke.com/Article1273.htm

Try that to reset your root account.

SouperComputer

feylya wrote: »

http://community.postnuke.com/Article1273.htm

Try that to reset your root account.

Thanks, tried that, still at square one Are there some config files I can nuke? I should probably clarify, I dont have any databeased setup yet, so nuking is not a problem.

stereo_steve

What are you installing it on?

I had a similar problem about two weeks ago and solved it. I am running ubuntu but it should be the same for anything debian based. Can't remember how i did it though I either did one of two things.

1) sudo apt-get purge mysql-client mysql-server mysql-admin

or

2) tasksel lamp <- should install the AMP for you all configured and ready to go.

I remember one of them worked. Don't remember which..... sorry

SouperComputer

its on clarkconnect\aka CentOS. no joy, even tried upgrading to v5....