On Fri, 22 Aug 2003, Craig Mead wrote:
> So...I'm on a learning curve and was playing with some user permissions for
> mysql yesterday and well, as I tend to do with things, I screwed it. Ended
> up changing the user permissions in the users table and now I can't reaccess
> the user permissions table to fix the permissions....cause I don't have
> permission!
>
> Yet again, probably a stupid move, but I figured I'd just apt remove it and
> reinstall it and we'd be back at square one. HA! 1/2 my luck. Kept the
> tables and such all there. Anyways, I've now got the box in a bit of a mess
> but no matter what I do I can't seem to get rid of the existing tables
> (theres a few user created tables, but I'm only on the learning process so
> it's just crud data and if it goes, so be it). Anyone got any thoughts on
> how to just blast it back to a completely clean install or reset the user
> table or something!
start mysqld up with the --skip-grant-tables option. Taht will turn off
all access restrictions so you can go in and fix the access tables
(erm, that's the mysql database, not access... you know what I mean)
When you're done, kill mysqld and restart it as normal.
It can be a bit of a pain figuring out the command line for mysqld which
is normally handled by safe_mysqld, or whatever your distribution uses
instead. I recommend using 'ps wwaux|grep mysqld' to get the current
command line options and then entering that with the addition of the
--skip-grant-tables option.
Andrew
--
No added Sugar. Not tested on animals. May contain traces of Nuts. If
irritation occurs, discontinue use.
-------------------------------------------------------------------
Andrew McNaughton In Sydney
Working on a Product Recommender System
[EMAIL PROTECTED]
Mobile: +61 422 753 792 http://staff.scoop.co.nz/andrew/cv.doc
--
SLUG - Sydney Linux User's Group - http://slug.org.au/
More Info: http://lists.slug.org.au/listinfo/slug
