Скачать или смотреть How to Remove and Change MySQL Root Password in Ubuntu

Disclaimer/Disclosure: Some of the content was synthetically produced using various Generative AI (artificial intelligence) tools; so, there may be inaccuracies or misleading information present in the video. Please consider this before relying on the content to make any decisions or take any actions etc. If you still have any concerns, please feel free to write them in a comment. Thank you.
---

Summary: Learn step-by-step instructions on how to remove and change the MySQL root password in Ubuntu, including solutions for forgotten passwords and specific guidelines for Ubuntu 22.04.
---

In the world of database management, securing access to your MySQL server is crucial. However, there are times when you may need to remove or change your MySQL root password. This guide will guide you through these processes, with a special emphasis on Ubuntu systems, and in particular Ubuntu 22.04.

How to Remove MySQL Root Password

Stop the MySQL Service:
To begin with, you need to stop the MySQL service. This can be done using the following command:

[[See Video to Reveal this Text or Code Snippet]]

Start MySQL in Safe Mode:
Start MySQL server temporarily without loading the grant tables. This will allow you to connect to the database server as the root user without requiring a password.

[[See Video to Reveal this Text or Code Snippet]]

Connect to MySQL:
Open a new terminal and connect to the MySQL server as root.

[[See Video to Reveal this Text or Code Snippet]]

Remove the Root Password:
Execute the following SQL commands to remove the root password:

[[See Video to Reveal this Text or Code Snippet]]

Restart MySQL Service:
Stop the safe mode server and restart the MySQL service.

[[See Video to Reveal this Text or Code Snippet]]

How to Change MySQL Root Password if Forgotten

Stop the MySQL Service (if running):

[[See Video to Reveal this Text or Code Snippet]]

Start MySQL in Safe Mode:
Start MySQL without networking and grant table checking.

[[See Video to Reveal this Text or Code Snippet]]

Connect to MySQL:
Connect to MySQL shell as root.

[[See Video to Reveal this Text or Code Snippet]]

Change the Root Password:
Update the root user's password using the SQL command:

[[See Video to Reveal this Text or Code Snippet]]

Restart the MySQL Service:
Stop the safe mode server and restart MySQL.

[[See Video to Reveal this Text or Code Snippet]]

How to Change MySQL Root Password in Ubuntu 22.04

The latest version of Ubuntu offers slight variations in process due to changes in system configurations and service management.

Stop the MySQL Service:

[[See Video to Reveal this Text or Code Snippet]]

Start MySQL in Safe Mode:
Start the MySQL server without grant tables or networking.

[[See Video to Reveal this Text or Code Snippet]]

Connect to MySQL:
As soon as the server is up, connect to MySQL as the root user.

[[See Video to Reveal this Text or Code Snippet]]

Change the Password:
Execute the following commands to update the root password:

[[See Video to Reveal this Text or Code Snippet]]

Restart the Service:
Stop the safe mode server and restart the standard MySQL service.

[[See Video to Reveal this Text or Code Snippet]]

By following these steps, you can efficiently remove or change the MySQL root password, irrespective of the situation or specific version of Ubuntu you are using. Always remember to secure your MySQL instance after making any changes to the root password to protect your data.