// Stop and start the MySQL service
// (Ubuntu and Debian) Run the following command:
sudo /etc/init.d/mysql stop

// (CentOS, Fedora, and Red Hat Enterprise Linux) Run the following command:
sudo /etc/init.d/mysqld stop

// Start MySQL without a password
sudo mysqld_safe --skip-grant-tables &

// Connect to MySQL
mysql -uroot

// Set a new MySQL root password
use mysql;
update user set password=PASSWORD("MT&E&11L7g2=") where User='root';
flush privileges;
quit

// Stop and start the MySQL service
// (Ubuntu and Debian) Run the following commands:
sudo /etc/init.d/mysql stop

// (CentOS, Fedora, and Red Hat Enterprise Linux) Run the following commands:
sudo /etc/init.d/mysqld stop
sudo /etc/init.d/mysqld start

// Log in to the database
mysql -u root -p