You run into 1292 – Incorrect date value: ‘0000-00-00’ for column ‘date’ error because since version 5.7, MySQL enables SQL Strict Mode by default and does not permit ‘0000-00-00’ as a valid date value.
For more information check MySQL Documentation 5.7
You can get simple and understandable steps to install MySQL on CentOS. Before we move into the installation, let’s have a brief look on the MySQL.
If you don’t have installed PHP on CentOS 7 you can install one by following These Instructions.
Let me tell you. MySQL open-source tool and Database Management System. MySQL is a fast, stable, true multi-user, multi-threaded SQL database server. Apart from the free edition, MySQL also offers other services like MySQL Enterprise Edition, MySQL Cluster CGE, Oracle MySQL Cloud Service and MySQL for OEM/ISV.
Drupal, Joomla, phpBB, and WordPress are some examples of MySQL database-driven web application. Facebook, Flickr
