This article will help you to Install MariaDB 10.3 on Ubuntu 18.04 LTS via apt package manager. After installing MariaDB you may need to install phpMyAdmin to access database on the web interface.
Step 1 – Prerequsiteis
You can find the MariaDB Apt configuration file from the official website. Import the package singin key for MaraiDB packages on your system. After this, create a new Apt configuration file for MariaDB with the following command. You can use any text editor than vim.
Step 2 – Install MariaDB on Ubuntu 18.04
After adding the repository to your system and use following commands to install MariaDB-server on your Ubuntu system. This will remove any previous version of MariaDB packages and install the latest packages on the system. Make sure you have proper backups of databases before running below commands. This will also install other required dependencies on your system.
While installing MariaDB using above command installer will prompt for MariaDB root account password. Enter a strong password as below.
This will also ask for confirm password. Enter the same as above.
Step 3 – Verify MariaDB Setup
After successful installation of MariaDB on Ubuntu 18.04 system. The installer will also start service during the install process. You can verify service by running below command. MariaDB also creates a reference of service with name mysql. You can change mariadb with mysql as per your choice. You will see running status like:
Then connect to MariaDB shell by running below command. You need to enter password configured in the above step.
Step 4 – Manage MariaDB Service
Sometimes you need to stop or start MariaDB service. Use the following commands to stop, start, check status and restart MariaDB service.
Step 5 – What Next?
You may need to install phpMyAdmin on your system to access the MariaDB database on the web interface. Use below link to install phpMyAdmin. https://tecadmin.net/install-phpmyadmin-in-ubuntu/
