linux下安装mysql并配置允许远程连接

1、上传mysql的rpm安装文件
mkdir -p /opt/soft/mysql
把
01_mysql-community-common-5.7.29-1.el7.x86_64.rpm
02_mysql-community-libs-5.7.29-1.el7.x86_64.rpm
03_mysql-community-libs-compat-5.7.29-1.el7.x86_64.rpm
04_mysql-community-client-5.7.29-1.el7.x86_64.rpm
05_mysql-community-server-5.7.29-1.el7.x86_64.rpm
/opt/soft/mysql
2、查询旧版本并卸载
rpm -qa | grep mysql
无显示
rpm -qa | grep mariadb
显示：
mariadb-libs-5.5.60-1.el7_5.x86_64
卸载文件
格式：rpm -e --nodeps 文件名
这是我电脑上的
rpm -e --nodeps mariadb-libs-5.5.60-1.el7_5.x86_64
3、本地安装MYSQL
rpm -ivh 01_mysql-community-common-5.7.29-1.el7.x86_64.rpm
rpm -ivh 02_mysql-community-libs-5.7.29-1.el7.x86_64.rpm
rpm -ivh 03_mysql-community-libs-compat-5.7.29-1.el7.x86_64.rpm
rpm -ivh 04_mysql-community-client-5.7.29-1.el7.x86_64.rpm
rpm -ivh 05_mysql-community-server-5.7.29-1.el7.x86_64.rpm
中途提示：
warning: 05_mysql-community-server-5.7.29-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
error: Failed dependencies:
net-tools is needed by mysql-community-server-5.7.29-1.el7.x86_64
运行
yum install -y net-tools
再次安装
rpm -ivh 05_mysql-community-server-5.7.29-1.el7.x86_64.rpm
4、启动MySQL服务

	systemctl enable mysqld
	systemctl start mysqld

5、重置root密码
MySQL5.7会在安装后为root用户生成一个随机密码，而不是像以往版本的空密码。 可以安全模式修改root登录密码或者用随机密码登录修改密码。下面用随机密码方式
MySQL为root用户生成的随机密码通过mysqld.log文件可以查找到：
grep ‘temporary password’ /var/log/mysqld.log
或cat /var/log/mysqld.log | grep password
6、修改root用户密码
(MySQL的密码策略比较复杂,要大小写，过于简单的密码会被拒绝)

	mysql -u root -p
	mysql> Enter password: （输入刚才查询到的随机密码）
	mysql>set global validate_password_length=4;
	mysql>set global validate_password_policy=0;
	mysql>alter user 'root'@'localhost' identified by '123456';
	mysql>alter user 'root'@'%' identified by '123456';

退出重新用123456登录

7、远程连接授权
以新密码登陆 MySQL：mysql -u root -p123456
创建用户：create user ‘root’@‘%’ identified by ‘123456’;
允许远程连接：grant all privileges on . to ‘root’@‘%’ with grant option;
刷新权限：flush privileges;