Installation
Create the Database
Create the Southactyl database and database user.
Create the database
Open the database shell
For MariaDB:
Terminal
mariadb -u root -p
For MySQL:
Terminal
mysql -u root -p
Create the database and user
SQL
CREATE USER 'southactyl'@'127.0.0.1' IDENTIFIED BY 'change_me_securely';
CREATE DATABASE southactyl;
GRANT ALL PRIVILEGES ON southactyl.* TO 'southactyl'@'127.0.0.1' WITH GRANT OPTION;
FLUSH PRIVILEGES;
EXIT;
Use a real password. change_me_securely is a placeholder, not a challenge to get hacked.
Test the database login
Terminal
mysql -u southactyl -p -h 127.0.0.1 southactyl
Exit after the login succeeds:
SQL
EXIT;
If login fails, fix the database credentials before continuing. Do not keep installing on top of a broken database setup.