All Articles

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

  1. Start the mysqld config

    sudo mysqld —skip-grant-tables &

  1. Login to the server as root

    mysql -u root mysql

  1. Ser your NEWPASSWORD

    UPDATE user SET Password=PASSWORD(‘NEWPASSWORD’) WHERE

    User=‘root’; FLUSH

    PRIVILEGES; exit;

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

Published 24 Nov 2008

Code. Comics. Crossfit
Tim Broder on Twitter