Change the Root Password in MySQL 8.0

When you install MySQL 8.0 in Ubuntu 20.04, the root has enabled the auth_socket plugin by default. This means you can connect only from localhost and use a UNIX user with root privileges. A MySQL root password is required. We are going to set a password for that root user.