Miretsky,
Wednesday, May 22, 2002, 8:41:57 PM, you wrote:
M> I tried to create a password for the root user in a new installation of
M> MySQL by typing
M> % mysql -u root mysql
M> Then typing and update statement like
M> Update user set password = "somepassword" where user="root";
You must use
yes, you needed to use the PASSWORD( ) function
mysqladmin -h hostname -u user password 'new password'
-Ryan Hatch
"Miretsky, Anya" wrote:
> I tried to create a password for the root user in a new installation of
> MySQL by typing
> % mysql -u root mysql
> Then typing and update statement li