I screwed up! I was cleaning up my privileges via MySQL administrator
and realized I locked myself out.

So, how can I restore my 'root' privileges?

I tried: GRANT ALL ON *.* TO 'root'@'%';
but that was refused.

Thanks!
Dan

--
fedora-list mailing list
fedora-list@redhat.com
To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list

I screwed up! I was cleaning up my privileges
via MySQL administrator and realized I locked
myself out!

So, how can I restore my 'root' privileges?

I tried: GRANT ALL ON *.* TO 'root'@'%';
but that was refused.

Thanks!
Dan


--
fedora-list mailing list
fedora-list@redhat.com
To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list

Should be close enough for you to figure out the rest...

http://www.tech-faq.com/reset-mysql-password.shtml

--Blake

-------- Original Message --------
Subject: Drat. How do I restore GRANT privileges
From: Daniel B. Thurman <dant@cdkkt.com>
To: For users of Fedora-List <fedora-list@redhat.com>
Date: Monday, June 23, 2008 1:15:55 PM


I screwed up! I was cleaning up my privileges
via MySQL administrator and realized I locked
myself out!

So, how can I restore my 'root' privileges?

I tried: GRANT ALL ON *.* TO 'root'@'%';
but that was refused.

Thanks!
Dan




--
fedora-list mailing list
fedora-list@redhat.com
To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list