Home » Data Solutions Network » How Set Mysql Root Password in Linux?

How Set Mysql Root Password in Linux?

Sophia Al-Mansoor • • 4 min read
How Set Mysql Root Password in Linux?
Contents

How set MySQL root password?

Use the following procedure to set a root password. To change the root password, type the following at the MySQL/MariaDB command prompt: ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘MyN3wP4ssw0rd’; flush privileges; exit; Store the new password in a secure location.

What is my MySQL root password Linux?

Recover your MySQL password

  1. Stop the MySQL server process with the command sudo service mysql stop.
  2. Start the MySQL server with the command sudo mysqld_safe –skip-grant-tables –skip-networking &
  3. Connect to the MySQL server as the root user with the command mysql -u root.
Sophia Al-Mansoor
Author

Sophia Al-Mansoor

Sophia analyzes international trade, startup ecosystems, retail transformation, and supply chain logistics for modern digital publications.