Setting Up MySQL – Database, Users And Sample Table

“Changing root password: As soon as the MySQL server is
installed, root user with blank password is created. The MySQL root
user will have full access to perform any operation on the MySQL
server. It is a good practice to change the root password
immediately after installation.

“It is also worth mentioning that MySQL users are different from
system users. If you try to connect to the MySQL server as root
using your system root password, it will not work. MySQL server
maintains its own users in the ‘user’ table of ‘mysql’
database.”

Complete Story