CentOS 7 安装 Mysql

临时目录下载安装包

cd /tmp

1 下载mysql源安装包

wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm

2 安装mysql源

yum localinstall mysql57-community-release-el7-8.noarch.rpm

3 检查mysql源是否安装成功

yum repolist enabled | grep "mysql.*-community.*"

4 安装MySQL

yum install mysql-community-server

5 安装配置文件

vim /etc/my.cnf

[mysql]

default-character-set=utf8mb4

[mysqld]

port=3306

max_connections=200

character-set-server=utf8mb4

collation-server=utf8mb4_unicode_ci

init_connect='SET NAMES utf8mb4'

default-storage-engine=INNODB

innodb_large_prefix=on

innodb_file_format=Barracuda

innodb_file_per_table=ON

max_allowed_packet=16M

character-set-client-handshake=FALSE

[client]

default-character-set=utf8mb4

6 启动MySQL服务

systemctl start mysqld

7 查看MySQL的启动状态

systemctl status mysqld

8 修改root默认密码

mysql安装完成之后，在/var/log/mysqld.log文件中给root生成了一个默认密码。通过下面的方式找到root默认密码，然后登录mysql进行修改：

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

登录mysql

mysql -uroot -p

Enter password: 输入默认密码

更改密码

set global validate_password_policy=0;

ALTER USER 'root'@'localhost' IDENTIFIED BY 'xxxx';