1、下载地址;https://dev.mysql.com/downloads/mysql/
2、选择对应的Linux版本和x86/x64进行下载
- 卸载旧版本的MySql (没有的话,则跳过此步骤)
a、查看旧版本MySql
rpm -qa |grep mysql
b、逐个删除掉旧的组件
4.使用 rpm 命令安装MySql组件
清除yum里所有mysql依赖包
yum remove mysql-libs mariadb-libs -y
#按照依赖关系依次安装rpm包依赖关系依次为common→libs→client→server
rpm -ivh mysql-community-common-5.7.14-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.14-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.14-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.14-1.el7.x86_64.rpm
错误:依赖检测失败:
/usr/bin/perl 被 mysql-community-server-5.7.14-1.el7.x86_64 需要
perl(Getopt::Long) 被 mysql-community-server-5.7.14-1.el7.x86_64 需要perl(strict) 被 mysql-community-server-5.7.14-1.el7.x86_64 需要
yum install -y perl
systemctl start mysqld.service 启动mysql
systemctl status mysqld.service 查看mysql状态
systemctl stop mysqld.service 关闭mysql
查看mysql进程 ps -ef|grep mysql
查看3306端口 netstat -anop|grep 3306
5.登陆mysql修改root密码
查看mysql初始密码
[root@msyql31 etc]# grep 'temporary password' /var/log/mysqld.log
2021-02-25T08:05:18.272169Z 1 [Note] A temporary password is generated for root@localhost: :Pe2)_7qvZpe
:Pe2)_7qvZpe即为登录密码。使用这个随机密码登录进去,然后修改密码,使用命令:
mysql -uroot -p
mysql> alter user root@localhost identified by 'root';
解决方案如下:
可参见:ERROR 1819 (HY000):Your password does not satisfy the current policy requirments
mysql> set global validate_password_policy=0;
mysql> set global validate_password_length=1;
mysql> set password for root@localhost=password('root');
mysql> flush privileges;
查看当前授予过的权限:
mysql> use mysql;
mysql> select user,host from user;
授予root用户远程访问权限:
mysql> grant all privileges on *.* to root@'%' identified by 'root';
mysql> flush privileges;
查看msyql是否开机自启
systemctl list-unit-files |grep mysql
#取消mysqld的自启动
systemctl disable mysqld
6.Linux7.x系统关闭防火墙iptables命令如下:
查看防火墙的状态:
firewall-cmd --state或者使用iptables -L
关闭防火墙:
systemctl stop firewalld.service
#禁止firewall开机启动
systemctl disable firewalld.service