MySQL Add Database and User with Full Permissions

The 4 commands below will create a new database and user with full permissions on MySql:

CREATE DATABASE mautic;
CREATE USER ‘mautic’@’localhost’ IDENTIFIED BY ‘WowThat’sALongOne!’;
GRANT ALL PRIVILEGES ON mautic.* TO ‘mautic’@’localhost’;
FLUSH PRIVILEGES;

Leave a Reply

Your email address will not be published. Required fields are marked *