MySql教程

centos rpm离线安装mysql8.0

本文主要是介绍centos rpm离线安装mysql8.0，对大家解决编程问题具有一定的参考价值，需要的程序猿们随着小编来一起学习吧！ 
wget https://cdn.mysql.com/archives/mysql-8.0/mysql-8.0.16-2.el7.x86_64.rpm-bundle.tar

解压包

tar -xvf mysql-8.0.16-2.el7.x86_64.rpm-bundle.tar

检索是否已存在mysql

rpm -qa | grep -i mariadb

移除mysql相关依赖包

rpm -ev --nodeps mariadb-libs-5.5.65-1.el7.x86_64

开始安装，顺序依次执行安装rpm包

rpm -ivh mysql-community-common-8.0.16-2.el7.x86_64.rpm

rpm -ivh mysql-community-libs-8.0.16-2.el7.x86_64.rpm

rpm -ivh mysql-community-client-8.0.16-2.el7.x86_64.rpm

rpm -ivh mysql-community-server-8.0.16-2.el7.x86_64.rpm

启动

systemctl start mysqld

查看初始密码

cat /var/log/mysqld.log | grep password

登录

mysql -u root -p

更改密码、设置可远程登录、刷新权限。

ALTER user 'root'@'localhost' IDENTIFIED BY '123456';

ALTER user 'root'@'localhost' IDENTIFIED BY 'Root.123456';

use mysql; select host,user from user; update user set host='%' where user ='root';

flush privileges;

 

这篇关于centos rpm离线安装mysql8.0的文章就介绍到这儿，希望我们推荐的文章对大家有所帮助，也希望大家多多支持为之网！
您可能喜欢
栏目导航