Home CentOS CentOS 7 Installing MariaDB 5.5 on CentOS 7

Installing MariaDB 5.5 on CentOS 7

MariaDB frees companies from the costs, constraints and complexity of proprietary databases, enabling them to reinvest in what matters most – developing innovative, customer-facing applications rapidly. Trusted by organizations like Deutsche Bank, DBS Bank, Nasdaq, Red Hat, ServiceNow, Verizon and Walgreens – MariaDB meets the same core requirements as proprietary databases, but at a fraction of the cost.

How to Install

yum install mariadb-server -y

Start Mariadb Service

systemctl start mariadb.service

Check MariaDB Status

systemctl status mariadb.service

Configure MariaDB Service

mysql_secure_installation

Enter current password for root (enter for none): Press Enter

Set root password? [Y/n] y

New password:
Re-enter new 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

Allow MariaDB to automatically take username and password from a file. Create configuration file as below

vi /root/.my.cnf

Add

[client]
user=root
password=Your-Mysql-Password

Now type mysql in shell to see if everything is working fine.

You have no successfully completed installation of MariaDB version 5.5. In next article I will show how to upgrade it.

Must Read

Routing Domain Name in Haproxy

I hope you are following the below guide. Now suppose you want to route domain name to open specific backend that have...

Enable Logging in Haproxy

HAProxy can emit log message for processing by a syslog server. This is compatible with familiar syslog tools like Rsyslog, as well...

Getting real IP in Nginx when behind cloudflare Haproxy

Create a file named cloudflare_ips.ls and in that add all the cloudflare IP's vi /etc/haproxy/cloudflare_ips.ls 173.245.48.0/20 103.21.244.0/22 103.22.200.0/22 103.31.4.0/22 141.101.64.0/18 108.162.192.0/18 190.93.240.0/20 188.114.96.0/20 197.234.240.0/22 198.41.128.0/17 162.158.0.0/15 104.16.0.0/12 172.64.0.0/13 131.0.72.0/22 2400:cb00::/32 2606:4700::/32 2803:f800::/32 2405:b500::/32 2405:8100::/32 2a06:98c0::/29 2c0f:f248::/32

Getting Real IP in HaproxyNginx configuration

Well its a little configuration can get real to nginx when haproxy is set as reverse proxy. Follow this...

Haproxy as Single Point to Failure Node With Glusterfs and MariaDB Maxscale Cluster

HAProxy is a free, very fast and reliable solution offering high availability, load balancing, and proxying for TCP and HTTP-based applications. It...