MySQL / MariaDB

INFO

If you use MariaDB, you can use the same commands as MySQL.

Connection

MariaDB

mariadb -u root -p

MySQL

mysql -u root -p

Create a new database

MariaDB

CREATE DATABASE `my_project_database`;
CREATE USER 'my_project_user'@localhost IDENTIFIED BY 'super_secret_password';
GRANT ALL privileges ON my_project_database.* TO 'my_project_user'@localhost;
FLUSH PRIVILEGES;

MySQL

CREATE DATABASE my_project_database;
CREATE USER 'my_project_user'@'localhost' IDENTIFIED WITH mysql_native_password BY 'secret_password';
GRANT ALL ON my_project_database.* TO 'my_project_user'@'localhost';