How to Set MySQL Root Password in Ubuntu 18.04

Setting a root password for MySQL in Ubuntu 18.04 is essential to secure your database and prevent unauthorized access. Here's how you can do it:

1. Log in to your Ubuntu 18.04 server via SSH.
2. Once logged in, you can access MySQL by typing sudo mysql in the terminal.
3. Next, you need to switch to the MySQL database by typing use mysql;
4. Now, you can set the root password by running the following command: UPDATE user SET authentication_string=PASSWORD('YOUR_NEW_PASSWORD') WHERE User='root';
5. After setting the new password, don't forget to flush privileges by typing: FLUSH PRIVILEGES;
6. Finally, exit MySQL by typing exit.

That's it! Your MySQL root password in Ubuntu 18.04 has been successfully set.