On Saturday 14 December 2002 23:07, tlr7425 at garnet dot acns dot fsu dot edu
wrote:
> 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
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:
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?
T