centos7 jsp mysql_Centos7 Mysql安装

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.启动MySQL服务

service mysqld start

等同于命令：systemctl start mysqld

重启命令是：service mysqld restart

6.检查mysql 的运行状态

service mysqld status

7.修改root本地登录密码

7.1查看初始密码

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

7.2用初始密码登录

mysql -uroot -p

7.3修改初始密码

set password for 'root'@'localhost'=password('Root@123456');

注意：mysql5.7默认安装了密码安全检查插件(validate_password)，默认密码检查策略要求密码必须包含：大小写字母、数字和特殊符号，并且长度不能少于8位。否则会提示ERROR 1819 (HY000): Your password does not satisfy the current policy requirements错误

8.授权其他机器登陆

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'Root@123456' WITH GRANT OPTION;

FLUSH  PRIVILEGES;

9.防火墙开启3306端口

sudo firewall-cmd --zone=public --add-port=3306/tcp --permanent

sudo systemctl restart firewalld.service #重启防火墙

查看所有开启的端口命令：firewall-cmd --list-ports

10.测试连接

11.设置mysql开机启动

systemctl enable mysqld

systemctl daemon-reload

12.mysql文件目录

参考文档：

https://www.linuxidc.com/Linux/2016-09/135288.htm

https://www.cnblogs.com/jimboi/p/6405560.html

https://www.cnblogs.com/silentdoer/articles/7258232.html