CREATE DATABASE database CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE USER 'user'@'localhost' IDENTIFIED BY 'password';
GRANT SELECT , INSERT , UPDATE , DELETE , CREATE , DROP , ALTER , INDEX ON database . * TO 'user'@'localhost';
FLUSH PRIVILEGES;
MySQL Check:
mysqlcheck --all-databases --repair