MariaDB-Tutorials

Three Methods to Check Uptime of MySQL/MariaDB Database Server on Linux

May 5, 2020May 5, 2020 - by Magesh Maruthamuthu - Leave a Comment

We all know the purpose of the uptime command in Linux. This is used to check the uptime of the Linux system and how long the system runs without restarting. …

MariaDB-Tutorials / MySQL-Tutorials

Mycli – Simple CLI client for MySQL/MariaDB with autocompletion and syntax highlighting

August 10, 2017January 25, 2020 - by 2daygeek - Leave a Comment

MyCLI is a command line interface for MySQL, MariaDB, and Percona with auto-completion and syntax highlighting.This will help us to write queries faster and easy which was written in Python …

MariaDB-Tutorials

How to Upgrade MariaDB 5.5 to MariaDB 10.0 & MariaDB 10.1 on Linux

February 7, 2016July 31, 2017 - by Ramya Nuvvula - Leave a Comment

There are no changes in table or index formats on MariaDB 5.5, MariaDB 10.0 & MariaDB 10.1. So, most of the servers the upgrade should be painless from MariaDB 5.5 …

database / MariaDB-Tutorials

How To Install/Upgrade MariaDB on CentOS, RHEL & Fedora

February 5, 2016July 31, 2017 - by Ramya Nuvvula - 2 Comments.

MariaDB is a drop-in replacement for MySQL. MariaDB is an opensource Relational Database Management System (RDBMS) which supports database access. MariaDB is a logical choice for database professionals looking for …

MariaDB-Tutorials

How To Install/Upgrade MariaDB on Ubuntu, Debian & Mint

September 13, 2014July 31, 2017 - by Magesh Maruthamuthu - 6 Comments.

MariaDB is a drop-in replacement for MySQL. MariaDB is an opensource Relational Database Management System (RDBMS) which supports database access. MariaDB is a logical choice for database professionals looking for …

Arch Linux / CentOS / database / Debian / fedora / Linux / Linux Advanced Commands / Linux Commands / Linux-Distributions / linux-tutorials / MariaDB-Tutorials / MySQL-Tutorials / opensuse / Oracle Linux / Red Hat / Red Hat Enterprise Linux / RHEL / ubuntu

How to Setup/Configure MySQL (Master-Slave) Replication on Linux

June 16, 2014April 14, 2020 - by Magesh Maruthamuthu - Leave a Comment

MySQL master-slave replication is a process that automatically copies data from one MySQL database server (master) to one or more MySQL database servers (slaves). MySQL supports various replication methods, but …

MariaDB-Tutorials / MySQL-Tutorials

How To Connect Remote MySQL/MariaDB Database From Linux Terminal?

June 12, 2014June 12, 2019 - by Magesh Maruthamuthu - 1 Comment

There are many ways that we can connect the remote MySQL/MariaDB database. You can use the GUI client called MySQL Workbench. Alternatively, we can access it right from Linux terminal. …

database / Linux Advanced Commands / MariaDB-Tutorials / MySQL-Tutorials

How To Recover/Reset Forgotten MySQL/MariaDB root User Password On Linux?

April 16, 2014May 14, 2019 - by Magesh Maruthamuthu - 4 Comments.

Some times we may forget MySQL/MariaDB root user password. It’s happening everywhere. It’s human mistake and it known things. It’s happening for everyone and not only for me. If so, …

linux-tutorials / MariaDB-Tutorials / MySQL-Tutorials / Shell Script / shell-scripts

A Simple Shell Script For MySQL/MariaDB Database Backup

November 27, 2013April 20, 2021 - by Magesh Maruthamuthu - 4 Comments.

A simple shell script can automate Linux admin job, which will reduce the human effort and save lots of time. As a server administrator you should take a regular backups …

MariaDB-Tutorials / MySQL-Tutorials

Three Ways To Change User’s MySQL/MariaDB Password in Linux

October 25, 2013June 10, 2019 - by Magesh Maruthamuthu - Leave a Comment

MySQL/MariaDB is an opensource database management software, which is very famous, user friendly and widely used for data storage. This will allow the user to create a database, database user, …