MariaDB Cheat-Sheet

Install MariaDB on Ubuntu 20.04 LTS

1
2
3

sudo apt update
sudo apt install mariadb-server
sudo mysql_secure_installation

Access Database from outside

Open /etc/mysql/mariadb.conf.d/50-server.cnf and change the bind-address to:

1

bind-address = 0.0.0.0

Create Administrative User

1. Create a new user newuser for the host localhost with a new password:

1

CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';

2. Grant all permissions to the new user

1

GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';

3. Update permissions

1

FLUSH PRIVILEGES;