CentOS Linux下編譯安裝MySQL

標籤：

本文參考張宴的Nginx 0.8.x + PHP 5.2.13（FastCGI）搭建勝過Apache十倍的Web伺服器（第6版）[原創]完成。所有操作命令都在CentOS 6.4 64位作業系統下實踐成功。

1、移除CentOS內建的mysql

yum remove mysql mysql-server compat-mysql51rpm -e --nodeps mysql-libs-5.1.*

2、安裝編譯依賴包

yum -y install cmakeyum -y install bison

3、下載MySQL

cd /data0/software/wget http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.26.tar.gz

4、編譯安裝MySQL

/usr/sbin/groupadd mysql/usr/sbin/useradd -g mysql mysqltar zxvf mysql-5.6.26.tar.gzcd mysql-5.6.26cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DWITH_EXTRA_CHARSETS=complex -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_MEMORY_STORAGE_ENGINE=1 -DWITH_READLINE=1 -DENABLED_LOCAL_INFILE=1 -DENABLED_PROFILING=on -DWITH_SSL=bundled -DWITH_ZLIB=bundled -DENABLED_THREAD_SAFE_CLIENT=on    -DWITH_EMBEDDED_SERVER=on    make && make installcd ../

①、以mysql使用者帳號的身份建立資料表：

/usr/local/mysql/scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysqlmkdir -p /usr/local/webserver/rm -f /usr/local/webserver/mysqlln -s /usr/local/mysql/ /usr/local/webserver/mysqlrm -f /usr/local/mysql/my.cnfchmod +w /usr/local/mysqlchown -R mysql:mysql /usr/local/mysql

②、建立my.cnf設定檔

rm -f /etc/my.cnfvi /etc/my.cnf

輸入以下內容：

[client]#character-set-server = utf8port    = 3306socket  = /tmp/mysql.sock[mysqld]character-set-server = utf8replicate-ignore-db = mysqlreplicate-ignore-db = testreplicate-ignore-db = information_schemauser    = mysql#bind-address = 192.168.0.1port    = 3306socket  = /tmp/mysql.sockbasedir = /usr/local/mysqldatadir = /usr/local/mysql/datapid-file = /usr/local/mysql/data/mysql.pidopen_files_limit    = 10240back_log = 600max_connections = 5000max_connect_errors = 6000external-locking = FALSEmax_allowed_packet = 32Msort_buffer_size = 1Mjoin_buffer_size = 1Mthread_cache_size = 300#thread_concurrency = 8query_cache_size = 512Mquery_cache_limit = 2Mquery_cache_min_res_unit = 2kdefault-storage-engine = MyISAMthread_stack = 192Ktransaction_isolation = READ-COMMITTEDtmp_table_size = 246Mmax_heap_table_size = 246Mlong_query_time = 3log-slave-updateslog-bin=mysql-binbinlog_cache_size = 4Mbinlog_format = MIXEDexpire_logs_days = 30max_binlog_cache_size = 8Mmax_binlog_size = 1G#relay-log-index = /data0/mysql/3306/relaylog/relaylog#relay-log-info-file = /data0/mysql/3306/relaylog/relaylog#relay-log = /data0/mysql/3306/relaylog/relaylogexpire_logs_days = 30key_buffer_size = 256Mread_buffer_size = 1Mread_rnd_buffer_size = 16Mbulk_insert_buffer_size = 64Mmyisam_sort_buffer_size = 128Mmyisam_max_sort_file_size = 10Gmyisam_repair_threads = 1myisam_recoverinteractive_timeout = 120wait_timeout = 120skip-name-resolve#master-connect-retry = 10slave-skip-errors = 1032,1062,126,1114,1146,1048,1396#master-host     =   192.168.1.2#master-user     =   username#master-password =   password#master-port     =  3306server-id = 1#innodb_additional_mem_pool_size = 16M#innodb_buffer_pool_size = 512M#innodb_data_file_path = ibdata1:256M:autoextend#innodb_file_io_threads = 4#innodb_thread_concurrency = 8#innodb_flush_log_at_trx_commit = 2#innodb_log_buffer_size = 16M#innodb_log_file_size = 128M#innodb_log_files_in_group = 3#innodb_max_dirty_pages_pct = 90#innodb_lock_wait_timeout = 120#innodb_file_per_table = 1[mysqldump]quickmax_allowed_packet = 32M

③、啟動MySQL

cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqlservice mysql start

④、通過命令列登入管理MySQL伺服器（提示輸入密碼時直接斷行符號）

/usr/local/webserver/mysql/bin/mysql -uroot -p

⑤、輸入以下SQL語句，設定root使用者的密碼

mysql> use mysql;mysql> update user set Password = password(‘123456‘) where User=‘root‘; mysql> flush privileges;mysql> exit;

⑥、設定開機啟動MySQL

chkconfig --add mysqlchkconfig mysql on

最後需要做的就是映射一個連結到/usr/bin目錄下

ln -s /usr/local/mysql/bin/mysql /usr/bin

 

除非註明，本部落格文章均為原創，轉載請以連結形式標明本文地址

本文地址： http://blog.cnwyhx.com/centos-linux-install-mysql

CentOS Linux下編譯安裝MySQL