Set / Change / Reset the MySQL root password on Ubuntu Linux (Ubuntu)

This came in veeeerrryyy handy just now...

  1. Stop the MySQL Server

    sudo /etc/init.d/mysql stop

  2. Start the mysqld config

    sudo mysqld --skip-grant-tables &

  3. Login to the server as root

    mysql -u root mysql

  4. Ser your NEWPASSWORD

    UPDATE user SET Password=PASSWORD('NEWPASSWORD') WHERE

    User='root'; FLUSH

    PRIVILEGES; exit;

туры на майские праздники днепропетровсквзять денег в долг срочно