I was trying to install something and now i got locked out of mysql... i ran these commands
i was supposed to do
GRANT USAGE ON webdatabase.* TO 'nobody'@'localhost' IDENTIFIED BY PASSWORD 'nopasswd';
i put
GRANT USAGE ON webdatabase.* TO root'@'localhost' IDENTIFIED BY PASSWORD 'mypass';
then realized i did it wrong, so i put the
GRANT USAGE ON webdatabase.* TO 'nobody'@'localhost' IDENTIFIED BY PASSWORD 'nopasswd';
thats all i did
now it wont let me log onto mysql.... gives me access denied.... is there any way i can get back in or do i have to reinstall now? and if i have to reinstall. whats the best way of getting all traces of old mysql out and put new mysql in... please help.. thanks (this is on linux btw mandrake distro)