advanced code snippet search

Posted By

isholgueras on 11/16/10


Tagged

mysql


Versions (?)

Change password to an user in MySQL

 / Published in: SQL
 

Only works if you have the mysql-root password

Expand | Embed | Plain Text 
  1. UPDATE user SET password=PASSWORD('mynewpassword') WHERE user='root';
  2. FLUSH privileges;

Report this snippet  

You need to login to post a comment.