MySQL And MariaDB Setup

Install MariaDB on Ubuntu 20.04 LTS

sudo apt updatesudo apt install mariadb-serversudo mysql_secure_installation

Access Database from outside

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

...bind-address = 0.0.0.0...

Create Administrative User

  1. Create a new user newuser for the host localhost with a new password:
CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
  1. Grant all permissions to the new user
GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';
  1. Update permissions
FLUSH PRIVILEGES;