1 下载mysql安装包
wget https://dev.mysql.com/get/mysql57-community-release-el6-9.noarch.rpm
2安装用来配置安装MySQL的包
yum -y install mysql57-community-release-el6-9.noarch.rpm
3安装MySQL
sudo yum install mysql-server（推荐）或yum -y install mysql-community-server
4启动MySQL
systemctl start mysqld
5查看有无启动
systemctl start mysqld.service 启动mysql
systemctl status mysqld.service 查看mysql状态
systemctl stop mysqld.service 停止mysql
systemctl restart mysqld.service 重启mysql
6 进入数据库
mysql -u root - p
7修改密码
ALTER USER'root'@'localhost'IDENTIFIED WITH mysql_native_password BY'123456';（此处给你的root用户设置密码）
8修改MySQL连接权限(这样就可以远程通过IP连接)（8和9取其一即可）
mysql> use mysql;
mysql> update user set host = '%' where user ='root';
9添加用户和授权远程（8和9取其一即可）
create user '用户名'@'%' identified by '密码';
grant all privileges on *.* to 'jiangjun'@'%';
10查看用户
select user,host from mysql.user;
11查看防火墙（需关闭防火墙）
systemctl status firewalld.service
开启防火墙
systemctl start firewalld.service
关闭防火墙
systemctl stop firewalld.service
禁用防火墙
systemctl disable firewalld.service
12 特别注意
如果是用的阿里云，需开放3306端口，才可在navicat远程访问
登录阿里云，在实例里面设置
13 navicat 远程连接
若是远程连接不成功，则需要在/etc/my.cnf 文件下加上以下一行文字即可
