use mysql; update user set authentication_string=password('xxxxxx') where user="root"; flush privileges;