Added User MySQL Database Server

Added User MySQL Database Server

1. Creating a new database for the application, login as root and execute query:

CREATE DATABASE IF NOT EXISTS scadalts;

2. Creating e new user, loign as root and execute queries:

USE scadalts;
CREATE USER IF NOT EXISTS '<mysql-username>'@'<mysql-host>' IDENTIFIED BY '<mysql-password>';
GRANT ALL ON scadalts.* TO '<mysql-username>'@'<mysql-host>';
FLUSH PRIVILEGES;

3. Example:

USE scadalts;
CREATE USER IF NOT EXISTS 'scadalts_user'@'localhost' IDENTIFIED BY 'scadalts_pass';
GRANT ALL ON scadalts.* TO 'scadalts_user'@'localhost';
FLUSH PRIVILEGES;