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