In order to install Convention Master, it needs a MySQL database in which to store its data. We need to create a database on your system, and a MySQL user account to access it. This section of the guide will run you through that process.
If you already have a blank database provisioned on your host/by your hosting company, skip this step and proceed to the next page.
sudo mysql_secure_installation
sudo joe /etc/mysql/mysql.conf.d/convention_master.cnf
[mysqld]
sql-mode="NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
sudo systemctl restart mysql
sudo mysql
CREATE DATABASE convention_master;
GRANT ALL PRIVILEGES ON convention_master.* TO CMUser@localhost IDENTIFIED BY 'yourpasswordgoeshere';
FLUSH PRIVILEGES;
All done! With the database and user created, we can proceed to installing Convention Master.