安装MySql

一、安装MySql操作命令

1.查看Centos系统版本
cat /etc/centos-release

2.查看当前目录路径
pwd

3.安装wget
yum install -y wget

4.下载MySQL的RPM安装包
wget https://repo.mysql.com//mysql80-community-release-el8-1.noarch.rpm

5.使用RPM安装
rpm -ivh mysql80-community-release-el8-1.noarch.rpm

6.使用YUM安装MySQL服务
yum install -y mysql-server

7.设置开机自动启动
systemctl enable mysqld.service

8.检查开机自动启动是否设置成功
systemctl list-unit-files|grep mysqld

9.启动MySQL服务并检查服务是否开启
systemctl start mysqld.service
ps -ef|grep mysql

10.查看开放的端口（MySQL需要开放3306端口）
netstat -tlunp

11.打开MySQL
mysql -u root -p

12.修改初始密码
ALTER USER ‘root‘@‘localhost‘ IDENTIFIED BY ‘MyNewPass4!‘;#注意位数和种类至少大+写+小写+符号+数字



二、允许外部访问MySQL

1.修改MySQL数据库下的user中host值
mysql -u root -p
use mysql;
update user set host=‘%‘ where user=‘root‘;

2.赋予任何主机访问权限
mysql> GRANT ALL PRIVILEGES ON *.* TO ‘root‘@‘%‘WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES

3.查看防火墙开启的端口
firewall-cmd --zone=public --list-ports

4.添加3306端口
firewall-cmd --zone=public --add-port=3306/tcp --permanent

firewall-cmd --reload