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.

Additional Links

How To Set Mysql Root Password
How To Set Root Password Mysql
How To Change Root Password For Mysql
How To Change Mysql Root Password
How To Change Root Password In Mysql
What Is The Default Root Password For Mysql
How To Change Root Password Mysql

What The Password? Landshark