Mega Code Archive

 

Categories / MySQL / User Permission

 

Change password for root with update statement

UPDATE user SET Password = PASSWORD('rootpass') WHERE User = 'root';