安装 MySQL

Linux yum 安装

1
2
3
4
wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
sudo rpm -ivh mysql-community-release-el7-5.noarch.rpm
yum update
yum install mysql-server

Linux rpm 安装

1
2
3
4
5
6
7
8
9
10
11
12
13
14
cd ~/download
wget http://192.168.137.10/db/mysql/mysql-5.7.23-1.el7.x86_64.rpm-bundle.tar
tar xvf mysql-5.7.23-1.el7.x86_64.rpm-bundle.tar

rpm -ivh mysql-community-common-5.7.23-1.el7.x86_64.rpm \
mysql-community-client-5.7.23-1.el7.x86_64.rpm \
mysql-community-server-5.7.23-1.el7.x86_64.rpm \
mysql-community-libs-5.7.23-1.el7.x86_64.rpm  --force --nodeps

service mysqld start && tail -f /var/log/mysqld.log
systemctl start mysqld && tail -f /var/log/mysqld.log

// 禁止开机自启
systemctl disable mysqld

启动

1
mysqld --user=root --init-file=/etc/my.cnf

常见问题

Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY

加上--force --nodeps选项

/usr/sbin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory

安装libaio即可yum install libaio -y

[ERROR] –initialize specified but the data directory has files in it. Aborting.

rm -rf /var/lib/mysql/

注意

  • 安装之前查看是否存在已安装的mysql rpm，如果已安装需要移除
  • 此方法安装的mysql目录是分散的

Linux 源码安装

Installing MySQL on Microsoft Windows Using a noinstall ZIP Archive
https://dev.mysql.com/doc/refman/5.7/en/windows-install-archive.html

MySQL 5.6 for Windows 解压缩版配置安装_百度经验
https://jingyan.baidu.com/article/f3ad7d0ffc061a09c3345bf0.html

How to Install MySQL on CentOS 7
https://www.linode.com/docs/databases/mysql/how-to-install-mysql-on-centos-7

Linux 源码编译安装MySQL 5.7
https://itbilu.com/database/mysql/VJVOut01M.html

Windows 安装

下载

MySQL5.7 32位
https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.20-win32.zip

MySQL5.7 64位
https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.20-winx64.zip

步骤

  1. 解压mysql-5.7.20-win32.zip文件到安装目录

  2. 创建选项文件，推荐存放于C:\etc\mysql5.7.ini，内容如下

1
2
3
4
[mysqld]
datadir = C:/repos/db/mysql5.7/
port = 3306
character-set-server=utf8
  1. 初始化数据库
1
mysqld --defaults-file=c:\usr\mysql\mysql5.7\my.ini --initialize
  1. 启动
1
2
mysqld --defaults-file=c:\usr\mysql\mysql5.7\my.ini
mysqladmin -uroot shutdown // 停止服务

注册服务（不推荐）

1
2
3
cmd进入mysql bin文件夹
mysqld --install [serviceName] 注册服务
mysqld --remove [serviceName] 移除已注册的服务

启动bat

1
2
cd C:\aneat\usr\mysql\mysql5.7\bin
start cmd /k mysqld.exe --defaults-file=c:\aneat\usr\mysql\mysql5.7\my.ini

注意

  • 如果缺少 msvcr120.dll、msvcp120.dll，复制缺少文件至c:\windows\system32（64位程序）和c:\windows\syswow64（32位程序），jdk1.8下有这两个文件
  • mysql5.6不需要创建选项文件my.ini、初始化数据库这些操作（可以直接解压后运行）
  • mysql5.7默认创建数据库无初始化用户参考 [2.配置MySQL —— MySQL5.7启动服务成功后无用户可登录]