Home

Welcome to the Database wiki!

Initialization (will be moved)

Step 1 - Installing MariaDB

Install the package:

sudo apt install mariadb-server

Step 2 - Configuring MariaDB

Ensure that MariaDB is running with the systemctl start command.

sudo mysql_secure_installation

No need to set root password, then I recommend choosing yes to all the following options.

Step 3 - Creating an Admin user

sudo mariadb
GRANT ALL ON *.* TO 'admin'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;
FLUSH PRIVILEGES;
exit

Useful MariaDB commands

Login

Login with the following command:

mysql -u admin -p

From a remote location:

mysql -u admin -p -h ip_adress

Create a new database