CentOS 6.6 Compilation Installation MySQL 5.6

Source: Internet
Author: User

1. Download Source 12    wget http://dev.mysql.com/get/downloads/mysql-5.6/mysql-5.6.25.tar.gztar  xzvf mysql-5.6.25.tar.gz    2. Preparing 123456789    # before installation Add user group groupadd www# Add user useradd -c mysql-user -g www -m mysql# install dependent yum  install libaio-devel# Creating a Data Catalog Mkdir /data/soft/mysqlchown -r mysql:www /data/soft/mysql     3. Installation from mysql5.5, MySQL source installation started using CMake, set up the source code compilation configuration script. 1    cmake -dcmake_install_prefix=/usr/local/mysql -dmysql_unix_addr=/usr/local/ Mysql/mysql.sock -ddefault_charset=utf8 -ddefault_collation=utf8_general_ci -dwith_innobase_ Storage_engine=1 -dwith_archive_storage_engine=1 -dwith_blackhole_storage_engine=1 -dmysql_ datadir=/data/mysqldb -dmysql_tcp_port=3306 -denable_downloads=1     Note: Re-run the configuration, Need to delete CMakeCache.txt file 1    rm cmakecache.txt    1234     #编译make # Install make install    4. MySQL master directory and data directory processing 12    chown -r mysql:www /usr/local/mysqlchown -r  Mysql:www /data/soft/mysql    5. Initializing the database 12    chmod +x / usr/local/mysql/scripts/mysql_install_db/usr/local/mysql/scripts/mysql_install_db --user=mysql -- Datadir=/data/soft/mysql    6. Copying a configuration file 123456789    cp /usr/local/ MYSQL/SUPPORT-FILES/MY-DEFAULT.CNF /ETC/MY.CNF Modify some configuration # these are commonly set,  remove the # and set as required.basedir = /usr/local/mysql#  datadir = .....datadir = /data/soft/mysql# port = .....# server_id  = .....socket = /usr/local/mysql/mysql.sock    7. Replication Service Script 12     cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqldchmod +x /etc/init.d/mysqld     8. Add Boot entry 12    /etc/init.d/mysqld startchkconfig --level 35 mysqld  on    9. Run the security settings script, modify the password of the MySQL user root, and disable root remote connection, remove test database and anonymous user. 1    /usr/local/mysql/scripts/mysql_install_db --basedir=/usr/local/mysql -- Datadir=/data/soft/mysql --user=mysql


This article from the "James" blog, reproduced please contact the author!

CentOS 6.6 Compilation Installation MySQL 5.6

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.