On 1/1/03 2:31 PM, "Richard Nagle" <[EMAIL PROTECTED]> wrote:
> Well after 3 times installing mysql, finally > got it working (tks to those whom help) > now I need to take care of user and root. > first root. > > mysql> mysql -u root mysql > > just want to confirm this is correct before I push enter. > > mysql> update user set password=password('tko') > where user='root'; > > Then next this, > > mysql> flush privileges; > > So, this should add a password for root, yes? > and flush all other privileges? > > Thanks- > Rick > You have a recent installation of mysql then you can just run SET PASSWORD FOR root@localhost=PASSWORD('tko'); and skip the flush privileges. All explained here: <http://www.mysql.com/doc/en/Default_privileges.html> Best/h --------------------------------------------------------------------- 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