mysql5.7 测试环境配置部署
数据库版本：Mysql 5.7.32
数据库部署步骤如下：
[root@localhost software]# pwd
/data/software
[root@localhost software]# ll
total 28
-rw-r--r--. 1 root root 25548 Apr 7 2017 mysql57-community-release-el7-10.noarch.rpm
wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
yum -y install mysql57-community-release-el7-10.noarch.rpm
yum -y install mysql-community-server
如上Mysql安装完毕，接下来根据需要进行一些配置。
先启动Mysql:
systemctl start mysqld.service
查看mysql状态即是否启动：
systemctl status mysqld.service
查看mysql5.7默认root密码：
grep "password" /var/log/mysqld.log
使用默认mysql root登陆后修改密码：
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'jxlJXL@123';
修改mysql5.7密码策略：暂略 注意：修改完密码策略后，需要重启mysql服务生效！
在防火墙开启有关端口，比如3306，看具体情况！配置防火墙需要重启防火墙服务才能生效！
修改Mysql字符编码（不修改会产生乱码）：
mysql> show variables like '%character%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)
more /etc/my.cnf
重启mysql数据库使配置生效：
systemctl restart mysqld.service
再次查看Mysql字符集：
mysql> show variables like '%character%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.01 sec)
如上所示修改字符集成功！
至此，mysql数据库部署成功。
