May 16, 2021 MariaDB
All MariaDB downloads are located in the download section of the official MariaDB Foundation website. C lick the link for the desired version and display a download list of multiple operating systems, architectures, and installation file types.
If you are familiar with Linux/Unix systems, simply download the source code to build your installation. T he recommended installation method is to use a distribution package. M ariaDB offers packages for the following Linux /Unix distributions -
The following releases include MariaDB packages in their repositories -
Follow these steps to install in the Ubuntu environment -
Step 1 - Sign in as a root user.
Step 2 - Navigate to the directory that contains the MariaDB package.
Step 3 - Import the GnuPG signature key using the following code -
sudo apt-key adv --recv-keys --keyserver keyserver.ubuntu.com 0xcbcb082a1bb943db
Step 4 - Add MariaDB to the sources.list file. O pen the file and add the following code -
sudo add-apt-repository 'deb http://ftp.osuosl.org/pub/mariadb/repo/5.5/ubuntuprecise main'
Step 5 - Refresh the system below -
sudo apt-get update
Step 6 - Install MariaDB with the following -
sudo apt-get install mariadb-server
Once you find and download the Automatic Installation File (MSI), simply double-click the file to start the installation. T he installation wizard will guide you through each installation step and any necessary settings.
Test the installation by starting from the command prompt. N avigate to the location of the installation, usually in the directory, and then type the following at the prompt:
mysqld.exe --console
If the installation is successful, you will see a startup-related message. I f this does not occur, you may have permission issues. M ake sure your user account has access to the application. G raphics clients can be used for MariaDB management in a Windows environment. I f you find the command line uncomfortable or troublesome, be sure to try them.
Perform a few simple tasks to confirm the functionality and installation of MariaDB.
Use the management utility to get the server state
Use mysqladmin binary to view the server version.
[root@host]# mysqladmin --version
It should show versions, distributions, operating systems, and architectures. I f you don't see this type of output, check your installation for problems.
Use the client to execute simple commands
Open mariaDB's command prompt. T his should connect to MariaDB and allow commands to be executed. E nter a simple command as follows -
mysql> SHOW DATABASES;
After successfully installing MariaDB, set the root password. T he new installation will have a blank password. E nter the following to set a new password -
mysqladmin -u root password "[enter your password here]";
Enter the following to connect to the server with the new credentials -
mysql -u root -p Enter password:*******
If you already have MySQL installed on your Windows system and want to upgrade to MariaDB; D o not uninstall MySQL and install MariaDB. T his will result in a conflict with the existing database. I nstead, you must install MariaDB and then use the upgrade wizard in the Windows installation file.
The options for mySQL my.cnf files should be used with MariaDB. H owever, MariaDB has many features that are not found in MySQL.
Consider the following conflicts in your my.cnf file -
MariaDB defaults to temporary files using the Aria storage engine. I f you have many temporary files, if you do not use the MyISAM table, modify the key buffer size.
If your application is frequently connected/disconnected, change the thread cache size.
If you use more than 100 connections, use a thread pool.
MySQL and MariaDB are essentially the same. H owever, there are enough differences to create an upgrade issue. S ee more key differences in the MariaDB Knowledge Base.