大家好，今天给各位分享Linux系统下MySQL 5.5、5.6和5.7版本安装方法：RPM、二进制及源码安装指南的一些知识，其中也会对进行解释，文章篇幅可能偏长，如果能碰巧解决你现在面临的问题，别忘了关注本站，现在就马上开始吧！
1.2 前言
1.2.1 简介及注意事项
亲爱的技术爱好者，看完这篇文章，你可以掌握以下技能，还可以学到一些你不知道的其他知识，~O(_)O~：
MySQL二进制安装流程（要点）
MySQL多实例管理（mysqld_multi）
MySQL源码编译安装过程
Linux逻辑卷的使用
文件的MD5值
访问MySQL的几种客户端工具（Navicat和MySQL Workbench）
修改MySQL密码
设置远程访问MySQL
设置MySQL启动和多实例启动
RPM、二进制和源代码编译的优缺点
尖端：
本文在itpub（http://blog.itpub.net/26736162）、博客园（http://www.cnblogs.com/lhrbest）、微信公众号（xiaomaimiaolhr）同步更新。
文中使用的所有代码、相关软件、相关资料以及本文的pdf版本均可在麦苗云盘下载。麦苗的云盘地址可以找到：http://blog.itpub.net/26736162/viewspace-1624453/。
若网页文章代码格式错乱，请下载pdf格式文档阅读。
在本BLOG中，代码输出部分一般放在一个一行一列的表格中。
本文适合MySQL初学者和中级读者。 MySQL高手请跳过本文。
不喜欢就不要喷。
如果本文有任何错误或者不完善的地方，欢迎指正。您的批评是我写作的最大动力。
1.3 本文简介
从去年3月份开始写这本书以来，大部分内容已经基本完成。一个字，累！三个字，真累！我因此错过了很多东西，当然也收获了很多。就让一切都过去吧。现在我们来谈谈博客。虽然这段时间我的博客更新频繁，但是大部分内容都不是我原创，基本都是从网上整理的。有的朋友可能会骂麦苗抄袭。我不会反驳，因为这确实是抄袭。小麦幼苗为什么会这样做，可能有几个原因。第一，实用文章原创内容很少，网上的文章大多是一一抄袭。很多内容很难找到原作者。其次，个别文章还不是很完整。如果不整理在一起，下次再遇到同样的内容，还得再去网上搜索，浪费时间。第三，这些非原创文章不仅供网友参考，更重要的是供麦苗本身参考。毕竟人的记忆力是有限的，麦苗也经常搜索自己的文章，所以这并不丢脸。第四，有的文章写得很好，但有的地方写得不严谨或者有错误。这个时候，麦苗整理到自己的博客里就可以修改了。不管我说多少，有网友觉得这些都是借口，好吧。抄袭就是抄袭，再多的借口也改变不了抄袭的本质。麦苗就不再说了，我只想说一件事，不喜欢就别喷。
从今天开始，麦苗准备学习OCM和MySQL。那么，今天我们来安装各个版本的MySQL。学习MySQL，估计需要安装5.5、5.6、5.7版本。不过，与Oracle相比，MySQL还是更容易安装。
麦苗出版的书籍：http://blog.itpub.net/26736162/viewspace-2142121/
废话说了一大堆，开始安装吧。
1.4 Linux下各种安装方式比较
Windows下可以使用NOINSTALL包和图形包来安装。在Linux下，可以使用以下三种方法进行安装：
RPM（红帽包管理）
二进制包
源码包
优势
安装方便，适合初学者学习和使用
易于安装；可以安装在任意路径，灵活性好；一台服务器上可以安装多个MySQL
可以在实际安装的操作系统上根据需要定制编译，最灵活，性能最好；一台服务器上可以安装多个MySQL
缺点
客户端和服务器端需要分别下载；安装路径不灵活，默认路径不可修改，一台服务器只能安装一台MySQL。
已经编译了，性能不如源码编译；编译参数无法灵活定制。
安装过程复杂；编译时间长
文件布局
/usr/bin：客户端程序和脚本
/usr/sbin：mysqld 服务器
/var/lib/mysql：日志文件、数据库
/usr/share/doc/packages：文档
/usr/include/mysql：包含（头）文件
/usr/lib/mysql：库文件
/usr/share/mysql：错误消息和字符集文件
/usr/share/sql-bench：基准程序bin：客户端程序和mysqld服务器
数据：日志文件、数据库
文档：文档、变更日志
include：包含（头）文件
库：库
脚本：mysql_install_db 用于初始化系统数据库
share/mysql：错误消息文件
sql-bench：基准程序bin：客户端程序和脚本
include/mysql：包含（头）文件
info：信息格式的文档
lib/mysql：库文件
libexec：mysqld 服务器
share/mysql：错误消息文件
sql-bench：基准测试程序和崩溃测试
var：数据库和日志文件
主要安装流程
大多数情况下，下载MySQL-server 和MySQL-client 就足够了。安装方法如下：
rpm -ivh MySQL-server*MySQL-client*1.添加用户
mysql 组添加
useradd -g mysql mysql
2.安装
tar -xzvf mysql-VERSION-OS.tar.gz -C /mysql/
ln -s MySQL-VERSION-OS mysql 或使用mv 命令
3、初始化，MySQL 5.7以后使用mysqld --initialize
脚本/mysql_install_db
4.启动数据库并更改密码等。
mysqld_安全
设置密码=密码("lhr");除了安装过程的第二步外，其他步骤与二进制基本相同（MySQL 5.7开始使用cmake）：
gunzip mysql-VERSION.tar.gz | mysql-VERSION.tar.gz焦油-xvf-
cd mysql-版本
./configure --prefix=/usr/local/mysql
makemake安装
安装包下载选项
红帽企业Linux/Oracle Linux
Linux 通用
源代码
rpm的安装方法可以参考：
http://blog.itpub.net/26736162/viewspace-1349705/
http://blog.itpub.net/26736162/viewspace-1349787/
以上三种方法在官网上都有对应的下载链接。其中，源码安装对应“源码”；tar.gz 对应于“Linux-Generic”，rpm 对应于“Red Hat Enterprise Linux/Oracle Linux”。如下图所示，
1.5 注意事项
1.目录大小。 MySQL 5.7的二进制包安装后约3G，因此可以分配5G空间；而5.5、5.6版本的二进制包安装可以分配2G左右。
2 MySQL 5.7的源代码包需要分配10G的空间。 cmake 至少需要2.8.2 版本。
3、下载上传后，需要验证md5值，防止上传的文件不完整。
4编译和安装源代码既费时又费力。
1.6MySQL下载
在官网：http://dev.mysql.com/downloads/mysql/，选择以下版本的MySQL进行下载：
注：MD5:dbe7e5e820377c29d8681005065e5728下载后需要验证。
感觉MySQL的安装包越来越大，但是相对于Oracle来说，却小了很多。麦苗已经把安装文件放到了云盘上，参考：http://blog.itpub.net/26736162/viewspace-1624453/。
注意：不要下载rpm类型的软件包。安装路径不灵活，默认路径不可修改。一台服务器上只能安装一个MySQL。下图都是下载后的rpm包：
1.6.1 MySQL历史版本下载
地址：https://downloads.mysql.com/archives/community/，最早版本只能看到5.0.15
1.7MySQL 5.7安装
1.7.1 下载
在官网：http://dev.mysql.com/downloads/mysql/，选择以下版本的MySQL进行下载：
注：MD5:dbe7e5e820377c29d8681005065e5728下载后需要验证。
1.7.2操作系统路径设置
我们同意：
项目
源数据库
数据库类型
MySQL 5.7.19
数据库版本
5.7.19
数据库存储
Linux文件系统
操作系统版本和内核版本
RHEL 6.5
操作系统主机名
左心脑血管数据库
操作系统IP地址
192.168.59.159
安装文件下载目录
/tmp/mysql5719
MySQL目录安装位置
/var/lib/mysql57/mysql5719
数据库保存位置
/var/lib/mysql57/mysql5719/data
日志保存位置
/var/lib/mysql57/mysql5719/log
配置文件地址
/etc/my.cnf
需要注意的是，解压后的安装文件大小约为2.6G，比MySQL 5.6还要大。我记得5.6版本解压后不到1G。因此，这里的安装目录大小为5G。
让我们开始准备操作系统。使用之前已经安装的操作系统，文件系统采用逻辑卷管理方式，如下图：
[root@LHRDB ~]# df -h
已使用的文件系统大小可用使用% 安装于
/dev/mapper/vg_rootlhr-Vol00 9.9G 4.9G 4.6G 52% /
tmpfs 2.0G 72K 2.0G 1% /dev/shm
/dev/sda1 194M 35M 150M 19% /boot
/dev/mapper/vg_rootlhr-Vol01 3.0G 70M 2.8G 3% /tmp
/dev/mapper/vg_rootlhr-Vol03 3.0G 69M 2.8G 3% /home
.host:/331G 272G 59G 83% /mnt/hgfs
[root@LHRDB ~]#lvs
LV VG Attr LSize 池源数据% 移动日志Cpy% 同步转换
Vol00 vg_rootlhr -wi-ao---- 10.00g
Vol01 vg_rootlhr -wi-ao---- 3.00g
Vol02 vg_rootlhr -wi-ao---- 2.00g
Vol03 vg_rootlhr -wi-ao---- 3.00g
[root@LHRDB ~]#pvs
PV VG Fmt Attr PSize PFree
/dev/sda2 vg_rootlhr lvm2 a-- 10.00g 0
/dev/sda3 vg_rootlhr lvm2 a-- 9.80g 1.80g
/dev/sdb1 lvm2 a-- 10.00g 10.00g
/dev/sdb10 lvm2 a-- 10.00g 10.00g
/dev/sdb11 lvm2 a-- 9.99g 9.99g
/dev/sdb2 lvm2 a-- 10.00g 10.00g
/dev/sdb3 lvm2 a-- 10.00g 10.00g
/dev/sdb5 lvm2 a-- 10.00g 10.00g
/dev/sdb6 lvm2 a-- 10.00g 10.00g
/dev/sdb7 lvm2 a-- 10.00g 10.00g
/dev/sdb8 lvm2 a-- 10.00g 10.00g
/dev/sdb9 lvm2 a-- 10.00g 10.00g
[root@LHRDB ~]#vgs
VG #PV #LV #SN Attr VSize VFree
vg_rootlhr 2 4 0 wz--n- 19.80g 1.80g
[root@LHRDB ~]#vgcreate vg_mysqlsoft /dev/sdb1
卷组“vg_mysqlsoft”已成功创建
[root@LHRDB ~]# vgs
VG #PV #LV #SN Attr VSize VFree
vg_mysqlsoft 1 0 0 wz--n- 10.00g 10.00g
vg_rootlhr 2 4 0 wz--n- 19.80g 1.80g
[root@LHRDB ~]#lvcreate -n lv_mysqlsoft_57 -L5G vg_mysqlsoft
已创建逻辑卷“lv_mysqlsoft_57”
[root@LHRDB ~]# lvs
LV VG Attr LSize 池原始数据% 移动日志Cpy% 同步转换
lv_mysqlsoft_57 vg_mysqlsoft -wi-a----- 5.00g
Vol00 vg_rootlhr -wi-ao---- 10.00g
Vol01 vg_rootlhr -wi-ao---- 3.00g
Vol02 vg_rootlhr -wi-ao---- 2.00g
Vol03 vg_rootlhr -wi-ao---- 3.00g
[root@LHRDB ~]#mkfs.ext4 /dev/vg_mysqlsoft/lv_mysqlsoft_57
mke2fs 1.41.12（2010 年5 月17 日）
文件系统标签=
操作系统类型： Linux
块大小=4096（log=2）
片段大小=4096（log=2）
步幅=0 块，条纹宽度=0 块
327680 个索引节点，1310720 个块
65536 个区块(5.00%) 保留给超级用户
第一个数据块=0
最大文件系统块=1342177280
40个块组
每组32768 个块，每组32768 个片段
每组8192 个索引节点
存储在blocks:上的超级块备份
32768、98304、163840、229376、294912、819200、884736
写入inode 表： 完成
创建日志（32768 块）: 已完成
写入超级块和文件系统记帐信息： 已完成
该文件系统将每32 次安装自动检查一次或
180 天，以先到者为准。使用tune2fs -c 或-i 覆盖。
[root@LHRDB ~]#mkdir -p /tmp/mysql5719
[root@LHRDB ~]#mkdir -p /var/lib/mysql57
[root@LHRDB ~]#mount /dev/vg_mysqlsoft/lv_mysqlsoft_57 /var/lib/mysql57/
[root@LHRDB ~]# df -h
已使用的文件系统大小可用使用% 安装于
/dev/mapper/vg_rootlhr-Vol00 9.9G 4.9G 4.6G 52% /
tmpfs 2.0G 72K 2.0G 1% /dev/shm
/dev/sda1 194M 35M 150M 19% /boot
/dev/mapper/vg_rootlhr-Vol01 3.0G 680M 2.2G 24% /tmp
/dev/mapper/vg_rootlhr-Vol03 3.0G 69M 2.8G 3% /home
.host:/331G 272G 59G 83% /mnt/hgfs
/dev/mapper/vg_mysqlsoft-lv_mysqlsoft_57 5.0G 138M 4.6G 3% /var/lib/mysql57
[root@LHRDB ~]#vi /etc/fstab
[root@LHRDB ~]#more /etc/fstab
# /etc/fstab
# 由anaconda 创建于2017 年1 月14 日星期六18:56:24
# 可访问的文件系统，通过引用，维护在“/dev/disk”下
# 有关更多信息，请参阅手册页fstab(5)、findfs(8)、mount(8) 和/或blkid(8)
/dev/mapper/vg_rootlhr-Vol00/ext4 默认1 1
UUID=fccf51c1-2d2f-4152-baac-99ead8cfbc1a /boot ext4 默认1 2
/dev/mapper/vg_rootlhr-Vol01 /tmp ext4 默认1 2
/dev/mapper/vg_rootlhr-Vol02 交换交换默认值0 0
tmpfs /dev/shm tmpfs 默认值，大小=2G 0 0
devpts /dev/pts devpts gid=5,mode=620 0 0
sysfs /sys sysfs 默认值0 0
proc /proc proc 默认0 0
/dev/vg_rootlhr/Vol03 /home ext4 默认0 0
/dev/mapper/vg_mysqlsoft-lv_mysqlsoft_57 /var/lib/mysql57 ext4 默认0 0
1.7.2.1操作系统设置
关闭iptables防火墙：
暂时关闭：服务iptables 停止
永久关闭：chkconfig iptables off
关闭selinux
vi /etc/sysconfig/selinux
将SELINUX改为DISABLED，即SELINUX=DISABLED
1.7.3 上传文件并验证MD5值
[root@LHRDB ~]# cd /tmp/mysql5719/
[root@LHRDB mysql5719]#ll
总计625640
-rw-r--r--。 1 root root 640650826 8月23日10:48 mysql-5.7.19-linux-glibc2.12-x86_64.tar.gz
[root@LHRDB mysql5719]#md5sum mysql-5.7.19-linux-glibc2.12-x86_64.tar.gz
dbe7e5e820377c29d8681005065e5728mysql-5.7.19-linux-glibc2.12-x86_64.tar.gz
与官网MD5一致，说明安装文件的下载和上传过程没有问题：
压缩的TAR 存档
5.7.19
611.0M
下载
(mysql-5.7.19-linux-glibc2.12-x86_64.tar.gz)
MD5:dbe7e5e820377c29d8681005065e5728|签名
1.7.4 安装
[root@LHRDB mysql5719]#tar -zxvf mysql-5.7.19-linux-glibc2.12-x86_64.tar.gz -C /var/lib/mysql57/
mysql-5.7.19-linux-glibc2.12-x86_64/bin/myisam_ftdump
mysql-5.7.19-linux-glibc2.12-x86_64/bin/myisamchk
mysql-5.7.19-linux-glibc2.12-x86_64/bin/myisamlog
mysql-5.7.19-linux-glibc2.12-x86_64/bin/myisampack
mysql-5.7.19-linux-glibc2.12-x86
_64/bin/mysql mysql-5.7.19-linux-glibc2.12-x86_64/bin/mysql_client_test_embedded mysql-5.7.19-linux-glibc2.12-x86_64/bin/mysql_config_editor mysql-5.7.19-linux-glibc2.12-x86_64/bin/mysql_embedded mysql-5.7.19-linux-glibc2.12-x86_64/bin/mysql_install_db mysql-5.7.19-linux-glibc2.12-x86_64/bin/mysql_plugin 。。。。。。。 省略部分。。。。。。。。 mysql-5.7.19-linux-glibc2.12-x86_64/lib/libmysqlclient.so.20 mysql-5.7.19-linux-glibc2.12-x86_64/lib/libmysqlclient.so.20.3.6 mysql-5.7.19-linux-glibc2.12-x86_64/share/install_rewriter.sql mysql-5.7.19-linux-glibc2.12-x86_64/share/uninstall_rewriter.sql mysql-5.7.19-linux-glibc2.12-x86_64/support-files/magic mysql-5.7.19-linux-glibc2.12-x86_64/support-files/mysql.server mysql-5.7.19-linux-glibc2.12-x86_64/docs/INFO_BIN mysql-5.7.19-linux-glibc2.12-x86_64/docs/INFO_SRC [root@LHRDB mysql5719]# df -h Filesystem Size Used Avail Use% Mounted on /dev/mapper/vg_rootlhr-Vol00 9.9G 4.9G 4.6G 52% / tmpfs 2.0G 72K 2.0G 1% /dev/shm /dev/sda1 194M 35M 150M 19% /boot /dev/mapper/vg_rootlhr-Vol01 3.0G 680M 2.2G 24% /tmp /dev/mapper/vg_rootlhr-Vol03 3.0G 69M 2.8G 3% /home .host:/ 331G 272G 59G 83% /mnt/hgfs /dev/mapper/vg_mysqlsoft-lv_mysqlsoft_57 5.0G 2.6G 2.2G 55% /var/lib/mysql57 1.7.5重命名安装后的文件夹 [root@LHRDB ~]# cd /var/lib/mysql57/ [root@LHRDB mysql57]# ll total 20 drwx------. 2 root root 16384 Aug 23 13:21 lost+found drwxr-xr-x. 9 root root 4096 Aug 23 13:28 mysql-5.7.19-linux-glibc2.12-x86_64 [root@LHRDB mysql57]#mv mysql-5.7.19-linux-glibc2.12-x86_64 mysql5719 [root@LHRDB mysql57]# ll total 20 drwx------. 2 root root 16384 Aug 23 13:21 lost+found drwxr-xr-x. 9 root root 4096 Aug 23 13:28 mysql5719 [root@LHRDB mysql57]# 也可以使用ln连接： ln –smysql-5.7.19-linux-glibc2.12-x86_64mysql5719 1.7.6新建数据和日志文件目录 [root@LHRDB mysql57]# mkdir -p /var/lib/mysql57/mysql5719/data [root@LHRDB mysql57]# mkdir -p /var/lib/mysql57/mysql5719/log 1.7.7用户和组设置 groupadd mysql ##添加一个mysql组 useradd -r -g mysql mysql ##添加一个用户 useradd -r -s /sbin/nologin -g mysql mysql -d /usr/local/mysql#新建msyql用户禁止登录shell [root@LHRDB ~]# groupadd mysql groupadd: group "mysql" already exists [root@LHRDB ~]# useradd -r -g mysql mysql useradd: user "mysql" already exists 说明本身就有mysql用户和组。 1.7.8改变目录属有者 [root@LHRDB mysql57]# chown –R mysql.mysql /var/lib/mysql57 chown: invalid user: `226R" [root@LHRDB mysql57]# cd .. [root@LHRDB lib]#chown –R mysql.mysql /var/lib/mysql57 1.7.9初始化MySQL 注意：MySQL5.7.6之后的版本初始化数据库不再使用mysql_install_db，但是在MySQL 5.7.19里依然保留着这个文件。 官网：https://dev.mysql.com/doc/refman/5.7/en/mysql-install-db.html mysql_install_dbis deprecated as of MySQL 5.7.6 because its functionality has been integrated intomysqld, the MySQL server. To initialize a MySQL installation, invokemysqldwith the--initializeor--initialize-insecureoption. For more information, seeSection2.10.1.1, “Initializing the Data Directory Manually Using mysqld”.mysql_install_dbwill be removed in a future MySQL release. [root@LHRDB mysql5719]# ll total 60 drwxr-xr-x. 2 mysql mysql 4096 Aug 23 13:27 bin -rw-r--r--. 1 mysql mysql 17987 Jun 22 22:13 COPYING drwxr-xr-x. 2 mysql mysql 4096 Aug 23 13:35 data drwxr-xr-x. 2 mysql mysql 4096 Aug 23 13:28 docs drwxr-xr-x. 3 mysql mysql 4096 Aug 23 13:27 include drwxr-xr-x. 5 mysql mysql 4096 Aug 23 13:28 lib drwxr-xr-x. 2 mysql mysql 4096 Aug 23 13:35 log drwxr-xr-x. 4 mysql mysql 4096 Aug 23 13:27 man -rw-r--r--. 1 mysql mysql 2478 Jun 22 22:13 README drwxr-xr-x. 28 mysql mysql 4096 Aug 23 13:28 share drwxr-xr-x. 2 mysql mysql 4096 Aug 23 13:28 support-files [root@LHRDB mysql5719]#./bin/mysqld --initialize --user=mysql --basedir=/var/lib/mysql57/mysql5719 --datadir=/var/lib/mysql57/mysql5719/data 2017-08-23T05:45:58.820448Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2017-08-23T05:45:59.123446Z 0 [Warning] InnoDB: New log files created, LSN=45790 2017-08-23T05:45:59.197904Z 0 [Warning] InnoDB: Creating foreign key constraint system tables. 2017-08-23T05:45:59.273227Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 571ab53c-87c6-11e7-ab76-000c291823c2. 2017-08-23T05:45:59.276384Z 0 [Warning] Gtid table is not ready to be used. Table "mysql.gtid_executed" cannot be opened. 2017-08-23T05:45:59.277461Z 1 [Note] A temporary password is generated for root@localhost:k;A3Dktywkyj [root@LHRDB mysql5719]# 这里生成的临时密码为：k;A3Dktywkyj 该过程会在data目录下生成默认数据库： [root@LHRDB mysql5719]# cd data [root@LHRDB data]# ll total 110620 -rw-r-----. 1 mysql mysql 56 Aug 23 13:45 auto.cnf -rw-r-----. 1 mysql mysql 420 Aug 23 13:46 ib_buffer_pool -rw-r-----. 1 mysql mysql 12582912 Aug 23 13:46 ibdata1 -rw-r-----. 1 mysql mysql 50331648 Aug 23 13:46 ib_logfile0 -rw-r-----. 1 mysql mysql 50331648 Aug 23 13:45 ib_logfile1 drwxr-x---. 2 mysql mysql 4096 Aug 23 13:45 mysql drwxr-x---. 2 mysql mysql 4096 Aug 23 13:45 performance_schema drwxr-x---. 2 mysql mysql 12288 Aug 23 13:46 sys [root@LHRDB data]# du -sh . 122M . 1.7.10生成秘钥 创建SSL和RSA文件，关于这部分更多请参考：https://dev.mysql.com/doc/refman/5.7/en/mysql-ssl-rsa-setup.html。也可以不执行这个步骤。 [root@LHRDB mysql5719]#./bin/mysql_ssl_rsa_setup --datadir=/var/lib/mysql57/mysql5719/data Generating a 2048 bit RSA private key ................................................................................................................+++ ............................+++ writing new private key to "ca-key.pem" Generating a 2048 bit RSA private key ......................................+++ .................+++ writing new private key to "server-key.pem" Generating a 2048 bit RSA private key ........................+++ .................................................................+++ writing new private key to "client-key.pem" 1.7.11配置/etc/my.cnf 生产库上根据需要配置更多参数： [root@LHRDB support-files]# more /etc/my.cnf [client] port=3306 socket=/var/lib/mysql57/mysql.sock [mysqld] basedir=/var/lib/mysql57/mysql5719 datadir=/var/lib/mysql57/mysql5719/data socket=/var/lib/mysql57/mysql.sock user=mysql # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 [mysqld_safe] log-error=/var/lib/mysql57/mysql5719/log/mysqld.log pid-file=/var/lib/mysql57/mysql5719/data/mysqld.pid 1.7.12配置开机启动文件 [root@LHRDB mysql5719]# cd support-files/ [root@LHRDB support-files]# ll total 24 -rw-r--r--. 1 mysql mysql 773 Jun 22 22:13 magic -rwxr-xr-x. 1 mysql mysql 1061 Jun 22 22:54 mysqld_multi.server -rwxr-xr-x. 1 mysql mysql 894 Jun 22 22:54 mysql-log-rotate -rwxr-xr-x. 1 mysql mysql 10576 Jun 22 22:54 mysql.server [root@LHRDB support-files]#cp mysql.server /etc/init.d/mysql57 [root@LHRDB support-files]#chmod 755 /etc/init.d/mysql57 [root@LHRDB support-files]#chkconfig --add mysql57 [root@LHRDB support-files]#chkconfig mysql57on [root@LHRDB support-files]#chkconfig --level 345 mysql57on 注意：这里的MySQL服务为mysql57 1.7.13启动MySQL [root@LHRDB support-files]# service mysql57start Starting MySQL.2017-08-23T06:18:23.060126Z mysqld_safe error: log-error set to "/var/lib/mysql57/mysql5719/log/mysqld.log", however file don"t exists. Create writable for user "mysql". The server quit without updating PID file (/var/lib/mysql57/mysql5719/data/LHRDB.pid).[FAILED] [root@LHRDB support-files]# cd /var/lib/mysql57/mysql5719/log/ [root@LHRDB log]# ll total 0 [root@LHRDB log]# cd .. [root@LHRDB mysql5719]# ll total 60 drwxr-xr-x. 2 mysql mysql 4096 Aug 23 13:27 bin -rw-r--r--. 1 mysql mysql 17987 Jun 22 22:13 COPYING drwxr-xr-x. 5 mysql mysql 4096 Aug 23 13:46 data drwxr-xr-x. 2 mysql mysql 4096 Aug 23 13:28 docs drwxr-xr-x. 3 mysql mysql 4096 Aug 23 13:27 include drwxr-xr-x. 5 mysql mysql 4096 Aug 23 13:28 lib drwxr-xr-x. 2 mysql mysql 4096 Aug 23 13:35 log drwxr-xr-x. 4 mysql mysql 4096 Aug 23 13:27 man -rw-r--r--. 1 mysql mysql 2478 Jun 22 22:13 README drwxr-xr-x. 28 mysql mysql 4096 Aug 23 13:28 share drwxr-xr-x. 2 mysql mysql 4096 Aug 23 13:28 support-files [root@LHRDB mysql5719]#echo "" >/var/lib/mysql57/mysql5719/log/mysqld.log [root@LHRDB mysql5719]#chown mysql.mysql /var/lib/mysql57/mysql5719/log/mysqld.log [root@LHRDB mysql5719]#service mysql57start Starting MySQL.[ OK ] [root@LHRDB mysql5719]# ps -ef|grep mysql root 18194 1 0 14:20 pts/1 00:00:00 /bin/sh /var/lib/mysql57/mysql5719/bin/mysqld_safe --datadir=/var/lib/mysql57/mysql5719/data --pid-file=/var/lib/mysql57/mysql5719/data/LHRDB.pid mysql 18370 18194 0 14:20 pts/1 00:00:00 /var/lib/mysql57/mysql5719/bin/mysqld --basedir=/var/lib/mysql57/mysql5719 --datadir=/var/lib/mysql57/mysql5719/data --plugin-dir=/var/lib/mysql57/mysql5719/lib/plugin --user=mysql --log-error=/var/lib/mysql57/mysql5719/log/mysqld.log --pid-file=/var/lib/mysql57/mysql5719/data/LHRDB.pid --socket=/var/lib/mysql57/mysql.sock root 18407 13196 0 14:21 pts/1 00:00:00 grep mysql [root@LHRDB mysql5719]# 或者： [root@LHRDB ~]# which mysqld_safe /var/lib/mysql57/mysql5719/bin/mysqld_safe [root@LHRDB ~]#mysqld_safe --user=mysql & [1] 18674 [root@LHRDB ~]# 2017-08-23T06:40:04.996137Z mysqld_safe Logging to "/var/lib/mysql57/mysql5719/log/mysqld.log". 2017-08-23T06:40:05.053483Z mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql57/mysql5719/data 1.7.14配置环境变量 编辑文件/etc/profile，在最后添加如下的内容： MYSQL_HOME=/var/lib/mysql57/mysql5719 PATH=$PATH:$MYSQL_HOME/bin 让环境变量生效：source /etc/profile 1.7.15登录MySQL并修改密码 [root@LHRDB ~]# mysql -p Enter password:---》临时密码为：k;A3Dktywkyj Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 3 Server version: 5.7.19 Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type "help;" or "h" for help. Type "c" to clear the current input statement. mysql> mysql>show databases; ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement. mysql>set password=password("lhr"); Query OK, 0 rows affected, 1 warning (0.02 sec) mysql>show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | sys | +--------------------+ 4 rows in set (0.04 sec) 修改密码也可以用：update mysql.user set authentication_string=password("lhr") where user="root"; 1.7.16设置远程登录 mysql>grant all privileges on *.* to root@"%" identified by "lhr"; Query OK, 0 rows affected, 1 warning (0.00 sec) mysql>flush privileges; Query OK, 0 rows affected (0.00 sec) mysql>select host,user from mysql.user; +-----------+---------------+ | host | user | +-----------+---------------+ | % | root | | localhost | mysql.session | | localhost | mysql.sys | | localhost | root | +-----------+---------------+ 4 rows in set (0.00 sec) [root@LHRDB ~]#mysql -uroot -plhr -h192.168.59.159 mysql: [Warning] Using a password on the command line interface can be insecure. Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 4 Server version: 5.7.19 MySQL Community Server (GPL) Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type "help;" or "h" for help. Type "c" to clear the current input statement. mysql> 1.7.17Windows远程登录 在Windows下远程登录： D:Usersxiaomaimiao>mysql -uroot -plhr -h192.168.59.159 Warning: Using a password on the command line interface can be insecure. Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 6 Server version: 5.7.19 MySQL Community Server (GPL) Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type "help;" or "h" for help. Type "c" to clear the current input statement. mysql> 可能会出现下面的错误： D:Usersxiaomaimiao>mysql -uroot -plhr -h192.168.59.159 Warning: Using a password on the command line interface can be insecure. ERROR 2003 (HY000): Can"t connect to MySQL server on "192.168.59.159" (10060) 原因：主机192.168.59.159上的防火墙未关闭 解决办法：关闭防火墙，以下2个命令都需要执行： chkconfig iptables off ---永久 service iptables stop ---临时 1.7.18客户端工具登录 1.7.18.1Navicat for MySQL 1.7.18.2MySQLWorkbench MySQL官方提供的工具，还是比较实用的： 该工具比较强大，有很多的实用功能： 1.8MySQL 5.6安装 1.8.1下载 1.8.2OS路径设置 [root@LHRDB ~]# df -h Filesystem Size Used Avail Use% Mounted on /dev/mapper/vg_rootlhr-Vol00 9.9G 4.8G 4.6G 51% / tmpfs 2.0G 72K 2.0G 1% /dev/shm /dev/sda1 194M 35M 150M 19% /boot /dev/mapper/vg_rootlhr-Vol01 3.0G 681M 2.2G 24% /tmp /dev/mapper/vg_rootlhr-Vol03 3.0G 69M 2.8G 3% /home /dev/mapper/vg_mysqlsoft-lv_mysqlsoft_57 5.0G 2.7G 2.0G 58% /var/lib/mysql57 .host:/ 331G 272G 59G 83% /mnt/hgfs [root@LHRDB ~]# vgs VG #PV #LV #SN Attr VSize VFree vg_mysqlsoft 1 1 0 wz--n- 10.00g 5.00g vg_rootlhr 2 4 0 wz--n- 19.80g 1.80g [root@LHRDB ~]#lvcreate -n lv_mysqlsoft_56 -L 2G vg_mysqlsoft Logical volume "lv_mysqlsoft_56" created [root@LHRDB ~]#mkfs.ext4 /dev/vg_mysqlsoft/lv_mysqlsoft_56 mke2fs 1.41.12 (17-May-2010) Filesystem label= OS type: Linux Block size=4096 (log=2) Fragment size=4096 (log=2) Stride=0 blocks, Stripe width=0 blocks 131072 inodes, 524288 blocks 26214 blocks (5.00%) reserved for the super user First data block=0 Maximum filesystem blocks=536870912 16 block groups 32768 blocks per group, 32768 fragments per group 8192 inodes per group Superblock backups stored on blocks: 32768, 98304, 163840, 229376, 294912 Writing inode tables: done Creating journal (16384 blocks): done Writing superblocks and filesystem accounting information: done This filesystem will be automatically checked every 36 mounts or 180 days, whichever comes first. Use tune2fs -c or -i to override. [root@LHRDB ~]# cd /usr/local/mysql -bash: cd: /usr/local/mysql: No such file or directory [root@LHRDB ~]# mkdir /usr/local/mysql56 [root@LHRDB ~]# chown mysql /usr/local/mysql56 [root@LHRDB ~]# mount /dev/vg_mysqlsoft/lv_mysqlsoft_56 /usr/local/mysql56/ [root@LHRDB ~]# df -h Filesystem Size Used Avail Use% Mounted on /dev/mapper/vg_rootlhr-Vol00 9.9G 4.8G 4.6G 51% / tmpfs 2.0G 72K 2.0G 1% /dev/shm /dev/sda1 194M 35M 150M 19% /boot /dev/mapper/vg_rootlhr-Vol01 3.0G 681M 2.2G 24% /tmp /dev/mapper/vg_rootlhr-Vol03 3.0G 69M 2.8G 3% /home /dev/mapper/vg_mysqlsoft-lv_mysqlsoft_57 5.0G 2.7G 2.0G 58% /var/lib/mysql57 .host:/ 331G 272G 59G 83% /mnt/hgfs /dev/mapper/vg_mysqlsoft-lv_mysqlsoft_56 2.0G 67M 1.9G 4% /usr/local/mysql56 1.8.3安装MySQL 5.6 rpm的安装方式请参考： http://blog.itpub.net/26736162/viewspace-1349705/ http://blog.itpub.net/26736162/viewspace-1349787/ [root@LHRDB mysql56]#tar -zxvf /tmp/mysql-5.6.37-linux-glibc2.12-x86_64.tar.gz -C /usr/local/mysql56/ mysql-5.6.37-linux-glibc2.12-x86_64/sql-bench/test-ATIS mysql-5.6.37-linux-glibc2.12-x86_64/sql-bench/test-select mysql-5.6.37-linux-glibc2.12-x86_64/sql-bench/crash-me mysql-5.6.37-linux-glibc2.12-x86_64/sql-bench/test-wisconsin mysql-5.6.37-linux-glibc2.12-x86_64/sql-bench/innotest1b mysql-5.6.37-linux-glibc2.12-x86_64/sql-bench/innotest2a mysql-5.6.37-linux-glibc2.12-x86_64/sql-bench/innotest1 mysql-5.6.37-linux-glibc2.12-x86_64/sql-bench/test-create mysql-5.6.37-linux-glibc2.12-x86_64/sql-bench/bench-count-distinct 。。。。。。。。。。。。省略。。。。。。。。。。。。。。 mysql-5.6.37-linux-glibc2.12-x86_64/mysql-test/t/events_restart-master.opt mysql-5.6.37-linux-glibc2.12-x86_64/mysql-test/t/empty_table.test mysql-5.6.37-linux-glibc2.12-x86_64/mysql-test/t/innodb_mrr-master.opt mysql-5.6.37-linux-glibc2.12-x86_64/mysql-test/t/ssl_mode_no_ssl-master.opt mysql-5.6.37-linux-glibc2.12-x86_64/mysql-test/valgrind.supp mysql-5.6.37-linux-glibc2.12-x86_64/mysql-test/mysql-test-run.pl [root@LHRDB mysql56]# mv mysql-5.6.37-linux-glibc2.12-x86_64 mysql5637 [root@LHRDB mysql56]# cd mysql5637/ [root@LHRDB mysql5637]# ll total 68 drwxr-xr-x 2 mysql mysql 4096 Aug 25 18:24 bin -rw-r--r-- 1 mysql mysql 17987 Jun 3 01:42 COPYING drwxr-xr-x 3 mysql mysql 4096 Aug 25 18:24 data drwxr-xr-x 2 mysql mysql 4096 Aug 25 18:24 docs drwxr-xr-x 3 mysql mysql 4096 Aug 25 18:24 include drwxr-xr-x 3 mysql mysql 4096 Aug 25 18:24 lib drwxr-xr-x 4 mysql mysql 4096 Aug 25 18:24 man drwxr-xr-x 10 mysql mysql 4096 Aug 25 18:24 mysql-test -rw-r--r-- 1 mysql mysql 2496 Jun 3 01:42 README drwxr-xr-x 2 mysql mysql 4096 Aug 25 18:24 scripts drwxr-xr-x 28 mysql mysql 4096 Aug 25 18:24 share drwxr-xr-x 4 mysql mysql 4096 Aug 25 18:24 sql-bench drwxr-xr-x 2 mysql mysql 4096 Aug 25 18:24 support-files [root@LHRDB mysql5637]# mkdir log [root@LHRDB mysql5637]# chown mysql.mysql log [root@LHRDB mysql5637]# ll total 72 drwxr-xr-x 2 mysql mysql 4096 Aug 25 18:24 bin -rw-r--r-- 1 mysql mysql 17987 Jun 3 01:42 COPYING drwxr-xr-x 3 mysql mysql 4096 Aug 25 18:24 data drwxr-xr-x 2 mysql mysql 4096 Aug 25 18:24 docs drwxr-xr-x 3 mysql mysql 4096 Aug 25 18:24 include drwxr-xr-x 3 mysql mysql 4096 Aug 25 18:24 lib drwxr-xr-x 2 mysql mysql 4096 Aug 25 18:32 log drwxr-xr-x 4 mysql mysql 4096 Aug 25 18:24 man drwxr-xr-x 10 mysql mysql 4096 Aug 25 18:24 mysql-test -rw-r--r-- 1 mysql mysql 2496 Jun 3 01:42 README drwxr-xr-x 2 mysql mysql 4096 Aug 25 18:24 scripts drwxr-xr-x 28 mysql mysql 4096 Aug 25 18:24 share drwxr-xr-x 4 mysql mysql 4096 Aug 25 18:24 sql-bench drwxr-xr-x 2 mysql mysql 4096 Aug 25 18:24 support-files 1.8.4初始化 [root@LHRDB mysql5637]#./scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql56/mysql5637 --datadir=/usr/local/mysql56/mysql5637/data Installing MySQL system tables...2017-08-25 18:37:13 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2017-08-25 18:37:13 0 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap. 2017-08-25 18:37:13 0 [Note] /usr/local/mysql56/mysql5637/bin/mysqld (mysqld 5.6.37) starting as process 17757 ... 2017-08-25 18:37:13 17757 [Note] InnoDB: Using atomics to ref count buffer pool pages 2017-08-25 18:37:13 17757 [Note] InnoDB: The InnoDB memory heap is disabled 2017-08-25 18:37:13 17757 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-08-25 18:37:13 17757 [Note] InnoDB: Memory barrier is not used 2017-08-25 18:37:13 17757 [Note] InnoDB: Compressed tables use zlib 1.2.3 2017-08-25 18:37:13 17757 [Note] InnoDB: Using Linux native AIO 2017-08-25 18:37:13 17757 [Note] InnoDB: Using CPU crc32 instructions 2017-08-25 18:37:13 17757 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2017-08-25 18:37:13 17757 [Note] InnoDB: Completed initialization of buffer pool 2017-08-25 18:37:13 17757 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created! 2017-08-25 18:37:13 17757 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB 2017-08-25 18:37:13 17757 [Note] InnoDB: Database physically writes the file full: wait... 2017-08-25 18:37:13 17757 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB 2017-08-25 18:37:13 17757 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB 2017-08-25 18:37:13 17757 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2017-08-25 18:37:13 17757 [Warning] InnoDB: New log files created, LSN=45781 2017-08-25 18:37:13 17757 [Note] InnoDB: Doublewrite buffer not found: creating new 2017-08-25 18:37:13 17757 [Note] InnoDB: Doublewrite buffer created 2017-08-25 18:37:13 17757 [Note] InnoDB: 128 rollback segment(s) are active. 2017-08-25 18:37:13 17757 [Warning] InnoDB: Creating foreign key constraint system tables. 2017-08-25 18:37:13 17757 [Note] InnoDB: Foreign key constraint system tables created 2017-08-25 18:37:13 17757 [Note] InnoDB: Creating tablespace and datafile system tables. 2017-08-25 18:37:13 17757 [Note] InnoDB: Tablespace and datafile system tables created. 2017-08-25 18:37:13 17757 [Note] InnoDB: Waiting for purge to start 2017-08-25 18:37:13 17757 [Note] InnoDB: 5.6.37 started; log sequence number 0 2017-08-25 18:37:14 17757 [Note] Binlog end 2017-08-25 18:37:14 17757 [Note] InnoDB: FTS optimize thread exiting. 2017-08-25 18:37:14 17757 [Note] InnoDB: Starting shutdown... 2017-08-25 18:37:15 17757 [Note] InnoDB: Shutdown completed; log sequence number 1625977 OK Filling help tables...2017-08-25 18:37:15 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2017-08-25 18:37:15 0 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap. 2017-08-25 18:37:15 0 [Note] /usr/local/mysql56/mysql5637/bin/mysqld (mysqld 5.6.37) starting as process 17779 ... 2017-08-25 18:37:15 17779 [Note] InnoDB: Using atomics to ref count buffer pool pages 2017-08-25 18:37:15 17779 [Note] InnoDB: The InnoDB memory heap is disabled 2017-08-25 18:37:15 17779 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-08-25 18:37:15 17779 [Note] InnoDB: Memory barrier is not used 2017-08-25 18:37:15 17779 [Note] InnoDB: Compressed tables use zlib 1.2.3 2017-08-25 18:37:15 17779 [Note] InnoDB: Using Linux native AIO 2017-08-25 18:37:15 17779 [Note] InnoDB: Using CPU crc32 instructions 2017-08-25 18:37:15 17779 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2017-08-25 18:37:15 17779 [Note] InnoDB: Completed initialization of buffer pool 2017-08-25 18:37:15 17779 [Note] InnoDB: Highest supported file format is Barracuda. 2017-08-25 18:37:15 17779 [Note] InnoDB: 128 rollback segment(s) are active. 2017-08-25 18:37:15 17779 [Note] InnoDB: Waiting for purge to start 2017-08-25 18:37:15 17779 [Note] InnoDB: 5.6.37 started; log sequence number 1625977 2017-08-25 18:37:15 17779 [Note] Binlog end 2017-08-25 18:37:15 17779 [Note] InnoDB: FTS optimize thread exiting. 2017-08-25 18:37:15 17779 [Note] InnoDB: Starting shutdown... 2017-08-25 18:37:17 17779 [Note] InnoDB: Shutdown completed; log sequence number 1625987 OK To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! To do so, start the server, then issue the following commands: /usr/local/mysql56/mysql5637/bin/mysqladmin -u root password "new-password" /usr/local/mysql56/mysql5637/bin/mysqladmin -u root -h LHRDB password "new-password" Alternatively you can run: /usr/local/mysql56/mysql5637/bin/mysql_secure_installation which will also give you the option of removing the test databases and anonymous user created by default. This is strongly recommended for production servers. See the manual for more instructions. You can start the MySQL daemon with: cd . ; /usr/local/mysql56/mysql5637/bin/mysqld_safe & You can test the MySQL daemon with mysql-test-run.pl cd mysql-test ; perl mysql-test-run.pl Please report any problems at http://bugs.mysql.com/ The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at http://shop.mysql.com New default config file was created as/usr/local/mysql56/mysql5637/my.cnfand will be used by default by the server when you start it. You may edit this file to change server settings WARNING: Default config file /etc/my.cnf exists on the system This file will be read by default by the MySQL server If you do not want to use this, either remove it, or use the --defaults-file argument to mysqld_safe when starting the server [root@LHRDB mysql5637]# cd data [root@LHRDB data]# ll total 110604 -rw-rw---- 1 mysql mysql 12582912 Aug 25 18:37 ibdata1 -rw-rw---- 1 mysql mysql 50331648 Aug 25 18:37 ib_logfile0 -rw-rw---- 1 mysql mysql 50331648 Aug 25 18:37 ib_logfile1 drwx------ 2 mysql mysql 4096 Aug 25 18:37 mysql drwx------ 2 mysql mysql 4096 Aug 25 18:37 performance_schema drwxr-xr-x 2 mysql mysql 4096 Aug 25 18:24 test 1.8.5配置参数文件并启动MySQL [root@LHRDB mysql5637]# more ./support-files/my.cnf [mysqld] basedir=/usr/local/mysql56/mysql5637 datadir=/usr/local/mysql56/mysql5637/data socket=/usr/local/mysql56/mysql5637/mysql.sock log-error=/usr/local/mysql56/mysql5637/log/mysqld.log user=mysql port=3307 [root@LHRDB mysql5637]# echo "" >/usr/local/mysql56/mysql5637/log/mysqld.log [root@LHRDB mysql5637]#./bin/mysqld_safe --defaults-file=./support-files/my.cnf & [2] 13852 [root@LHRDB mysql5637]# 170827 17:52:15 mysqld_safe Logging to "/usr/local/mysql56/mysql5637/log/mysqld.log". 170827 17:52:15 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql56/mysql5637/data [root@LHRDB mysql5637]# ps -ef|grep mysql root 13195 13170 0 17:35 pts/0 00:00:00 tail -f /var/lib/mysql57/mysql5719/log/mysqld_multi.log root 13671 13198 0 17:45 pts/1 00:00:00 /bin/sh ./bin/mysqld_safe --defaults-file=./support-files/my.cnf mysql 13811 13671 0 17:45 pts/1 00:00:00 /usr/local/mysql55/mysql5557/bin/mysqld --defaults-file=./support-files/my.cnf --basedir=/usr/local/mysql55/mysql5557 --datadir=/usr/local/mysql55/mysql5557/data --plugin-dir=/usr/local/mysql55/mysql5557/lib/plugin --user=mysql --log-error=/usr/local/mysql55/mysql5557/log/mysqld.log --pid-file=LHRDB.pid --socket=/usr/local/mysql55/mysql5557/mysql.sock --port=3308 root 13852 13198 0 17:52 pts/1 00:00:00 /bin/sh ./bin/mysqld_safe --defaults-file=./support-files/my.cnf mysql 13990 13852 10 17:52 pts/1 00:00:00 /usr/local/mysql56/mysql5637/bin/mysqld --defaults-file=./support-files/my.cnf --basedir=/usr/local/mysql56/mysql5637 --datadir=/usr/local/mysql56/mysql5637/data --plugin-dir=/usr/local/mysql56/mysql5637/lib/plugin --user=mysql --log-error=/usr/local/mysql56/mysql5637/log/mysqld.log --pid-file=LHRDB.pid --socket=/usr/local/mysql56/mysql5637/mysql.sock --port=3307 root 14015 13198 0 17:52 pts/1 00:00:00 grep mysql 1.8.6修改密码 MySQL 5.6的二进制安装默认密码为空。 set password=password("lhr"); [root@LHRDB mysql5719]#mysql -uroot --socket=/usr/local/mysql56/mysql5637/mysql.sock -p Enter password: Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 4 Server version: 5.6.37 MySQL Community Server (GPL) Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type "help;" or "h" for help. Type "c" to clear the current input statement. mysql>set password=password("lhr"); Query OK, 0 rows affected (0.02 sec) mysql>show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | test | +--------------------+ 4 rows in set (0.00 sec) 1.8.7设置远程登录 mysql>select host,user from mysql.user; +-----------+------+ | host | user | +-----------+------+ | 127.0.0.1 | root | | ::1 | root | | lhrdb | | | lhrdb | root | | localhost | | | localhost | root | +-----------+------+ 6 rows in set (0.00 sec) mysql>grant all privileges on *.* to root@"%" identified by "lhr"; Query OK, 0 rows affected, 1 warning (0.00 sec) mysql>flush privileges; Query OK, 0 rows affected (0.00 sec) mysql>select host,user from mysql.user; +-----------+------+ | host | user | +-----------+------+ | % | root | | 127.0.0.1 | root | | ::1 | root | | lhrdb | | | lhrdb | root | | localhost | | | localhost | root | +-----------+------+ 1.8.8远程登录 D:Usersxiaomaimiao>mysql -uroot -plhr -h192.168.59.159 -P 3307 Warning: Using a password on the command line interface can be insecure. Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 6 Server version: 5.6.37 MySQL Community Server (GPL) Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type "help;" or "h" for help. Type "c" to clear the current input statement. mysql> 1.9MySQL 5.5安装 1.9.1下载 1.9.2OS路径设置 [root@LHRDB ~]#lvcreate -n lv_mysqlsoft_55 -L 2G vg_mysqlsoft Logical volume "lv_mysqlsoft_55" created [root@LHRDB ~]#mkfs.ext4 /dev/vg_mysqlsoft/lv_mysqlsoft_55 mke2fs 1.41.12 (17-May-2010) Filesystem label= OS type: Linux Block size=4096 (log=2) Fragment size=4096 (log=2) Stride=0 blocks, Stripe width=0 blocks 131072 inodes, 524288 blocks 26214 blocks (5.00%) reserved for the super user First data block=0 Maximum filesystem blocks=536870912 16 block groups 32768 blocks per group, 32768 fragments per group 8192 inodes per group Superblock backups stored on blocks: 32768, 98304, 163840, 229376, 294912 Writing inode tables: done Creating journal (16384 blocks): done Writing superblocks and filesystem accounting information: done This filesystem will be automatically checked every 24 mounts or 180 days, whichever comes first. Use tune2fs -c or -i to override. [root@LHRDB ~]# mkdir /usr/local/mysql55 [root@LHRDB ~]# chown mysql /usr/local/mysql55 [root@LHRDB ~]# mount /dev/vg_mysqlsoft/lv_mysqlsoft_55 /usr/local/mysql55/ [root@LHRDB ~]# df -h Filesystem Size Used Avail Use% Mounted on /dev/mapper/vg_rootlhr-Vol00 9.9G 4.8G 4.6G 52% / tmpfs 2.0G 68K 2.0G 1% /dev/shm /dev/sda1 194M 35M 150M 19% /boot /dev/mapper/vg_rootlhr-Vol01 3.0G 1.1G 1.8G 40% /tmp /dev/mapper/vg_rootlhr-Vol03 3.0G 69M 2.8G 3% /home /dev/mapper/vg_mysqlsoft-lv_mysqlsoft_57 5.0G 2.7G 2.0G 58% /var/lib/mysql57 .host:/ 331G 272G 59G 83% /mnt/hgfs /dev/mapper/vg_mysqlsoft-lv_mysqlsoft_56 2.0G 67M 1.9G 4% /usr/local/mysql56 /dev/mapper/vg_mysqlsoft-lv_mysqlsoft_55 2.0G 67M 1.9G 4% /usr/local/mysql55 1.9.3安装MySQL 5.5 [root@LHRDB mysql56]#tar -zxvf /tmp/mysql-5.5.57-linux-glibc2.12-x86_64.tar.gz -C /usr/local/mysql55 mysql-5.5.57-linux-glibc2.12-x86_64/scripts/mysql_install_db mysql-5.5.57-linux-glibc2.12-x86_64/INSTALL-BINARY mysql-5.5.57-linux-glibc2.12-x86_64/share/slovak/errmsg.sys mysql-5.5.57-linux-glibc2.12-x86_64/share/norwegian/errmsg.sys mysql-5.5.57-linux-glibc2.12-x86_64/share/fill_help_tables.sql mysql-5.5.57-linux-glibc2.12-x86_64/share/spanish/errmsg.sys mysql-5.5.57-linux-glibc2.12-x86_64/share/czech/errmsg.sys mysql-5.5.57-linux-glibc2.12-x86_64/share/dutch/errmsg.sys 。。。。。。。。。。。。省略。。。。。。。。。。。。。。 mysql-5.5.57-linux-glibc2.12-x86_64/mysql-test/suite/auth_sec/t/secure_file_priv_null-master.opt mysql-5.5.57-linux-glibc2.12-x86_64/mysql-test/suite/auth_sec/t/secure_file_priv_warnings_win.test mysql-5.5.57-linux-glibc2.12-x86_64/mysql-test/suite/auth_sec/t/secure_file_priv_error.test mysql-5.5.57-linux-glibc2.12-x86_64/mysql-test/suite/auth_sec/t/secure_file_priv_null.test mysql-5.5.57-linux-glibc2.12-x86_64/mysql-test/suite/auth_sec/t/secure_file_priv_warnings.test mysql-5.5.57-linux-glibc2.12-x86_64/mysql-test/suite/auth_sec/r/secure_file_priv_warnings.result mysql-5.5.57-linux-glibc2.12-x86_64/mysql-test/suite/auth_sec/r/secure_file_priv_error.result mysql-5.5.57-linux-glibc2.12-x86_64/mysql-test/suite/auth_sec/r/secure_file_priv_warnings_win.result mysql-5.5.57-linux-glibc2.12-x86_64/mysql-test/suite/auth_sec/r/secure_file_priv_null.result mysql-5.5.57-linux-glibc2.12-x86_64/mysql-test/suite/auth_sec/r/cert_verify.result mysql-5.5.57-linux-glibc2.12-x86_64/mysql-test/suite/auth_sec/r/secure_file_priv_warnings_not_win.result [root@LHRDB tmp]# cd /usr/local/mysql55 [root@LHRDB mysql55]# ll total 4 drwxr-xr-x 13 root root 4096 Aug 27 17:07 mysql-5.5.57-linux-glibc2.12-x86_64 [root@LHRDB mysql55]# [root@LHRDB mysql55]#mv mysql-5.5.57-linux-glibc2.12-x86_64 mysql5557 [root@LHRDB mysql55]# cd mysql5557/ [root@LHRDB mysql5557]# ll total 72 drwxr-xr-x 2 root root 4096 Aug 27 17:07 bin -rw-r--r-- 1 7161 31415 17987 Jun 5 14:38 COPYING drwxr-xr-x 3 root root 4096 Aug 27 17:07 data drwxr-xr-x 2 root root 4096 Aug 27 17:07 docs drwxr-xr-x 3 root root 4096 Aug 27 17:07 include -rw-r--r-- 1 7161 31415 301 Jun 5 14:38 INSTALL-BINARY drwxr-xr-x 3 root root 4096 Aug 27 17:07 lib drwxr-xr-x 4 root root 4096 Aug 27 17:07 man drwxr-xr-x 10 root root 4096 Aug 27 17:07 mysql-test -rw-r--r-- 1 7161 31415 2496 Jun 5 14:38 README drwxr-xr-x 2 root root 4096 Aug 27 17:07 scripts drwxr-xr-x 27 root root 4096 Aug 27 17:07 share drwxr-xr-x 4 root root 4096 Aug 27 17:07 sql-bench drwxr-xr-x 2 root root 4096 Aug 27 17:07 support-files [root@LHRDB mysql5557]# mkdir log [root@LHRDB mysql5557]# cd .. [root@LHRDB mysql55]# chown mysql.mysql . [root@LHRDB mysql55]# chown -R mysql.mysql . 1.9.4初始化 [root@LHRDB mysql5557]# ll total 76 drwxr-xr-x 2 mysql mysql 4096 Aug 27 17:07 bin -rw-r--r-- 1 mysql mysql 17987 Jun 5 14:38 COPYING drwxr-xr-x 3 mysql mysql 4096 Aug 27 17:07 data drwxr-xr-x 2 mysql mysql 4096 Aug 27 17:07 docs drwxr-xr-x 3 mysql mysql 4096 Aug 27 17:07 include -rw-r--r-- 1 mysql mysql 301 Jun 5 14:38 INSTALL-BINARY drwxr-xr-x 3 mysql mysql 4096 Aug 27 17:07 lib drwxr-xr-x 2 mysql mysql 4096 Aug 27 17:10 log drwxr-xr-x 4 mysql mysql 4096 Aug 27 17:07 man drwxr-xr-x 10 mysql mysql 4096 Aug 27 17:07 mysql-test -rw-r--r-- 1 mysql mysql 2496 Jun 5 14:38 README drwxr-xr-x 2 mysql mysql 4096 Aug 27 17:07 scripts drwxr-xr-x 27 mysql mysql 4096 Aug 27 17:07 share drwxr-xr-x 4 mysql mysql 4096 Aug 27 17:07 sql-bench drwxr-xr-x 2 mysql mysql 4096 Aug 27 17:07 support-files [root@LHRDB mysql5557]# pwd /usr/local/mysql55/mysql5557 [root@LHRDB mysql5557]#./scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql55/mysql5557 --datadir=/usr/local/mysql55/mysql5557/data Installing MySQL system tables... 170827 17:12:09 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap. 170827 17:12:09 [Note] /usr/local/mysql55/mysql5557/bin/mysqld (mysqld 5.5.57) starting as process 19995 ... OK Filling help tables... 170827 17:12:10 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap. 170827 17:12:10 [Note] /usr/local/mysql55/mysql5557/bin/mysqld (mysqld 5.5.57) starting as process 20002 ... OK To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! To do so, start the server, then issue the following commands: /usr/local/mysql55/mysql5557/bin/mysqladmin -u root password "new-password" /usr/local/mysql55/mysql5557/bin/mysqladmin -u root -h LHRDB password "new-password" Alternatively you can run: /usr/local/mysql55/mysql5557/bin/mysql_secure_installation which will also give you the option of removing the test databases and anonymous user created by default. This is strongly recommended for production servers. See the manual for more instructions. You can start the MySQL daemon with: cd /usr/local/mysql55/mysql5557 ; /usr/local/mysql55/mysql5557/bin/mysqld_safe & You can test the MySQL daemon with mysql-test-run.pl cd /usr/local/mysql55/mysql5557/mysql-test ; perl mysql-test-run.pl Please report any problems at http://bugs.mysql.com/ [root@LHRDB mysql5557]# ll total 76 drwxr-xr-x 2 mysql mysql 4096 Aug 27 17:07 bin -rw-r--r-- 1 mysql mysql 17987 Jun 5 14:38 COPYING drwxr-xr-x 5 mysql mysql 4096 Aug 27 17:12 data drwxr-xr-x 2 mysql mysql 4096 Aug 27 17:07 docs drwxr-xr-x 3 mysql mysql 4096 Aug 27 17:07 include -rw-r--r-- 1 mysql mysql 301 Jun 5 14:38 INSTALL-BINARY drwxr-xr-x 3 mysql mysql 4096 Aug 27 17:07 lib drwxr-xr-x 2 mysql mysql 4096 Aug 27 17:10 log drwxr-xr-x 4 mysql mysql 4096 Aug 27 17:07 man drwxr-xr-x 10 mysql mysql 4096 Aug 27 17:07 mysql-test -rw-r--r-- 1 mysql mysql 2496 Jun 5 14:38 README drwxr-xr-x 2 mysql mysql 4096 Aug 27 17:07 scripts drwxr-xr-x 27 mysql mysql 4096 Aug 27 17:07 share drwxr-xr-x 4 mysql mysql 4096 Aug 27 17:07 sql-bench drwxr-xr-x 2 mysql mysql 4096 Aug 27 17:07 support-files [root@LHRDB mysql5557]# cd data/ [root@LHRDB data]# ll total 12 drwx------ 2 mysql root 4096 Aug 27 17:12 mysql drwx------ 2 mysql mysql 4096 Aug 27 17:12 performance_schema drwxr-xr-x 2 mysql mysql 4096 Aug 27 17:07 test [root@LHRDB data]# df -h Filesystem Size Used Avail Use% Mounted on /dev/mapper/vg_rootlhr-Vol00 9.9G 4.6G 4.9G 49% /
关于Linux系统下MySQL 5.5、5.6和5.7版本安装方法：RPM、二进制及源码安装指南，的介绍到此结束，希望对大家有所帮助。
【Linux系统下MySQL 5.5、5.6和5.7版本安装方法：RPM、二进制及源码安装指南】相关文章：
2.米颠拜石
3.王羲之临池学书
8.郑板桥轶事十则
用户评论
这篇文章正好是我现在要解决的问题！想在 Linux 上装 MySQL，还纠结要不要自己编译
有7位网友表示赞同！
我之前习惯用 RPM 包来安装软件了，这篇教程里也介绍这个方法？
有15位网友表示赞同！
MySQL 5.5、5.6 和 5.7 我都用过，各有优缺点吧，哪种更适合新手呢？
有15位网友表示赞同！
感觉源码安装比较复杂的操作，希望这篇文章能详细讲解一下步骤
有7位网友表示赞同！
我用的 Linux 系统有点老了，估计不支持那些最新的 MySQL 版本啊...
有7位网友表示赞同！
看标题就知道这篇文章是用来解决各种MySQL安装问题的好帮手！
有18位网友表示赞同！
之前也尝试过一些 MySQL 安装教程，希望能找到适合我的方法！
有7位网友表示赞同！
学习一下如何自己编译 MySQL，感觉可以更深入了解开源软件!
有14位网友表示赞同！
我比较喜欢 RPM 包这种简单快捷的安装方式，希望这篇文章能给我带来启发
有18位网友表示赞同！
在 Linux 下使用 MySQL 确实方便很多，尤其对于开发人员来说
有15位网友表示赞同！
这篇文章应该很全面，包括了常见的几种安装方式！
有17位网友表示赞同！
MySQL 是常用的数据库，学习下相关知识很有必要！
有12位网友表示赞同！
我有一个项目需要使用 MySQL，刚好看到这篇文章，感觉不错！
有10位网友表示赞同！
以前装过 RPM 包，这次来尝试一下源码安装看看区别？
有8位网友表示赞同！
Linux 下的MySQL配置挺复杂的，希望能找到这篇教程中的答案。
有7位网友表示赞同！
我正在学习数据库知识，这篇文章应该能帮助我更深入地了解 MySQL！
有8位网友表示赞同！
感谢作者分享这种宝贵经验，对我们使用 MySQL 非常有帮助!
有7位网友表示赞同！
我会认真阅读这篇文章，希望能从中学到很多关于 MySQL 的知识！
有17位网友表示赞同！
安装 MySQL 时各种问题都会遇到，这篇教程应该能解决我遇到的难题
有20位网友表示赞同！