基于Centos6.5的MySQL5.7.15二进制源码安装

前端之家收集整理的这篇文章主要介绍了基于Centos6.5的MySQL5.7.15二进制源码安装前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。

操作系统准备,本次MysqL5.7实战安装是在Centos6.5 x86_64系统上完成。如下是系统详情。@H_502_7@

[root@MysqLserver~]#uname-a
LinuxMysqLserver2.6.32-431.el6.x86_64#1SMPFriNov2203:15:09UTC2013x86_64x86_64x86_64GNU/Linux
[root@MysqLserver~]#cat/etc/redhat-release
CentOSrelease6.5(Final)

1.MysqL软件包准备

本次实战使用,下载的是版本是MysqL5.7.15社区版。安装包下载二进制源码免编译的包。可以通过MysqL官网下载,http://dev.mysql.com/downloads/mysql/@H_502_7@

如下链接是我已经下载好保存在网盘的,也可以参考使用。@H_502_7@

http://pan.baidu.com/s/1eSr57oQ@H_502_7@

wKiom1gb8nXAZtxLAAB42Ycl-BQ550.png-wh_50

@H_502_7@

(官网已经更新到5.7.16了

j_0059.gif

)@H_502_7@
MysqL-5.7.15-linux-glibc2.5-x86_64.tar.gz

安装包通过ftp或者secureCRT工具上传centos系统中@H_502_7@

2.解压MysqL软件包,指定安装目录,修改MysqL目录名

MysqL安装包上传到centos系统后,解压软件包。将解压后生成的目录,复制到/usr/local/下并改名为MysqL,/usr/local/MysqL就是MysqL数据库的安装目录。@H_502_7@

[root@MysqLserverMysqL]tarxfzMysqL-5.7.15-linux-glibc2.5-x86_64.tar.gz
[root@MysqLserverMysqL]mvMysqL-5.7.15-linux-glibc2.5-x86_64/usr/local/MysqL
[root@MysqLserverMysqL]ln-svMysqL-5.7.15-linux-glibc2.5-x86_64/usr/local/MysqL

wKioL1gb8yezOZQbAAEvEPFO40I524.png-wh_50

@H_502_7@

3.创建MysqL用户

[root@MysqLserverMysqL]#groupaddMysqL
[root@MysqLserverMysqL]#useradd-gMysqL-s/sbin/nologin-MMysqL
[root@MysqLserverMysqL]#idMysqL#检测是否创建成功

wKiom1gb812SP0gKAAC0-x54Enw809.png-wh_50

@H_502_7@

4.创建MysqL数据目录和日志目录。MysqL在初始化数据库的时候会用到该数据目录

[root@MysqLserverMysqL]#mkdir/MysqL/MysqL/data/MysqL/log

wKioL1gb863RkVC5AAA_bzdJWTw159.png-wh_50

@H_502_7@

5.更改目录权限

更改目录权限,以便MysqL在初始化时候顺利进行。@H_502_7@

[root@MysqLserverMysqL]#
chown-RMysqL:MysqL/usr/local/MysqL/MysqL

wKiom1gb9kvRF5z7AACddEpj4Es088.png-wh_50

@H_502_7@

6.创建my.cnf文件

[root@MysqLserverlocal]#vi/etc/my.cnf

配置文件如下:@H_502_7@

[client]@H_502_7@

port = 3306@H_502_7@

socket = /tmp/MysqL.sock@H_502_7@

[MysqLd]@H_502_7@

server_id=10@H_502_7@

user = MysqL@H_502_7@

basedir = /usr/local/MysqL@H_502_7@

datadir = /MysqL/data@H_502_7@

pid-file = /MysqL/data/MysqL.pid@H_502_7@

max_connections = 1000@H_502_7@

max_connect_errors = 1000@H_502_7@

table_open_cache = 1024@H_502_7@

max_allowed_packet = 128M@H_502_7@

open_files_limit = 65535@H_502_7@

# [innodb]@H_502_7@

innodb_buffer_pool_size = 1024M@H_502_7@

innodb_file_per_table = 1@H_502_7@

innodb_write_io_threads = 4@H_502_7@

innodb_read_io_threads = 4@H_502_7@

innodb_purge_threads = 2@H_502_7@

innodb_flush_log_at_trx_commit = 1@H_502_7@

innodb_log_file_size = 512M@H_502_7@

innodb_log_files_in_group = 2@H_502_7@

innodb_log_buffer_size = 16M@H_502_7@

innodb_max_dirty_pages_pct = 80@H_502_7@

innodb_lock_wait_timeout = 30@H_502_7@

innodb_data_file_path=ibdata1:1024M:autoextend@H_502_7@

##log@H_502_7@

log_error = /MysqL/log/MysqL-error.log@H_502_7@

slow_query_log = 1@H_502_7@

long_query_time = 1@H_502_7@

slow_query_log_file = /MysqL/log/MysqL-slow.log@H_502_7@

sql_mode=ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION@H_502_7@

说明:这里只是进行了一些简单的配置,如果稍后需要可以自己按需添加配置@H_502_7@

7.初始化数据库

要点说明:在5.7.6之前初始化的方法是:@H_502_7@

数据库安装目录/scripts/MysqL_install_db--user=MysqL@H_502_7@

此次实战操作下载的是最新的5.7.155.7.6之后的版本初始化数据库不再使用MysqL_install_db,使用@H_502_7@

bin/MysqLd --initialize--user=MysqL--basedir=/usr/local/MysqL--datadir=/MysqL/data@H_502_7@

7.1进入数据库目录,以下配置都在/usr/local/MysqL下,完成初始化

[root@MysqLserverMysqL]bin/MysqLd--initialize--user=MysqL--basedir=/usr/local/MysqL--datadir=/MysqL/data--innodb_undo_tablespaces=3--explicit_defaults_for_timestamp

wKiom1gb9jTxdcGkAAKCJMF5Bmw306.png-wh_50

@H_502_7@

wKiom1gb9X6wDmIrAAA0OnwbdAA788.png-wh_50

@H_502_7@

如果配置了my.cnflog_error,那么初始密码在log_error文件中,否则会打印出来。如下图中,红色笔迹勾选的就是密码。A temporary is generated forroot@localhost:-7&YUR<%ox- MysqL初始化完成后就可以使用这个密码在本机通过root用户登录@H_502_7@

wKioL1gb9hqyzYDLAAOHSHcQ1O4100.png-wh_50

@H_502_7@

[root@MysqLserver MysqL]bin/MysqL_ssl_rsa_setup --datadir=/MysqL/data@H_502_7@

wKiom1gb9wPAjTRnAADqvsYgMrQ120.png-wh_50

@H_502_7@

7.2配置启动文件,启动MysqL服务

MysqL的启动文件MysqL.server放在MysqL源码包中,如下目录/usr/local/MysqL/support-files,复制该文件同时改名为MysqL/etc/init.d/MysqL@H_502_7@

wKiom1gb-HLiTBQ1AABF669PS-o433.png-wh_50

@H_502_7@
[root@MysqLserverbin]cpsupport-files/MysqL.server/etc/init.d/MysqL

wKioL1gb-OeT-NGsAABMkfXT8l8379.png-wh_50

@H_502_7@

MysqL启动设置成功如下,但是启动MysqL失败,因为环境变量没有配置。@H_502_7@

wKiom1gb-P6gQXVRAACVt7uxzuM439.png-wh_50

@H_502_7@

7.3配置环境变量

方法一:@H_502_7@

[root@MysqLserverMysqL]#vim
/etc/profile

wKioL1gb-SHi7XToAAHDXyctFOA548.png-wh_50

@H_502_7@

MysqL_home=/usr/local/MysqL@H_502_7@

PATH=$PATH:$MysqL_home/bin@H_502_7@

方法二:@H_502_7@

[root@MysqLserverbin]#
echo'PATH=/usr/local/MysqL/bin:$PATH'>>/etc/profile

使添加MysqL的环境变量生效@H_502_7@

[root@MysqLserverbin]#source/etc/profile
[root@MysqLserverbin]#echo$PATH
/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin:/usr/local/MysqL/bin

wKiom1gb-YXQOxfLAACLL5ZjjwE613.png-wh_50

@H_502_7@

MysqL 环境变量增加内容小结@H_502_7@

echo 'export PATH=/MysqL安装目录/bin:$PATH'>>/etc/profile@H_502_7@

tail -l /etc/profile@H_502_7@

source /etc/profile@H_502_7@

echo $PATH@H_502_7@

7.4设置开机启动MysqL

[root@MysqLserverbin]#chkconfig--addMysqL
[root@MysqLserverbin]#chkconfigMysqLon
[root@MysqLserverbin]#chkconfig--listMysqL
MysqL0:关闭1:关闭2:启用3:启用4:启用5:启用6:关闭

8.登陆数据库

[root@MysqLserver~]#MysqL-uroot-p
Enterpassword:
WelcometotheMysqLmonitor.Commandsendwith;or\g.
YourMysqLconnectionidis5
Serverversion:5.7.15-logMysqLCommunityServer(GPL)
Copyright(c)2000,2016,Oracleand/oritsaffiliates.Allrightsreserved.
OracleisaregisteredtrademarkofOracleCorporationand/orits
affiliates.Othernamesmaybetrademarksoftheirrespective
owners.
Type'help;'or'\h'forhelp.Type'\c'toclearthecurrentinputstatement.

wKiom1gb-ezBDvAgAAE7RVsaqBE653.png-wh_50

@H_502_7@

到此,MysqL5.7的安装基本完成。在文章整理过程中,难免出现错误或者表达不当的地方,希望大家通过实际操作后指出不足,给予建议或者意见。@H_502_7@

9.注意事项

5.7中存储密码的字段不再是password了,变成了authentication_string@H_502_7@

update MysqL.user @H_502_7@

set authentication_string=password('root') where user='root';@H_502_7@

谢谢大家的阅读,技术学习之路还很长,愿与你一起成长!@H_502_7@

猜你在找的CentOS相关文章