Mysql Database and user creation

Database creation,

• create database dbname;

User creation,

• CREATE USER 'username'@'%' IDENTIFIED BY 'user@123';

Database Permission,

• GRANT ALL PRIVILEGES ON dbname. * TO 'username'@'%';

Object Rights: SELECT, INSERT, UPDATE, DELETE , EXECUTE

DDL Rights: Create, Alter, References, Index, Create View, Create Routine, Alter Routine, Event,  Drop, Trigger

Other Rights:

 

Grant Options, Create temporary Tables, Lock tables