centos7 离线安装mysql

梦里梦外; 2022-06-03 06:50 253阅读 0赞

centos7 安装后默认安装了mariadb。如果需要自定义安装mysql的话

## centos 7 卸载 mariadb 的正确命令 ##

\#列出所有被安装的rpm package   
rpm -qa | grep mariadb  
  
\#卸载  
rpm -e mariadb-libs-5.5.37-1.el7\_0.x86\_64  
  
错误：依赖检测失败：  
        libmysqlclient.so.18()(64bit) 被 (已安裝) postfix-2:2.10.1-6.el7.x86\_64 需要  
        libmysqlclient.so.18(libmysqlclient\_18)(64bit) 被 (已安裝) postfix-2:2.10.1-6.el7.x86\_64 需要  
  
\#强制卸载，因为没有 **--nodeps**  
rpm -e --nodeps mariadb-libs-5.5.56-2.el7.x86\_64

## mysql下载地址 ##

http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.18-1.el7.x86\_64.rpm-bundle.tar  
解压mysql  
tar -zxf mysql-5.7.16-1.el7.x86\_64.rpm-bundle.tar

## mysql相关的包 ##

libaio-0.3.109-13.el7.x86\_64.rpm

openssl-1.0.2n.tar.gz

查看地址下载相关的包：链接: https://pan.baidu.com/s/1pLQfLur 密码: 35gb

## 安装 ##

rpm -ivh mysql-community-common-5.7.16-1.el7.x86\_64.rpm  
rpm -ivh mysql-community-libs-5.7.16-1.el7.x86\_64.rpm   
rpm -ivh mysql-community-client-5.7.16-1.el7.x86\_64.rpm  
  
安装mysql-community-server-5.7.16-1.el7.x86\_64.rpm 前需要安装libaio-0.3.107-10.el6.x86\_64.rpm  
下载地址：  
http://mirror.centos.org/centos/6/os/x86\_64/Packages/libaio-0.3.107-10.el6.x86\_64.rpm  
  
安装libaio库：  
rpm -ivh libaio-0.3.107-10.el6.x86\_64.rpm  
  
安装mysql-community-server  
rpm -ivh mysql-community-server-5.7.16-1.el7.x86\_64.rpm  
rpm -ivh mysql-community-devel-5.7.16-1.el7.x86\_64.rpm

## 初始化mysql  ##

mysqld --initialize   
chown mysql:mysql /var/lib/mysql -R  
systemctl start mysqld.service   
systemctl  enable mysqld

### 查看mysql初始化密码 ###

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

## 登录mysql ##

mysql -uroot -p'密码'  
set password=password('123123');  
\\q //退出  
  
  
连接mysql:  
mysql -u root -p 回车

123123

之后操作数据库就可

show databases;

use mysql;

show tables;