Quick tip: Create MySQL database, add user and access rights

Quick tip: Create MySQL database, add user and access rights

 
  CREATE DATABASE `mydb` CHARSET utf8 COLLATE utf8_general_ci;
  GRANT USAGE ON *.* TO 'webapp'@'localhost' IDENTIFIED BY 'SecretP@ssw0rd';
  GRANT ALL PRIVILEGES ON `mydb`.* TO 'webapp'@'localhost';
  flush privileges;
  SHOW GRANTS FOR webapp@localhost;