How to switch from MySQL to MariaDB database on Ubuntu Linux

|

,

|

MariaDB has surpassed MySQL as the preferred database server in the open-source community, largely due to controversial licensing changes by Oracle Corporation which bought MySQL’s previous parent company. This guide provides instructions on how to switch from MySQL to MariaDB on Ubuntu systems. MariaDB, a drop-in replacement for MySQL, ensures applications dependent on MySQL function…

As you may know, the MariaDB database server is rapidly gaining traction and has become the default server on most Linux systems, including Ubuntu. Over the past many years, MySQL Server has been the undisputed king for all Linux distributions. That changed.

When Oracle Corporation purchased the previous parent company of MySQL Server and made controversial licensing changes, the open-source community slowly drifted away from MySQL and towards MariaDB.

Today, the MySQL database server is running far behind and has been dethroned by MariaDB as the default database server in the open-source community.

This post shows students and new users how to switch from MySQL to MariaDB database server in Ubuntu 17.04 | 17.10.

This should probably also work with other versions of Ubuntu.

MariaDB is a drop-in replacement for MySQL. This means it operates and functions like MySQL. If you remove MySQL and install MariaDB, applications that depend on MySQL won’t know the difference after installing MariaDB.

To apply the tutorial, you must already have MySQL installed on Ubuntu.

Uninstalling MySQL Database Server

To get rid of MySQL from Ubuntu, run the commands below.

sudo systemctl stop mysql.service
sudo apt-get remove mysql-server mysql-common libmysqlclient18

After running the above commands, continue below to install the MariaDB database server.

Installing MariaDB Database Server

Once MySQL is removed from Ubuntu, run the commands below to install MariaDB.

sudo apt-get install mariadb-server mariadb-client libmariadbclient18

The commands above should install the stable version of the MariaDB database server from Ubuntu repositories.

During the installation, you may get the message below that the old data directory location will be saved at the new location.

Accept and continue.

┌────────────────────┤ Configuring mariadb-server-10.1 ├──────
│ The old data directory will be saved at new location
│ A file named /var/lib/mysql/debian-*.flag exists on this system. The
│ number indicates a database binary format version that cannot
│ automatically be upgraded (or downgraded).
│ Therefore the previous data directory will be renamed to
│ /var/lib/mysql-* and a new data directory will be initialized at
│ /var/lib/mysql.
│ Please manually export/import your data (e.g. with mysqldump) if needed.
│                                  <Ok>
│
└────────────────────────────────────────────────────────

However, if you need to install the latest versions of MariaDB, run the commands below to add the MariaDB repository key to Ubuntu.

sudo apt-get install software-properties-common
sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8

Then, run the commands below to add the MariaDB version 10.1 branch or repository to Ubuntu.

sudo sh -c "echo 'deb [arch=amd64,i386] https://mirrors.evowise.com/mariadb/repo/10.1/ubuntu '$(lsb_release -cs)' main' > /etc/apt/sources.list.d/MariaDB-10.1.list"

Finally, run the commands below to install MariaDB from the 10.1 branches.

sudo apt-get update
sudo apt-get install mariadb-server mariadb-client

Add the repository below to install the latest unreleased 10.2 version.

sudo sh -c "echo 'deb [arch=amd64,i386] https://mirrors.evowise.com/mariadb/repo/10.2/ubuntu '$(lsb_release -cs)' main' > /etc/apt/sources.list.d/MariaDB-10.2.list"

Then, run the commands below to update to the latest 10.2 version.

sudo apt-get update
sudo apt-get install mariadb-server mariadb-client

After installation, the commands below can stop, start, and enable the MariaDB service to start up when the server boots.

sudo systemctl stop mariadb.service
sudo systemctl start mariadb.service
sudo systemctl enable mariadb.service

After that, run the commands below to secure the MariaDB server.

sudo mysql_secure_installation

When prompted, answer the questions below by following the guide.

  • Enter current password for root (enter for none): Just press the Enter
  • Set root password? [Y/n]: Y
  • New password: Enter password
  • Re-enter new password: Repeat password
  • Remove anonymous users? [Y/n]: Y
  • Disallow root login remotely? [Y/n]: Y
  • Remove test database and access to it? [Y/n]:  Y
  • Reload privilege tables now? [Y/n]:  Y

That’s it!

Now you can log in to MySQL by typing the commands below:

sudo mysql -u root -p

Summary:

Again, this post shows you how to convert from MySQL to a MariaDB database server. Since almost all Linux distributions are now switching from MySQL to MariaDB, it’s probably the best thing to change for better system support.

If running MySQL on your server, follow the steps above to switch to MariaDB.

You may also like the post below:

Like this:



Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.