Steps to install MariaDB 10.4 on Ubuntu 18.04 system

Source: Internet
Author: User
Keywords ubuntu 18.04 install mariadb 10.4 database tools sql
The following describes the installation of MariaDB 10.4 on Ubuntu 18.04 system, and also applies to Ubuntu 16.04 system. We can install MariaDB 10.4 on Ubuntu from the APT repository. MariaDB is a direct replacement for MySQL with more features, a new storage engine and better performance. At the time of this writing, MariaDB 10.4 is available in Beta. If you want to use the official version, use MariaDB 10.3.
Related Links

MariaDB website
Download MariaDB

Specific steps to install MariaDB 10.4 on Ubuntu 18.04

To install MariaDB on Ubuntu 18.04, you need to add the MariaDB repository to your system.

Step1. install software-properties-common. If it is missing, install it:

sudo apt-get install software-properties-common

Step2.  import the MariaDB gpg key:

Run the following command to add the Repository Key to the system:

sudo apt-key adv --recv-keys --keyserver hkp: //keyserver.ubuntu.com: 80 0xF1656F24C74CD1D8

Step 3.Add apt repository

After importing the PGP key, continue to add the repository URL:

sudo add-apt-repository "deb [arch = amd64, arm64, ppc64el] http://mariadb.mirror.liquidtelecom.com/repo/10.4/ubuntu $ (lsb_release -cs) main"

If there is no add-apt-repository in your system, please install it. Refer to the method of installing add-apt-repository on Ubuntu 18.04 / 16.04 / Debian 9.

Step 4.Install MariaDB Server on Ubuntu 18.04

1. The last step is to install MariaDB Server:

sudo apt update

sudo apt -y install mariadb-server mariadb-client

2. The system will prompt for the MariaDB root password. Enter the password to be set:

img

3. Confirm the password:

img

Press <OK> to confirm the new password and install MariaDB, make sure to remember or retain the password provided on the password manager.

4. The service should be started automatically after installation:

$ sudo systemctl status mysql

* mariadb.service-MariaDB 10.4.1 database server

Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)

Drop-In: /etc/systemd/system/mariadb.service.d

`-Migrated-from-my.cnf-settings.conf

Active: active (running) since Tue 2018-12-25 08:26:18 PST; 24min ago

Docs: man: mysqld (8)

https://mariadb.com/kb/en/library/systemd/

Main PID: 7564 (mysqld)

Status: "Taking your SQL requests now ..."

Tasks: 32 (limit: 1110)

CGroup: /system.slice/mariadb.service

`-7564 / usr / sbin / mysqld

Dec 25 08:26:23 ubuntu-01 / etc / mysql / debian-start [7604]: Running 'mysqlcheck' with connection arguments: --port = '3306' --socket = '/ var / run / mysqld / mysqld

Dec 25 08:26:23 ubuntu-01 / etc / mysql / debian-start [7604]: # Connecting to localhost ...

Dec 25 08:26:23 ubuntu-01 / etc / mysql / debian-start [7604]: # Disconnecting from localhost ...

Dec 25 08:26:23 ubuntu-01 / etc / mysql / debian-start [7604]: Processing databases

Dec 25 08:26:23 ubuntu-01 / etc / mysql / debian-start [7604]: information_schema

Dec 25 08:26:23 ubuntu-01 / etc / mysql / debian-start [7604]: performance_schema

Dec 25 08:26:23 ubuntu-01 / etc / mysql / debian-start [7604]: Phase 7/7: Running 'FLUSH PRIVILEGES'

Dec 25 08:26:23 ubuntu-01 / etc / mysql / debian-start [7604]: OK

Dec 25 08:26:23 ubuntu-01 / etc / mysql / debian-start [7706]: Checking for insecure root accounts.

Dec 25 08:26:23 ubuntu-01 / etc / mysql / debian-start [7710]: Triggering myisam-recover for all MyISAM tables and aria-recover for all Aria tables

5. Test login to MariaDB shell using mysql command:

$ mysql -u root -p

Enter password:

Welcome to the MariaDB monitor. Commands end with; or \ g.

Your MariaDB connection id is 47

Server version: 10.4.1-MariaDB-1: 10.4.1 + maria ~ bionic-log mariadb.org binary distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\ h' for help. Type '\ c' to clear the current input statement.

MariaDB [(none)]>

6. Use the following command to check the version:

img

The resulting version number is MariaDB-1: 10.4.1. At this point, you can use MariaDB 10.4 on Ubuntu 18.04.
Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.