Re: flush privileges

> what kind of privileges i should have if i want to run > 'flush privileges' ? You need to be the MySQL superuser, this is the user who has permission to grant privileges to other users and set them up as such. You use 'flush privileges' when you want to instruct MySQL to 'refresh' it's 'mysql' table data AFTER you have set up a user. If you have been able to connect to MySQL from the command line or phpMyAdmin and successfully enabled a new user (Without SQL errors) then you should be able to issue 'flush privileges'. I honestly cant remember how I set it all up originally, but you could go try: www.mysql.com/doc/P/r/Privileges.html and see if that helps. Cheers Russ On Wed, 20 Jun 2001 22:38:20 +0700 andRie Is <andrie@ajk.its-sby.edu> wrote: > Hello php-db, > > what kind of privileges i should have if i want to run > 'flush privileges' ? > > ,,, > (@-@) > +==---o00----(_)----00o-----==+ > > "It is better to be defeated on principle than to win on lies." > --Arthur Calwell > -- > Best regards, > andRie > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > #-------------------------------------------------------# "Believe nothing - consider everything" Russ Michell Anglia Polytechnic University Webteam e: r.j.michell@apu.ac.uk w: www.apu.ac.uk/webteam t: +44 (0)1223 363271 x 2331 www.theruss.com #-------------------------------------------------------#