Linux Archive

Linux Archive (http://www.linux-archive.org/)
-   Fedora User (http://www.linux-archive.org/fedora-user/)
-   -   Drat. How do I restore GRANT privileges (http://www.linux-archive.org/fedora-user/112083-drat-how-do-i-restore-grant-privileges.html)

"Daniel B. Thurman" 06-23-2008 06:14 PM

Drat. How do I restore GRANT privileges
 
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

"Daniel B. Thurman" 06-23-2008 06:15 PM

Drat. How do I restore GRANT privileges
 
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

Blake Hudson 06-23-2008 06:19 PM

Drat. How do I restore GRANT privileges
 
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


All times are GMT. The time now is 08:18 AM.

VBulletin, Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO ©2007, Crawlability, Inc.