mysql

How To Install MySQL Server on Debian 9

debian-logo

In this tutorial, we will show you how to install MySQL Server on your Debian 9. For those of you who didn’t know, For those of you who didn’t know, MySQL is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. The MySQL source code is freely available because it was originally developed as freeware. MySQL is written in C...

How To Install MySQL Server on Ubuntu 17.04

ubuntu-logo

In this tutorial, we will show you how to install MySQL Server on Ubuntu 17.04 LTS. For those of you who didn’t know, For those of you who didn’t know, MySQL is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. The MySQL source code is freely available because it was originally developed as freeware. MySQL is written i...

How To Disable MySQL Strict Mode

Install MySQL Server on Ubuntu 16.04

In this tutorial, we will show you how to disable MySQL strict mode on your CentOS 7 server. For those of you who didn’t know, Strict mode controls how MySQL handles invalid or missing values in data-change statements such as INSERT or UPDATE. A value can be invalid for several reasons. This article assumes you have at least basic knowledge of Linux, know how to use the shell, and most import...

How To Install MySQL Server on Ubuntu 16.04

ubuntu-logo

In this tutorial, we will show you how to install and configuration of MySQL on your Ubuntu 16.04 server. For those of you who didn’t know, MySQL is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. The MySQL source code is freely available because it was originally developed as freeware. MySQL is written in C and C++ an...

How To Install MySQL Server on CentOS 7

centos-logo

In this tutorial, we will show you how to install and configuration MySQL on your CentOS 7 server. For those of you who didn’t know, MySQL is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. The MySQL source code is freely available because it was originally developed as freeware. MySQL is written in C and C++ and is co...

How To Repair Corrupted Mysql Database Table

Install MySQL Server on Ubuntu 16.04

In this tutorial, we will show you how to repair a corrupted MySQL database table on your Linux. Sometimes it happens that your database gets corrupted due to many reasons like it does not get restored properly or the server gets rebooted while updating the database etc and you have tried to repair it using PHPMyAdmin and it does show that it has been repaired but it is not. Here is how to fix a...

How To Reset Root Password MySQL Server

Install MySQL Server on Ubuntu 16.04

In this tutorial, we will show you how to reset the root password MySQL server. By default, MySQL server will be installed with root account and password is blank. Have you ever forgotten the root password on one of your MySQL servers? If you have set the password for root and forget it, then you will need to reset the root password for MySQL. To reset your MySQL password just follow these instr...

How To Enable Slow Query Log for MySQL

Install MySQL Server on Ubuntu 16.04

In this tutorial, we will show you how to enable a slow query log for MySQL on Linux systems. MySQL has built-in functionality that allows you to log SQL queries to a file, You can enable the full SQL queries logs to a file or only slow running queries log. It is easy for us to troubleshoot/ debug the SQL statement if SQL queries log enable, The slow query log is used to find queries that take a...

How To Backup and Restore MySQL Database Using Command Line

Install MySQL Server on Ubuntu 16.04

In this tutorial, we will show you how to backup and restore the MySQL database using Command-Line. For those of you who didn’t know, MySQL is an open-source database developed by Oracle whereas MariaDB is a fork of it that works similarly and uses the same command line as MySQL. This article assumes you have at least basic knowledge of Linux, know how to use the shell, and most importantly, ...

How To Completely Removing MySQL Server in CentOS

centos-logo

In this tutorial, we will show you how to complete removing MySQL on your CentOS server. For those of you who didn’t know, MySQL is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. The MySQL source code is freely available because it was originally developed as freeware. MySQL is written in C and C++ and is compatible w...