[Mysql]Set / Change / Reset the MySQL root password on Ubuntu Linux

摘要:[Mysql]Set / Change / Reset the MySQL root password on Ubuntu Linux


Tested on
- Ubuntu Linux 12.04 and MySQL 5.5.31. (2013-07-19)

Set / change / reset the MySQL root password on Ubuntu Linux. Enter the following lines in your terminal.

  1. Stop the MySQL Server.
    sudo /etc/init.d/mysql stop

  2. Start the mysqld configuration.
    sudo mysqld --skip-grant-tables &

  3. Login to MySQL as root.
    mysql -u root mysql

  4. Replace YOURNEWPASSWORD with your new password!
    UPDATE user SET Password=PASSWORD('YOURNEWPASSWORD') WHERE User='root'; FLUSH PRIVILEGES; exit;