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 the
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 like
Update user set password = somepassword where user=root;
After doing this I typed because I could still get into mysql without a
password
%
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 like
Update user set password = somepassword where user=root;
After doing this I typed because I could still get into mysql without a
password %
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 like