GRANT Privilege Go Bye Bye

2003-01-10 Thread Kevin Wixson 
Ummm...what exactly do you do if you end up with a situation where no user 
has GRANT permission? Like, perhaps while experimenting with user 
administration in MySQL, the GRANT privilege was removed from every user?



Thank you,

Kevin Wixson
IT Manager
Norman Camera  Video

(616) 567-5552
1-800-900-6676
Fax: (616) 343-6410
e-mail: [EMAIL PROTECTED]

Visit us on the web at: http://www.normancamera.com  



-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: GRANT Privilege Go Bye Bye

2003-01-10 Thread Paul DuBois 
At 14:35 -0500 1/10/03, Kevin Wixson wrote:

Ummm...what exactly do you do if you end up with a situation where 
no user has GRANT permission? Like, perhaps while experimenting with 
user administration in MySQL, the GRANT privilege was removed from 
every user?

Naturally, you're just speaking hypothetically, right? :-)

Connect as root and modify the mysql tables directly with UPDATE.
For example.





Thank you,

Kevin Wixson
IT Manager
Norman Camera  Video

(616) 567-5552
1-800-900-6676
Fax: (616) 343-6410
e-mail: [EMAIL PROTECTED]

Visit us on the web at: http://www.normancamera.com


sql, query

-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php