一.mysql下载链接
wget
https://downloads.mysql.com/archives/get/p/23/file/mysql-5.7.28-1.el7.x86_64.rpm-bundle.tar
二.解压
在/usr/local目录下创建mysql文件夹:mkdir mysql
将安装包上传到/usr/local/mysql中,然后解压:
tar -xvf mysql-5.7.28-1.el7.x86_64.rpm-bundle.tar
三.安装包有依赖关系,按顺序安装
安装第一个包时,有可能包依赖冲突,将冲突包卸载后重新安装即可。
rm -rf 安装包名称:删除冲突安装包
安装指令:rpm -ivh 安装包名称
安装包1:mysql-community-common-5.7.20-1.el7.x86_64.rpm
安装包2:mysql-community-libs-5.7.20-1.el7.x86_64.rpm
安装包3:mysql-community-client-5.7.20-1.el7.x86_64.rpm
安装包4:mysql-community-server-5.7.20-1.el7.x86_64.rpm
四.查看版本
指令:mysql --version
如果出现:mysql Ver 14.14 Distrib 5.7.28, for Linux (x86_64) using EditLine wrapper
则证明安装成功
五.启动mysql服务
==
每次开机都要手动启动
mysql ==
systemctl start mysqld
==
开机时自动开启
mysql ==
systemctl enable mysqld
==
停止
mysql
服务器
==
service mysqld stop
==
启动
mysql
服务器
==
service mysqld start
==
查看
mysql
是否启动
==
service mysqld status
出现下图所示则代表启动成功:
六.登录mysql
mysql -u root -p
ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using
password: YES)
提示错误,是因为第一次登录
mysql
需要使用
mysql
的临时密码,
该密码存放在
mysql
日志文件中。在
/var/log/mysqld.log
文件中
cd /var/log
查询临时密码
grep -n password mysqld.log
[Note] A temporary password is generated for root@localhost:
0x(g<n074&7W
0x(g<n074&7W
就是
mysql
自动生成的临时密码
重新登录
mysql
,隐式登录
mysql -u root -p
把临时密码粘贴
如果出现
mysql>
则登录成功
七.修改密码
mysql> set global validate_password_policy=LOW;
mysql> set global validate_password_length=4;
mysql> alter user ‘root’@‘localhost’ identified by ‘自己设置的mysql密码
’;
八.报错
解决办法:Redhat 9 替换yum镜像
进入之后把enabled改为0
[root@localhost ~]# yum remove subscription-manager “删除官方的订阅”
(1)为了方便操作,先删除/etc/yum.repos.d目录下的 redhat.repo文件(如果没有就不用管)
(2)在/etc/yum.repos.d目录下,用vi编辑redhat.repo文件,将下面这段代码直接复制进去,然后保存退出
(2)在/etc/yum.repos.d目录下,用vi编辑redhat.repo文件,将下面这段代码直接复制进去,然后保存退出
[AppStream]
name=AppStream
baseurl=http://mirrors.aliyun.com/almalinux/9.2/AppStream/x86_64/os/
gpgcheck=0
enabled=1
[BaseOS]
name=BaseOS
baseurl=http://mirrors.aliyun.com/almalinux/9.2/BaseOS/x86_64/os/
gpgcheck=0
enabled=1
[extras]
name=extras
baseurl=http://mirrors.aliyun.com/almalinux/9.2/extras/x86_64/os/
gpgcheck=0
enabled=1
[plus]
name=plus
baseurl=http://mirrors.aliyun.com/almalinux/9.2/plus/x86_64/os/
gpgcheck=0
enabled=1
[devel]
name=devel
baseurl=http://mirrors.aliyun.com/almalinux/9.2/devel/x86_64/os/
gpgcheck=0
enabled=1
[NFV]
name=NFV
baseurl=https://mirrors.aliyun.com/almalinux/9.2/NFV/x86_64/os/
gpgcheck=0
enabled=1
[CRB]
name=CRB
baseurl=https://mirrors.aliyun.com/almalinux/9.2/CRB/x86_64/os/
gpgcheck=0
enabled=1
[HighAvailability]
name=HighAvailability
baseurl=https://mirrors.aliyun.com/almalinux/9.2/HighAvailability/x86_64/os/
gpgcheck=0
enabled=1
[AppStream]
name=AppStream
baseurl=http://mirrors.aliyun.com/almalinux/9.2/AppStream/x86_64/os/
gpgcheck=0
enabled=1
[BaseOS]
name=BaseOS
baseurl=http://mirrors.aliyun.com/almalinux/9.2/BaseOS/x86_64/os/
gpgcheck=0
enabled=1
[extras]
name=extras
baseurl=http://mirrors.aliyun.com/almalinux/9.2/extras/x86_64/os/
gpgcheck=0
enabled=1
[plus]
name=plus
baseurl=http://mirrors.aliyun.com/almalinux/9.2/plus/x86_64/os/
gpgcheck=0
enabled=1
[devel]
name=devel
baseurl=http://mirrors.aliyun.com/almalinux/9.2/devel/x86_64/os/
gpgcheck=0
enabled=1
[NFV]
name=NFV
baseurl=https://mirrors.aliyun.com/almalinux/9.2/NFV/x86_64/os/
gpgcheck=0
enabled=1
[CRB]
name=CRB
baseurl=https://mirrors.aliyun.com/almalinux/9.2/CRB/x86_64/os/
gpgcheck=0
enabled=1
[HighAvailability]
name=HighAvailability
baseurl=https://mirrors.aliyun.com/almalinux/9.2/HighAvailability/x86_64/os/
gpgcheck=0
enabled=1
name=AppStream
baseurl=http://mirrors.aliyun.com/almalinux/9.2/AppStream/x86_64/os/
gpgcheck=0
enabled=1
[BaseOS]
name=BaseOS
baseurl=http://mirrors.aliyun.com/almalinux/9.2/BaseOS/x86_64/os/
gpgcheck=0
enabled=1
[extras]
name=extras
baseurl=http://mirrors.aliyun.com/almalinux/9.2/extras/x86_64/os/
gpgcheck=0
enabled=1
[plus]
name=plus
baseurl=http://mirrors.aliyun.com/almalinux/9.2/plus/x86_64/os/
gpgcheck=0
enabled=1
[devel]
name=devel
baseurl=http://mirrors.aliyun.com/almalinux/9.2/devel/x86_64/os/
gpgcheck=0
enabled=1
[NFV]
name=NFV
baseurl=https://mirrors.aliyun.com/almalinux/9.2/NFV/x86_64/os/
gpgcheck=0
enabled=1
[CRB]
name=CRB
baseurl=https://mirrors.aliyun.com/almalinux/9.2/CRB/x86_64/os/
gpgcheck=0
enabled=1
[HighAvailability]
name=HighAvailability
baseurl=https://mirrors.aliyun.com/almalinux/9.2/HighAvailability/x86_64/os/
gpgcheck=0
enabled=1
[AppStream]
name=AppStream
baseurl=http://mirrors.aliyun.com/almalinux/9.2/AppStream/x86_64/os/
gpgcheck=0
enabled=1
[BaseOS]
name=BaseOS
baseurl=http://mirrors.aliyun.com/almalinux/9.2/BaseOS/x86_64/os/
gpgcheck=0
enabled=1
[extras]
name=extras
baseurl=http://mirrors.aliyun.com/almalinux/9.2/extras/x86_64/os/
gpgcheck=0
enabled=1
[plus]
name=plus
baseurl=http://mirrors.aliyun.com/almalinux/9.2/plus/x86_64/os/
gpgcheck=0
enabled=1
[devel]
name=devel
baseurl=http://mirrors.aliyun.com/almalinux/9.2/devel/x86_64/os/
gpgcheck=0
enabled=1
[NFV]
name=NFV
baseurl=https://mirrors.aliyun.com/almalinux/9.2/NFV/x86_64/os/
gpgcheck=0
enabled=1
[CRB]
name=CRB
baseurl=https://mirrors.aliyun.com/almalinux/9.2/CRB/x86_64/os/
gpgcheck=0
enabled=1
[HighAvailability]
name=HighAvailability
baseurl=https://mirrors.aliyun.com/almalinux/9.2/HighAvailability/x86_64/os/
gpgcheck=0
enabled=1