MySQL-Tutorials | 2DayGeek

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 …

database / MySQL-Tutorials

How to use Mytop to monitor MySQL/MariaDB performance in Linux

July 31, 2017January 26, 2020 - by 2daygeek - Leave a Comment

Mytop is a console-based (non-gui) tool that display MySQL server performance information like “top”. It will connect to a MySQL server and periodically run the SHOW PROCESSLISTand SHOW STATUS commands …

linux-tutorials / MySQL-Tutorials

How to Drop all tables in a MySQL database

July 9, 2014December 27, 2015 - by Magesh Maruthamuthu - Leave a Comment

I’m doing some research in owncloud installation and every time i want to clear the database tables so that, i can go forward. Every time i used to drop the …

MySQL-Tutorials

How to reset/clear and MySQL replication

June 23, 2014December 27, 2015 - by Magesh Maruthamuthu - Leave a Comment

Here i’m going to explain, step’s to reset/clear MySQL (Master-Slave) replication. Two way of RESET is must be handle, so that it will reset/clear properly. Slave Server RESET Master Server …

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, …

MySQL-Tutorials

How to Enable Remote Access To MySQL Database Server

April 5, 2014December 27, 2015 - by Magesh Maruthamuthu - 2 Comments.

Here i’m going to explain, step’s to connect the mysql database remotely. 1) If you want to access mysql database remotely, you should have a Static IP so that you …

Linux Advanced Commands / MySQL-Tutorials

How to Check MySQL/MariaDB Database And Table Size In Linux?

March 27, 2014April 16, 2019 - by Magesh Maruthamuthu - 1 Comment

Sometimes you may need to check the size of each MySQL/MariaDB database and table to optimize or repair them due to some reason. So, what to do? is there any …