Page tree

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.


O/S DistributionURLPackage Name
CentOS 7
CentOS 8
Ubuntu 16.04 
Ubuntu 18.04 

For CentOS 7.x:

Code Block
# Install MySql Repo List
sudo wget
sudo rpm -Uvh mysql80-community-release-el7-1.noarch.rpm
# Check list of available Mysql Repos; by default 8.0 is enabled, but we want 5.7
yum repolist all | grep mysql
# Disable 8.0 and enable 5.7
sudo yum-config-manager --disable mysql80-community
sudo yum-config-manager --enable mysql57-community
# Verify repo state
yum repolist all | grep mysql
# Install Mysql Server
sudo yum install mysql-community-server
# Start mysql server
sudo systemctl start mysqld.service
# Verify status
sudo systemctl status mysqld.service


See Database Parameter Reference.

Enable SQL Mode

When using MySQL, you must enable the following modes:


NOTE: These modes are enabled by default in deployments of upstream MySQL. They must be enabled manually if you are installing the databases in a hosted environment, such as Amazon RDS or Azure MySQL. Refer to your MySQL host's documentation.


To verify:

To verify if these modes are enabled, please execute the following query:

Code Block
SELECT @@sql_mode;

The two required values should be listed in the query output. 

To enable:

For more information on enabling these modes, see

Update MySQL Password Policy