How to install latest MySQL (MariaDB) on a CentOS 7 server

For CentOS, it is highly recommended to install from a repository using yum.

Start by adding the MariaDB YUM repository file MariaDB.repo

nano /etc/yum.repos.d/MariaDB.repo

An example MariaDB.repo file for CentOS 7 is:

[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.2/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

With the repo file in place you can now install MariaDB like so:

sudo yum install MariaDB-server MariaDB-client

After the installation completes, start MariaDB with:

sudo systemctl start mariadb

Now that our MySQL database is running, we want to run a simple security script that will remove some dangerous defaults and lock down access to our database system a little bit. Start the interactive script by running:

sudo mysql_secure_installation

MariaDB (MySQL) Secure Installation includes:

  • Set (Change) root password
  • Remove anonymous users
  • Disallow root login remotely
  • Remove test database and access to it
  • Reload privilege tables

The last thing you will want to do is enable MariaDB to start on boot. Use the following command to do so:

sudo systemctl enable mariadb

Some other extra commands

To check MySQL version

mysql -V

To check the status of MySQL

sudo systemctl status mariadb

Connect to MySQL database (localhost) with password

mysql -u root -p

 

Leave a reply

Sharing is caring!

Back to Top