Reset MySQL root password on Ubuntu & Linux Server

  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
    UPDATE mysql.user SET Password = PASSWORD('NEW PASSWORD')
    WHERE User = 'root'; FLUSH PRIVILEGES; exit;

 

LEAVE A REPLY

Please enter your comment!
Please enter your name here