MariaDB Setup on Ubuntu 18.04

sudo apt update
sudo apt -y install mariadb-server

sudo systemctl status mariadb

● mariadb.service - MariaDB 10.1.44 database server
   Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
   Active: active (running) since Mon 2020-08-24 12:16:29 UTC; 14s ago
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/
 Main PID: 6166 (mysqld)
   Status: "Taking your SQL requests now..."
    Tasks: 27 (limit: 4915)
   CGroup: /system.slice/mariadb.service
           └─6166 /usr/sbin/mysqld

Aug 24 12:16:29 vps-fa3cdb32 /etc/mysql/debian-start[6202]: Processing databases
Aug 24 12:16:29 vps-fa3cdb32 /etc/mysql/debian-start[6202]: information_schema
Aug 24 12:16:29 vps-fa3cdb32 /etc/mysql/debian-start[6202]: mysql
Aug 24 12:16:29 vps-fa3cdb32 /etc/mysql/debian-start[6202]: performance_schema
Aug 24 12:16:29 vps-fa3cdb32 /etc/mysql/debian-start[6202]: Phase 6/7: Checking and upgrading tables
Aug 24 12:16:29 vps-fa3cdb32 /etc/mysql/debian-start[6202]: Processing databases
Aug 24 12:16:29 vps-fa3cdb32 /etc/mysql/debian-start[6202]: information_schema
Aug 24 12:16:29 vps-fa3cdb32 /etc/mysql/debian-start[6202]: performance_schema
Aug 24 12:16:29 vps-fa3cdb32 /etc/mysql/debian-start[6202]: Phase 7/7: Running 'FLUSH PRIVILEGES'
Aug 24 12:16:29 vps-fa3cdb32 /etc/mysql/debian-start[6202]: OK

Security

mysql_secure_installation

You can run secure installation even long time after setup. This is a tool for changing security of your MariaDB Server.

Enter current password for root (enter for none): Enter if you’ve setup password before. If new setup, probably it’s empty. Just hit enter.

Set root password? [Y/n] It’s up to you. My suggestion is create user for different databases and menage their privileges one-by-one. Giving all privileges to users is kinda risky.

Remove anonymous users? [Y/n] Yes

Disallow root login remotely? [Y/n] Up to you again.

Remove test database and access to it? [Y/n] Yes

Remove test database and access to it? [Y/n] Yes

· ubuntu, mariadb, database