Reset MySQL root password on Ubuntu & Linux Server
- Stop the MySQL Server:
sudo /etc/init.d/mysql stop
- Start the mysqld configuration:
sudo mysqld --skip-grant-tables &
- Login to MySQL as root:
mysql -u root mysql
UPDATE mysql.user SET Password = PASSWORD('NEW PASSWORD') WHERE User = 'root'; FLUSH PRIVILEGES; exit;