RE: password assign for localhost

You must, after updating the user table, FLUSH PRIVILEGES And you should also set the password using the PASSWORD-command. update mysql.user set password = PASSWORD('abc') where user = 'root' and then FLUSH PRIVILEGES /d -Original Message- From: Alice

Re: password assign for localhost

3:36 PM Subject: RE: password assign for localhost You must, after updating the user table, FLUSH PRIVILEGES And you should also set the password using the PASSWORD-command. update mysql.user set password = PASSWORD('abc') where user = 'root' and then FLUSH PRIVILEGES /d