Page tree

Versions Compared

Key

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

...

O/S DistributionURLPackage Name
CentOS 7https://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpmmysql-community-server
CentOS 8https://dev.mysql.com/get/mysql80-community-release-el8-1.noarch.rpmmysql-community-server
RHEL 7https://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpmmysql-community-server
RHEL 8https://dev.mysql.com/get/mysql80-community-release-el8-1.noarch.rpmmysql-community-server
Ubuntu 16.04https://dev.mysql.com/get/mysql-apt-config_0.8.10-1_all.deb 
Ubuntu 18.04https://dev.mysql.com/get/mysql-apt-config_0.8.10-1_all.deb 

For CentOS 7.x:

Code Block
# Install MySql Repo List
sudo wget https://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpm
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:

Info

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.

  • STRICT_TRANS_TABLES
  • NO_ENGINE_SUBSTITUTION

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 https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html.

Update MySQL Password Policy

...