After loging in mysql as root, enter the command:
SET PASSWORD FOR root=password('the_new_password');
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, December 14, 2002 5:07 PM
> To: [EMAIL PROTECTED]
> Subject: Root user password changing
>
>
> how exactly do I change the Root user's password for mysql?
>
> like this? :
>
> mysqladmin -u root -p'newpasswd' ? (without a space
> between -p and
> 'newpasswd' ?)
>
> and, if that is correct, I guess I'd then be presented with a prompt
> for the old passwd, right?
> Then, the new one would take effect?
>
> TR
>
>
> ---------------------------------------------------------------------
> 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
>
>
>
>
---------------------------------------------------------------------
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
