Explanation:1) CREATE DATABASE ; Create database.2) GRANT ALL PRIVILEGES ON DATABASE_NAME.* TO ''@'host' IDENTIFIED BY 'password'; We haven't created user but granting permission to the user. This will create a user with name {USER_NAME} in the "user" table of "mysql" database.3) use mysql; Login to mysql table to update the table level permission.4) update user set select_priv = 'Y',update_priv = 'Y',create_priv = 'Y', delete_priv = 'Y' where user = 'USER_NAME'; This will update the basic manipulation permission to the user.