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;

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