SQL COMMANDS

To create a database

=Run the SQL/Mariadb Container=

docker exec -it (container_name) mysql -u root -p

= SQL Commands for Database Setup = = Create Database and User ==

CREATE DATABASE database_name;
CREATE USER 'YOUR_USER'@'%' IDENTIFIED BY 'YOUR_PASSWORD';
GRANT ALL PRIVILEGES ON database_name.* TO 'YOUR_USER'@'%';
FLUSH PRIVILEGES;