dba入门之 mysql安装 mysql各种安装尝试

零 mysql官网

MySQL :: MySQL Downloads

一 linux系统

1.1 l centos7 yum安装mysql5.7

wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
yum -y install mysql57-community-release-el7-10.noarch.rpm

# 如果直接安装

yum -y install mysql-community-server  # 这步可能会花些时间，安装完成后就会覆盖掉之前的mariadb。

# 大概率会报错

Failing package is: mysql-community-libs-compat-5.7.37-1.el7.x86_64
 GPG Keys are configured as: file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

# 报错解决办法

sed -i 's/gpgcheck=1/gpgcheck=0/g' /etc/yum.repos.d/mysql-community.repo
sed -i 's/gpgcheck=1/gpgcheck=0/g' /etc/yum.repos.d/mysql-community-source.repo 
# 再执行yum 安装命令即可 
yum -y install mysql-community-server  # 这步可能会花些时间，安装完成后就会覆盖掉之前的mariadb。

# 首先启动MySQL # 查看初始密码

systemctl enable mysqld.service
systemctl start  mysqld.service
grep "password" /var/log/mysqld.log # 查看初始化密码

# 进入mysql 输入password

 mysql -uroot -p

# 需要先修改root密码

set password for 'root'@'localhost'=password('cy7m0ypu8CpLFperzI45');
flush privileges;

1.2 rpm安装

# 下载 rpm总包
wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.22-1.el7.x86_64.rpm-bundle.tar

# 解压 tar包
tar xvf mysql-5.7.22-1.el7.x86_64.rpm-bundle.tar 

# 把需要安装的四个 rpm包放到install下面
mkdir install
mv mysql-community-common-5.7.22-1.el7.x86_64.rpm install/
mv mysql-community-libs-5.7.22-1.el7.x86_64.rpm install/
ls
mv mysql-community-client-5.7.22-1.el7.x86_64.rpm install/
mv mysql-community-server-5.7.22-1.el7.x86_64.rpm install/
cd install/


# 会报错
rpm -ivh mysql-community-common-5.7.22-1.el7.x86_64.rpm 
# 先卸载 mariadb-libs包
yum remove mariadb-libs -y

# 再安装就不会报错了
rpm -ivh mysql-community-common-5.7.22-1.el7.x86_64.rpm 
rpm -ivh mysql-community-libs-5.7.22-1.el7.x86_64.rpm 
rpm -ivh mysql-community-client-5.7.22-1.el7.x86_64.rpm 
rpm -ivh mysql-community-server-5.7.22-1.el7.x86_64.rpm 

# 启动mysql server
systemctl restart mysqld
systemctl enable mysqld
# 查看初始密码
grep 'temporary password' /var/log/mysqld.log

1.3 二进制安装

1.4 源码安装

二 window系统

这篇文章写的很详细，唯一需要注意的是win10的依赖要装好：

https://blog.csdn.net/qq_37172528/article/details/80459490