How to Create a user & database in MySQL?

Creating User in MySQL:

CREATE USER ‘shaukat’@’%’ IDENTIFIED BY ‘my_Sec_Pass’;

GRANT USAGE ON * . * TO ‘shaukat’@’%’ IDENTIFIED BY ‘my_Sec_Pass’ WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;

Creating Database in MySQL:

CREATE DATABASE IF NOT EXISTS `shaukat` ;

Granting all privileges to created user:

GRANT ALL PRIVILEGES ON `shaukat` . * TO ‘shaukat’@’%’;