Categories
How To

How to Install MariaDB 10.3 on FreeBSD 12

(: February 2, 2019) How do I install MariaDB 10.3 on FreeBSD 12?, How to Install MariaDB 10.3 Database Server on FreeBSD 12?.  MariaDB 10.3 is a multi-user, multi-threaded SQL database server. It is a community-developed fork of the MySQL relational database management system. MariaDB 10.3 Features: InnoDB is used as the default storage engine instead of XtraDB. […]

Categories
How To

How To Setup MariaDB Galera Cluster on Debian 10 (Buster)

(: August 14, 2019) In today’s guide, I’ll walk you through the steps needed to Setup MariaDB Galera Cluster on Debian 10 (Buster). For guys running serious production workload in MariaDB, high availability of database server necessitates the deployment of Galera cluster. MariaDB Galera Cluster is a synchronous multi-master cluster for MariaDB with support for XtraDB/InnoDB storage […]

Categories
How To

How To Install MariaDB 10.4 on Debian 10 (Buster)

(: July 7, 2019) Welcome to today’s guide on how to install MariaDB 10.4 on Debian 10 (Buster). MariaDB is a drop-in replacement of MySQL with more features, new storage engines, and better performance. You can read more on MariaDB 10.4 features from the official website. MariaDB 10.4 is the current stable release of MariaDB as of […]

Categories
How To

How To Install MariaDB 10.3 on openSUSE 15

(: May 30, 2019) Are you looking for a complete guide on how to install MariaDB 10.3 on openSUSE 15?. MariaDB is a drop-in replacement for MySQL. It is a robust, resilient, scalable and reliable RDBMS with features previously only available in costly proprietary databases. The latest stable release as of this writing is MariaDB […]

Categories
How To

How to Install MariaDB 10.3 on Fedora 30/29/28

(: May 9, 2019) In this guide, we will cover the installation of MariaDB 10.3 on Fedora 30/29/28. MariaDB is a drop-in replacement for MySQL. It is a robust, resilient, scalable and reliable RDBMS with features previously only available in costly proprietary databases. Fedora 30 has MariaDB 10.3 available in its repositories. For Fedora 29/28, […]

Categories
How To

How to Solve “ERROR 1524 (HY000): Plugin ‘unix_socket’ is not loaded ” MySQL error on Debian / Ubuntu

(: April 21, 2019) I recently encountered this error “ERROR 1524 (HY000): Plugin ‘unix_socket’ is not loaded” on my Debian 9 server while trying to authenticate to MariaDB database as a root user. After some googling, I found the workaround for this error is to start MySQL service with mysqld_safe and reset the root password. […]

Categories
How To

How to Install LAMP Stack on Debian 10 Buster

(: March 31, 2019) This guide will explain how to install Apache, MariaDB and PHP ( LAMP Stack) on Debian 10 Buster. LAMP is an acronym for – Linux, Apache, MySQL/MariaDB and PHP. LAMP Stack is not a single package but a set of open-source tools that are used to power web applications and websites. […]

Categories
How To

How to Install MariaDB on Debian 10 Buster

(: March 31, 2019) In this tutorial, I’ll show you how you can install MariaDB 10.3 on Debian 10 (Buster). MariaDB is a relational database management system forked from MySQL. MariaDB is fully open source and is released under the General Public License version 2. There is no additionally repository need for installation of MariaDB […]

Categories
How To

How to convert all MySQL tables from MyISAM into InnoDB Storage engine

(: January 12, 2019) Do you have some tables in your MySQL database still using MyISAM and would like to convert them to use InnoDB Storage engine?. This guide has been written to walk you through the conversion of MyISAM into InnoDB Storage engine. InnoDB has a strong focus on performance, support for transactions and […]

Categories
How To

Install and Configure DBeaver on Ubuntu 18.04 / Ubuntu 16.04 / Debian 9

(: June 25, 2019) In this blog post, I’ll discuss how to install DBeaver Database Tool on Ubuntu 18.04 / Ubuntu 16.04 / Debian 9. DBeaver  CE is a free and open source multi-platform database management tool/SQL client designed for Developers,  SQL programmers, Analysts, and Database administrators. DBeaver supports any database which has JDBC driver – MySQL/MariaDB, […]

Categories
How To

How to Install MariaDB 10.4 on CentOS 7

(: August 12, 2019) This guide has been written to help you install and configure MariaDB 10.4 on CentOS 7. MariaDB is a multi-user, multi-threaded SQL database server. It is a community-developed fork of the MySQL relational database management system built to be fast, robust and with more features. For Ubuntu 18.04 / Ubuntu 16.04, use: How to […]

Categories
How To

How To Install MariaDB 10.4 on Debian 9 / Debian 8

(: August 12, 2019) In this tutorial, I’ll show you how you can install MariaDB 10.4 on Debian 9 Stretch and Debian 8 Jessie. MariaDB is an open source database server released under the General Public License version 2.  It is a community-developed fork of the MySQL relational database management system built to be fast, robust and with […]

Categories
How To

How to Install MariaDB 10.4 on Ubuntu 18.04 / Ubuntu 16.04

How do I install MariaDB 10.4 on Ubuntu 18.04 / Ubuntu 16.04?. Can I install MariaDB 10.4 on Ubuntu 18.04 / Ubuntu 16.04 from APT repository?. MariaDB is a drop-in replacement of MySQL with more features, new storage engines, and better performance. You can read more on MariaDB 10.4 features from the official website. For CentOS 7, […]

Categories
How To

How to find database sizes in MySQL/MariaDB Database Server

(: November 28, 2018) Are you trying to find which databases in your MySQL/MariaDB database server has large tablespace?. People have varying reasons for finding database sizes in MySQL/MariaDB. It could be for data truncation, Archiving, optimizations e.t.c. In this how-to guide, I’ll share with you a query you can use in your MySQL/MariaDB database […]

Categories
How To

How to solve “MySQL server is running with the –secure-file-priv” Error

(: December 1, 2018) When starting the mysqld server, you can specify program options in the options file or on the command line. These options are meant to unlock other MySQL features, change variables or impose restrictions. This is how options are read in MySQL server: mysqld reads options from the [mysqld] and [server] groups mysqld_safe reads options from the [mysqld], [server],[mysqld_safe], and [safe_mysqld] groups […]

Categories
How To

How To Install MariaDB on CentOS 8 / RHEL 8

(: September 24, 2019) This guide has been written to help you install MariaDB on RHEL 8 / CentOS 8. CentOS 8 is distributed with MariaDB 10.3 which is binary-compatible with MySQL. MariaDB 10.3 is a multi-user, multi-threaded SQL database server. You can find all RHEL 8 new features on my previous article Red Hat […]

Categories
How To

Install and Configure phpMyAdmin on Fedora 30/29/28

(: May 2, 2019) In this guide, we will look at how to Install and Configure phpMyAdmin on Fedora 30/29/28. PHPMyAdmin is an open source software tool written in PHP, intended to handle the administration of MySQL over the Web interface. phpMyAdmin has support for a wide range of operations on MySQL, MariaDB, and Drizzle. […]

Categories
How To

How to install LAMP Stack on Fedora 30/29/28

(: May 6, 2019) In this blog post, we will look at how to install and configure a LAMP Stack on Fedora 30/29/28. LAMP Stack is a collection of open-source tools that are used to host web applications. The LAMP stack acronym comprises of: L – Linux host system – Can be VM or physical, or […]

Categories
How To

How to install MariaDB 10.3 on Ubuntu 16.04 (Xenial Xerus) LTS

(: December 26, 2018) This post will guide you through the installation of MariaDB 10.3 on Ubuntu 16.04 LTS whose code name is Xenial. MariaDB is one of the most popular open source, relational database management systems. For Ubuntu 18.04 / Ubuntu 18.04 server, use:  Install MariaDB 10.x on Ubuntu 18.04 and CentOS 7 For Debian 9 […]

Install mycli MySQL client AutoCompletion on Ubuntu 18.04 LTS

(: December 9, 2018) In this guide, we will do the installation and usage of mycli on Ubuntu 18.04. Mycli is a MySQL terminal client written in Python and Python Prompt Toolkit library with AutoCompletion and Syntax Highlighting. It works with MySQL, MariaDB, and Percona database servers. mycli exist to help you write complex queries easily […]