Database Server Setup

MySQL Root User & Other Users

Mysql Root user is the administrative user.

If you have never assigned a root password for MySQL, the server does not require a password at all for connecting as root. However, this is insecure. 

Reference –

How to Create MySQL Users Accounts and Grant Privileges

https://linuxize.com/post/how-to-create-mysql-user-accounts-and-grant-privileges/#:~:text=A%20user%20account%20in%20MySQL,user_password%20with%20the%20user%20password.