MySQL Create User Grant Rights

User creation in MySQL is a simple process. when a "user" is created in MySQL a record gets entered in the DB "mysql" under table "user". To create a user you need to have the user creation rights or the super user rights. When MySQL is initially installed, root account is created in the database by default with no password to that account. As the root account has all the privileges in the MySQL server, it is advisable to create separate user account(s) for each database.