----- Original Message ----- From: "Mark" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, June 04, 2002 6:19 PM Subject: Re: grant ALL on *.* to ... Error
> ----- Original Message ----- > From: "vlady" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, June 04, 2002 4:14 PM > Subject: grant ALL on *.* to ... Error > > > > Hi all, > > I have a strange problem, > > I am startirng my mysql-4.0.1 with option --skip-grant-tables. > > I am using "mysql" and when I try : > > grant ALL on *.* to admin@localhost identified by "passwd" > > Well, if you want to GRANT stuff, it might help to actually start > WITH grant-tables. :) I worded this a bit awkwardly; what I meant was, that, prior to granting new privileges, you bring mysql into a state WITH grant-tables again by forcing it to reload the grant tables. You can do that by executing "FLUSH PRIVILEGES" first. - Mark --------------------------------------------------------------------- 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