mysql

How To Install MySQL on CentOS 8

centos-logo

In this tutorial we will show you how to install and configuration of MySQL on CentOS 8. 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...

How To Install MySQL Server on Debian 10 Buster

debian-logo

In this tutorial we will show you how to install MySQL Server on your Debian 10. 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 with all ...

How To Install MySQL on Ubuntu 18.04 LTS

Install MySQL Server on Ubuntu 16.04

In this tutorial we will show you how to install MySQL on Ubuntu 18.04 LTS 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 with al...

How To Install MySQL Server on Debian 9

Install MySQL Server on Ubuntu 16.04

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

Install MySQL Server on Ubuntu 16.04

In this tutorial we will show you how to install MySQL Server on Ubuntu 16.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 in...

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 importa...

How To Install MySQL Server on Ubuntu 16.04

Install MySQL Server on Ubuntu 16.04

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++ and...

How To Install MySQL Server on CentOS 7

Install MySQL Server on Ubuntu 16.04

In this tutorial we will show you how to install and configuration of 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 ...

How To Repair Corrupted Mysql Database Table

Install MySQL Server on Ubuntu 16.04

Sometimes it happens that your database get corrupted due to many reason like it does not get restored properly or server get rebooted while updating database etc and you have tried to repair it using phpmyadmin and it does shows that it has repaired but it is not. Here is how to fix a corrupted table (note the single ‘s and {} pairs are not part of the sql commands but are used for clarity an...

How To Reset Root Password MySQL Server

Install MySQL Server on Ubuntu 16.04

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 instructions and we assume that you already have a small amount of knowledge on MySQL...