Reset MySQL root password on Ubuntu & Linux Server

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;