MariaDB, a popular open source database server has recently been updated to the current stable version 10.3.9… This brief tutorial shows students and new users how to always get MariaDB latest versions when they’re released….
For those who don’t know, here’s an overview of MariaDB:
MariaDB Database is an open source database server that is a fork of MySQL and a drop-in replacement… It’s rapidly becoming the default open source database server on Linux systems… replacing MySQL…
If you want to always upgrade to the latest major versions of MariaDB 10.3 – (a major release version), the steps below should be a great place to start….
Below are some of the changes released with this version:
- fix third-party tool packaging on Win
- fix C/C packaging on debian
- remove obsolete checks for -fno-implicit-templates
- Deb: Make libmariadb3 Breaks+Replaces libmariadbclient18 so upgrade pass
- AddressSanitizer: stack-buffer-overflow in base_list::push_back .
- Partially revert “Deb: Update documentation and fix spelling errors”
- Unnecessary explicit lock acquisition during UPDATE or DELETE
- Setting a column NOT NULL fails to return error for NULL values when there is no DEFAULT
- Improvements and adjustments to Travis config
For more about this release, please visit its changelog page…
Step 1: Adding MariaDB repository on Ubuntu
First, make sure software-properties-common package is installed. Just in case it’s not, run the commands below.
sudo apt-get install software-properties-common
Next, run the commands below to import MariaDB repository public key used by the package management system….
sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8
Finally, run the commands below to add MariaDB 10.3 repository to your Ubuntu machine… adding this repository will make sure you always get the latest releases of the 10.3 version as they’re released…
sudo sh -c "echo 'deb https://mirrors.evowise.com/mariadb/repo/10.3/ubuntu '$(lsb_release -cs)' main' > /etc/apt/sources.list.d/MariaDB103.list"
The above commands add MariaDB 10.3 repository to Ubuntu with the latest packages. Remember to change the highlighted version number to the current latest….
If you haven’t upgraded to MariaDB major version 10.3 and you’re still running a previous 10.1 or 10.2 then you should upgrade to 10.3 major release first before upgrading to minor releases…
Step 2: Installing MariaDB latest on Ubuntu
Now that the MariaDB 10.3 repository have been added to Ubuntu, run the guides below to install the current version.
First, run the commands below to update your Ubuntu machines.
sudo apt-get update
Next, run the commands below to install MariaDB server and client.
sudo apt-get install mariadb-server mariadb-client
Doing the installation, you may be prompted to to create and confirm a new password for MariaDB root user.
Please enter and confirm a password. You’ll need this password to manage the database server…
After that, MariaDB will be fully installed on your machine.
To secure MariaDB database server, run the commands below:
When you run the above command, you’ll be prompted to create a root password, remove anonymous users, disable remote root access and delete the test database.
Follow this guide below in answering the questions:
- Enter current password for root (enter for none): Enter current password.
- Change root password? N
- Remove anonymous users? Y
- Disallow root login remotely? Y
- Remove test database and access to it? Y
- Reload privilege tables now? Y
When you’re done, restart MariaDB and you’re done.
To verify MariaDB version, run the command below
mysql -V mysql Ver 15.1 Distrib 10.3.9-MariaDB, for debian-linux-gnu (i686) using readline 5.2
You may also like the post below: