首先去mysql官网下载rpm包,下载路径如下:
[mysql 安装包下载路径] (https://dev.mysql.com/downloads/mysql/)
下载如下图所示安装版本
上传安装包,进行解压,里面会有多个rpm包,我们只要其中四个
tar -xf mysql-5.7.28.el7_64.rpm-bundle.tar
#查看是否安装mysql
rpm -qa |grep -i mariadb
mariadb-libs-5.5.56-2.el7.x86_64
#若安装请卸载,卸载命令如下:
rpm -e --nodeps mariadb-libs
#然后按如下顺序安装,(必须选择如下顺序) 安装命令如下:
rpm -ivh mysql-community-common-5.7.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.28-1.el7.x86_64.rpm
安装mysql-community-server-5.7.28-1.el7.x86_64.rpm过程可能会报如下错误:
Warning:mysql-community-server-5.7.28-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.28-1.el7.x86_64
解决方法如下:
yum -y install libaio net-tools perl
启动MYSQL,启动命令如下
service mysqld start
#查看mysql状态
systemctl mysqld status
然后查看MYSQL 临时密码
cat /var/log/mysqld.log | more| grep password
修改初始密码及授权远程访问,命令如下:
mysql -uroot -pE123ASA*
#修改mysql密码
mysql> set password='pwd123456';
#进行用户授权
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'pwd123456';
在执行过程中可能会报如下错误:
如果报错,请执行如下命令
mysql> set global validate_password_policy=LOW;
此时rpm安装mysql就全部完成,如果有问题或者有疑问都可以私信咨询