Month: February 2026

# create database
CREATE DATABASE `databaseName`;

# create user
CREATE USER 'my_user'@'localhost' IDENTIFIED BY 'your_strong_password';

# grant privileges
GRANT ALL PRIVILEGES ON my_new_database.* TO 'my_user'@'localhost';

FLUSH PRIVILEGES;

# in docker
docker exec -it container_name mariadb -u root -p

# Create the Database
CREATE DATABASE `dbName`;
# Create the User (Using '%' so you can connect from outside the container)
CREATE USER 'userName'@'%' IDENTIFIED BY 'userPassword';

# Grant Permissions
GRANT ALL PRIVILEGES ON `dbName`.* TO 'dbUser'@'%';
# Apply changes
FLUSH PRIVILEGES;

# Exit the prompt
EXIT;