Posted By

Aminreza on 08/07/13


Tagged

mysql server


Versions (?)

MySQL_reset_root_pass


 / Published in: MySQL
 

URL: http://ubuntu.flowconsult.at/en/mysql-set-change-reset-root-password/

Reset MySQL root password

  1. service mysql stop
  2. /usr/BIN/mysqld_safe --skip-grant-tables &
  3. mysql --user=root mysql
  4. UPDATE user SET Password=PASSWORD('new-password-here') WHERE User='root';
  5. flush PRIVILEGES;
  6. exit
  7. fg
  8. Control + C
  9. service mysql start

Report this snippet  

You need to login to post a comment.