1.下载RPM源
直接使用yum命令下载mysql来进行安装是不能成功的,安装过程会有问题,这里需要使用rpm命令来先进下载。下载路径为:
#rpm源参考地址:
rpm源地址:https://dev.mysql.com/downloads/repo/yum/
例如MYSQL5.7:https://repo.mysql.com//mysql57-community-release-el7-11.noarch.rpm
#下载
rpm -Uvh https://repo.mysql.com//mysql57-community-release-el7-11.noarch.rpm
![](https://images2018.cnblogs.com/blog/1383434/201804/1383434-20180424115418658-767951753.png)
下载完成之后查看一下都有哪些mysql的文件,使用命令:
yum repolist enabled | grep "mysql.*-community.*"
![](https://images2018.cnblogs.com/blog/1383434/201804/1383434-20180424115434599-859060929.png)
2.安装
下面就可以使用yum进行安装了。输入命令:
yum install mysql-community-server -y
等待下载安装,安装完成后
3.配置
首先将mysql启动,开启mysql的守护进程,使用命令:
systemctl start mysqld
先记录一下默认的root密码,之后会用到:
grep "temporary password" /var/log/mysqld.log
![](https://images2018.cnblogs.com/blog/1383434/201804/1383434-20180424115518666-110459725.png)
将mysql启动之后,开始进行一些基本信息的设置。输入设置命令:
mysql_secure_installation
![](https://images2018.cnblogs.com/blog/1383434/201804/1383434-20180424115535396-757468027.png)
输入刚才的默认密码:
![](https://images2018.cnblogs.com/blog/1383434/201804/1383434-20180424115550491-191721859.png)
设置新密码:
![](https://images2018.cnblogs.com/blog/1383434/201804/1383434-20180424115600887-826688676.png)
注意:
如果出现 ... Failed! Error: Your password does not satisfy the current policy requirements错误,是因为密码过于简单。刚安装的mysql的密码默认强度是最高的,如果想要设置简单的密码就要修改validate_password_policy的值
如果要修改这个值,
1、先登入到mysql
![](https://images2015.cnblogs.com/blog/492886/201701/492886-20170109101147603-31494352.png)
mysql> set PASSWORD = PASSWORD('123456');
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
2、设置安全级别
![](https://images2015.cnblogs.com/blog/492886/201701/492886-20170109101432650-938580806.png)
mysql> set global validate_password_policy=0;
3、默认密码长度为8,可以设置为其它值,最小4位
![](https://images2015.cnblogs.com/blog/492886/201701/492886-20170109101710666-610243289.png)
mysql> set global validate_password_length=4;
4、设置新密码,刚安装完的mysql必须设置新密码(应该是从5.5版本开始)
![](https://images2015.cnblogs.com/blog/492886/201701/492886-20170109101821635-1365642843.png)
是否删除匿名用户?
![](https://images2018.cnblogs.com/blog/1383434/201804/1383434-20180424115651765-1506610020.png)
是否禁止远程访问?
![](https://images2018.cnblogs.com/blog/1383434/201804/1383434-20180424115705067-1610907957.png)
是否删除test数据库?
![](https://images2018.cnblogs.com/blog/1383434/201804/1383434-20180424115712912-181653029.png)
刷新权限?
![](https://images2018.cnblogs.com/blog/1383434/201804/1383434-20180424115724483-2120294838.png)
4.MYSQL正式安装完成
5.阿里云配置远程连接
1.首先安全组开放端口
2.登录mysql:
mysql -u root -h localhost -p
use mysql; #打开mysql数据库
3.将host设置为%表示任何ip都能连接mysql,当然也可以将host指定为某个ip
update user set host='%' where user='root' and host='localhost';
flush privileges; #刷新权限,使配置生效
![](https://images2018.cnblogs.com/blog/1383434/201804/1383434-20180424115742933-943411760.png)
这样就可以远程连接了
备注1:关闭远程连接
use mysql #打开mysql数据库
#将host设置为localhost表示只能本地连接mysql
update user set host='localhost' where user='root';
#刷新权限表,使配置生效
flush privileges;
备注2:不使用root,专门创建一个用户来用于远程访问
#账号remoteuser,密码123456
grant all on *.* to 'remoteuser'@'%' identified by '123456';
flush privileges;