MySQL User Permission Setup

MySQL User Permission

The below SQL code used to Grant the permission SELECT, INSERT, UPDATE, DELETE and CREATE for the MySQL database user

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE ON database.* TO 'user'@'localhost' IDENTIFIED BY 'password';