RHEL6.5 Source Installation mysql-5.7.11

Source: Internet
Author: User
Tags mysql create

Source code compilation mysql-5.7.11:http://cdn.mysql.com//downloads/mysql-5.7/mysql-5.7.11.tar.gzhttp:// liquidtelecom.dl.sourceforge.net/project/boost/boost/1.59.0/boost_1_59_0.tar.gz installing the necessary resource bundles recommends using the network Yum Source, RHEL6.5 CD-ROM package version is not enough, mysql-5.7.11.tar.gz compilation of the package version of the requirements are relatively high, where CMake version is not less than 2.8 network Yum Source configuration can refer to HTTP://BLOG.SINA.COM.CN/S /blog_14e8c64ca0102vztv.html[[email protected] ~]# yum-y install gcc gcc-c++ autoconf automake zlib* libxml* ncurse S-devel libtool-ltdl-devel* make CMake delete system comes with mysql[[email protected] mysql-5.7.11]# yum-y remove MySQL Add users and Groups [[ Email protected] ~]# groupadd mysql[[email protected] ~]# useradd-m-s/sbin/nologin-r-g mysql MySQL create installation directory and According to the storage directory add a new hard disk, create partition SDB1 and allocate all the space [[email protected] ~]# mkdir/server[[email protected] ~]# mount/dev/sdb1/ server/boot automatically mount echo "/dev/sdb1/server ext4 defaults 0 0" >>/etc/ Fstab Note: mysql-5.7.11.tar.gz installation space is relatively large, the virtual machine environment is recommended to add a new hard disk to install, the real server does not need [[email protected] ~]# mkdir-p/server/ Mysql/data upload the source package to the/server directory or directly wget to download the source package decompression source Package [[Email protected] server]# tar zxf boost_1_59_0.tar.gz[[email protected] server]# tar zxf mysql-5.7.11.tar.gz Modify Boost Extract directory name [[email protected] server]# MV Boost_1_59_0 boost offload system comes with boost library [[email  Protected] ~]# yum-y Remove boost-* Note: Source compilation from mysql5.7.5 after the Boost library is required configuration related parameters [[email protected] ~]# CD mysql-5.7.11[[ Email protected] mysql-5.7.11]# Cmake-dcmake_install_prefix=/server/mysql-dmysql_datadir=/server/mysql/data -dsysconfdir=/etc-dwith_myisam_storage_engine=1-dwith_innobase_storage_engine=1-dwith_memory_storage_engine=1- Dwith_readline=1-dmysql_unix_addr=/server/mysql/mysql.sock-dmysql_tcp_port=3306-denabled_local_infile=1-dwith_ Partition_storage_engine=1-dextra_charsets=all-ddefault_charset=utf8-ddefault_collation=utf8_general_ci- Ddownload_boost=1-dwith_boost=/server/boost compiled parameters can be referenced in http://dev.mysql.com/doc/refman/5.6/en/ Source-configuration-options.html Cmake_install_prefix: Specifies the installation directory of the MySQL program, default/usr/local/mysqldefault_ CHARSET: Specifies the server default character set, default Latin1defaulT_collation: Specifies the default proofing rules for the server, default Latin1_general_cienabled_local_infile: Specifies whether to allow load DATA INFILE to be executed locally, by default Offwith_ COMMENT: Specifies compile note Information with_xxx_storage_engine: Specifies the storage engine that is statically compiled to MySQL, Myisam,merge,member and CSV Four engines are compiled to the server by default and do not require special designation. Without_xxx_storage_engine: Specify a storage engine that does not compile Sysconfdir: Initialize parameter file directory mysql_datadir: Data file directory mysql_tcp_port: Service port number, default 3306mysql_ Unix_addr:socket file path, the default/tmp/mysql.sock compilation mysql-5.7.11.tar.gz compile time consumes a lot of system resources, it is recommended to use more than one core to compile at the same time, or it may fail to compile [[email  Protected] mysql-5.7.11]# make-j 4 View server CPU cores [[email protected] ~]# grep processor/proc/cpuinfo | WC-L4 install [[email protected] mysql-5.7.11]# make install modify directory permissions [[email protected] ~]# chown-r mysql:mysql/ Server/mysql generate configuration file [[email protected] ~]# mv/etc/my.cnf{,.bak}[[email protected] ~]# cp/server/mysql/ SUPPORT-FILES/MY-DEFAULT.CNF/ETC/MY.CNF Build Service startup script [[email protected] ~]# cp/server/mysql/support-files/ Mysql.server/etc/init.d/mysqld[[email protected] ~]# chmod 755/etc/init.d/mysqld[[email protected] ~]# Chkconfig--addMysqld[[email protected] ~]# chkconfig mysqld on[[email protected] ~]# chkconfig--list mysqldmysqld 0:off 1:o FF 2:on 3:on 4:on 5:on 6:off Initialize database [[email protected] ~]#/server/mysql/bin/mysqld--initialize-insecure--user= MySQL--basedir=/server/mysql--datadir=/server/mysql/data start service [[email protected] ~]# service mysqld Startstarting MySQL [OK] Add path Path: Vim/etc/profile Add the following 2 lines at the end of the file export Mysql_home=/server/mysqlexport path= $PATH: $MYSQ L_home/bin Modify the mysql password [[email protected] ~]# mysqlmysql> set Password=password (' 123456 ');

RHEL6.5 Source Installation mysql-5.7.11

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.