大多数都是将MysqL编译好放在系统目录里
我的方式是将编译的文件放在指定的目录里
为了实现同一台机器可以开启多个MysqL实例进程
各个实例之间相互不影响.不需要root权限
下载CentOS6.5_X86 安装基于Basic Server
http://archive.kernel.org/centos-vault/6.5/isos/i386/CentOS-6.5-i386-bin-DVD1.iso
MysqL 官方下载 https://dev.mysql.com/downloads/mysql/
MysqL 在线文档/下载 https://dev.mysql.com/doc/refman/5.7/en/
MysqL 编译选项文档 https://dev.mysql.com/doc/refman/5.7/en/source-configuration-options.html
安装依赖:
@H_301_72@[root@CentOS~]#yuminstallcmake [root@CentOS~]#yuminstallgcc [root@CentOS~]#yuminstallgcc-c++ [root@CentOS~]#yuminstallreadline [root@CentOS~]#yuminstallncurses-devel [root@CentOS~]#yuminstallbison [root@CentOS~]#rm-rf/etc/my.cnf/etc/MysqL/my.cnf下载,编译,安装 MysqL管理软件
@H_301_72@ [root@CentOS~]#useraddMysqL [root@CentOS~]#su-MysqL [MysqL@CentOS~]$wgethttp://ftp.iij.ad.jp/pub/db/MysqL/Downloads/MysqL-5.7/MysqL-boost-5.7.18.tar.gz [MysqL@CentOS~]$tarxfMysqL-boost-5.7.18.tar.gz [MysqL@CentOS~]$cdMysqL-5.7.18/ [MysqL@CentOSMysqL-5.7.18]$\ rm-rfCMakeCache.txt;\ makeclean;\ cmake.\ -DWITH_BOOST=boost/boost_1_59_0/\ -DCMAKE_INSTALL_PREFIX=${HOME}/MysqL/\ -DCMAKE_BUILD_TYPE=Release\ -DDEFAULT_CHARSET=utf8\ -DDEFAULT_COLLATION=utf8_general_ci\ -DWITH_MYISAM_STORAGE_ENGINE=1\ -DWITH_INNOBASE_STORAGE_ENGINE=1\ -DWITH_ARCHIVE_STPRAGE_ENGINE=1\ -DWITH_BLACKHOLE_STORAGE_ENGINE=1\ -DWIYH_READLINE=1\ &&make&&makeinstall [MysqL@CentOSMysqL-5.7.18]$echo$? 0启动,关闭,登陆
@H_301_72@ [MysqL@CentOSMysqL]$bin/MysqLd_safe&#启动MysqL服务,将仓库文件用进程跑起来 [root@CentOSMysqL]#./bin/MysqLadmin-uroot-pshutdown#关闭MysqL服务 [MysqL@CentOS~]$./MysqL/bin/MysqL-hlocalhost-uroot-p#登陆MysqL Enterpassword:输入刚才得到的临时密码 立即修改密码,取消MysqLroot远程登陆限制 ALTERUSERUSER()IDENTIFIEDBY'root'; useMysqL; selecthost,userfromuser; updateusersethost='%'whereuser='root'; selecthost,userfromuser; FLUSHPRIVILEGES;MysqL程序路径 /home/laowang/MysqL_5.7.18
数据库文件存储路径 /home/laowang/MysqL_5.7.18/data
MysqL的错误日志路径 /home/laowang/MysqL_5.7.18/data/CentOS.err
MysqL服务进程PID /home/laowang/MysqL_5.7.18/data/CentOS.pid-file
到此为止,一个新的MysqL实例完成了,