CentOS7.9安装Mysql5.7

CentOS7.9安装Mysql5.7：

yum remove mariadb-libs

yum install perl-JSON

cd /space/setup/

tar xfv mysql-5.7.26-1.el7.x86_64.rpm-bundle.tar

rpm -i /space/setup/mysql5.7/rpm/mysql-community-common-5.7.26-1.el7.x86_64.rpm /space/setup/mysql5.7/rpm/mysql-community-client-5.7.26-1.el7.x86_64.rpm /space/setup/mysql5.7/rpm/mysql-community-devel-5.7.26-1.el7.x86_64.rpm /space/setup/mysql5.7/rpm/mysql-community-embedded-5.7.26-1.el7.x86_64.rpm /space/setup/mysql5.7/rpm/mysql-community-embedded-compat-5.7.26-1.el7.x86_64.rpm /space/setup/mysql5.7/rpm/mysql-community-embedded-devel-5.7.26-1.el7.x86_64.rpm /space/setup/mysql5.7/rpm/mysql-community-libs-5.7.26-1.el7.x86_64.rpm /space/setup/mysql5.7/rpm/mysql-community-libs-compat-5.7.26-1.el7.x86_64.rpm /space/setup/mysql5.7/rpm/mysql-community-server-5.7.26-1.el7.x86_64.rpm /space/setup/mysql5.7/rpm/mysql-community-test-5.7.26-1.el7.x86_64.rpm

mkdir /space/mysqldb

mkdir /space/mysqldb/mysql

mkdir /space/mysqldb/mysql_logs

touch /space/mysqldb/mysql_logs/mysqld.log

touch /space/mysqldb/mysql_logs/mysql-slow.log

chown mysql:mysql /space/mysqldb -R

vi /etc/my.cnf

datadir=/space/mysqldb/mysql

max_connections = 2000 slow_query_log = 1 slow_query_log_file = /space/mysqldb/mysql_logs/mysql-slow.log long_query_time = 2

log-error=/space/mysqldb/mysql_logs/mysqld.log

show_compatibility_56=on

sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'

:wq

systemctl restart mysqld

cat /space/mysqldb/mysql_logs/mysqld.log | grep password （查看初始密码）

mysql -u root -p'xxxxx'

> show databases;

> ALTER USER 'root'@'localhost' identified by 'xxxxx'; (设置新密码)

> show databases;