Detailed installation and configuration tutorial of mysql5.7 on CentOS

Install

Make sure your user has permission to install

No root switch

su root

(su means: switch user)

# rpm -ivh http://dev.mysql.com/get/mysql57-community-release-el6-9.noarch.rpm

You may encounter

warning: /var/tmp/rpm-tmp.6V5aFC: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY

Can be ignored (personal opinion, Baidu did not find a suitable answer)

# yum install mysql-community-server

Waiting for the installation to complete....

Configuration

After installation, the initial password can be found here:

grep 'temporary password' ar/log/mysqld.log

MySQL 5.7 has requirements for password complexity. If you want to create a simple password, you can first execute

set global validate_password_policy=0;

Create a user again

Please turn off SELinux on the newly installed server, otherwise you may encounter many problems caused by permissions.

setenforce 0
vi /etc/selinux/config

Change ENFORCE=enforcing to ENFORCE=disable

Configuration Files

Linux: /etc/my.cnf
Windows: my.ini in the installation directory

Default character set

Versions prior to 5.6

[mysqld]
default-character-set=utf8

Versions after 5.6

[mysqld]
character-set-server=utf8

Modify the character set of an existing database

alter database mydb default character set utf8;

Table names are not case sensitive

[mysqld]
lower_case_table_names=1

Allows creation of functions in log-bin mode

[mysqld]
log_bin_trust_function_creators=true

Enable strict mode. In non-strict mode, fields that are too long will be automatically truncated.

[mysqld]
sql-mode="STRICT_TRANS_TABLES"

The above is the detailed introduction of CenOS installation of MySQL 5.7 and simple configuration tutorial. I hope it will be helpful to everyone. If you have any questions, please leave me a message and I will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!