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