《MYSQL教程CentOS 6.5編譯安裝Percona 5.6.15(步驟)》要點:
本文介紹了MYSQL教程CentOS 6.5編譯安裝Percona 5.6.15(步驟),希望對您有用。如果有疑問,可以聯系我們。
導讀:CentOS 6.5下通過yum安裝的MySQL是5.1版的,于是想通過源代碼安裝高版本的5.6.15.版本為 Percona 5.6.15源碼版,下載地址:http://www....
MYSQL數據庫CentOS 6.5下通過yum安裝的MySQL是5.1版的,于是想通過源代碼安裝高版本的5.6.15.
MYSQL數據庫版本為 Percona 5.6.15源碼版,下載地址:
http://www.percona.com/redir/downloads/Percona-Server-5.6/LATEST/source/Percona-Server-5.6.15-rel63.0.tar.gz
MYSQL數據庫一、卸載原有MySQL
檢查是否安裝有MySQL Server:
?
rpm -qa | grep mysql?
MYSQL數據庫刪除辦法:
?
rpm -e mysql?? #普通刪除模式?
rpm -e --nodeps mysql??? #強行刪除模式,如果使用上面命令刪除時,提示有依賴的其它文件,則用該命令可以對其強行刪除.?
MYSQL數據庫二、安裝gcc編譯環境
?
yum -y install make gcc-c++ cmake bison-devel? ncurses-devel?
MYSQL數據庫三、安裝CMake
下載地址:
http://www.cmake.org/files/v2.8/cmake-2.8.12.1.tar.gz
MYSQL數據庫切換到root用戶,使用命令安裝:
?
./bootstrap??
#檢查無誤后安裝?
make && make install?
MYSQL數據庫四、安裝MySQL
1,設置權限
?
groupadd dba?
useradd mysql -g dba?
MYSQL數據庫2,設置安裝環境
?
#為保證數據平安,將數據單獨存盤于/data目錄下?
mkdir /app/mysql?
mkdir /data/mysql?
cd /data/mysql?
mkdir run data tmp logs?
chown -R mysql:dba /app/mysql?
chown -R mysql:dba /data/mysql?
?
MYSQL數據庫3,安裝mysql(Percona 5.6.15)
?
tar zxvf Percona-Server-5.6.15-rel63.0.tar.gz?
cd Percona-Server-5.6.15?
cmake . -LH?
cmake .? ?
-DCMAKE_INSTALL_PREFIX=/app/mysql #設置程序安裝路徑?
-DMYSQL_DATADIR=/data/mysql/data #設置數據存放路徑?
-DSYSCONFDIR=/etc ??
-DWITH_MYISAM_STORAGE_ENGINE=1 #啟用MYISAM存儲引擎?
-DWITH_INNOBASE_STORAGE_ENGINE=1 ?
-DWITH_ARCHIVE_STORAGE_ENGINE=1 ?
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 ?
-DWITH_PERFSCHEMA_STORAGE_ENGINE=1 ?
-DWITH_FEDERATED_STORAGE_ENGINE=1? ?
-DWITH_READLINE=1 #啟用MySQL快捷鍵?
-DMYSQL_UNIX_ADDR=/data/mysql/run/mysqld.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 #默認檢驗規則?
#以上代碼為方便查看,若直接執行,可使用下面代碼?
cmake .? -DCMAKE_INSTALL_PREFIX=/app/mysql -DMYSQL_DATADIR=/data/mysql/data -DSYSCONFDIR=/etc -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1? -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_PERFSCHEMA_STORAGE_ENGINE=1 -DWITH_FEDERATED_STORAGE_ENGINE=1? -DWITH_READLINE=1? -DMYSQL_UNIX_ADDR=/data/mysql/run/mysqld.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?
make -j 4 && make install?
MYSQL數據庫4,安裝完成Percona 5.6.15后,開始建立配置文件.
?
chown mysql:dba /etc/my.cnf?
vim /etc/my.cnf?
[client]?
#password?? = your_password?
port??????? = 3306?
socket????? = /data/mysql/run/mysql.sock?
default-character-set=utf8?
?
[mysqld]?
port??????? = 3306?
socket????? = /data/mysql/run/mysql.sock?
baserdir??? = /app/mysql?
datadir???? = /data/mysql/data?
?
skip-external-locking?
key_buffer_size = 16M?
max_allowed_packet = 1M?
table_open_cache = 64?
sort_buffer_size = 512K?
net_buffer_length = 8K?
read_buffer_size = 256K?
read_rnd_buffer_size = 512K?
myisam_sort_buffer_size = 8M?
?
default-storage-engine = InnoDB?
character_set_server = utf8?
tmpdir????? = /data/mysql/tmp/?
log-bin=/data/mysql/logs/mysql-bin?
expire_logs_days= 14?
binlog_format=mixed?
log-error = /data/mysql/logs/error.log?
slow-query-log = 1?
long_query_time= 3?
slow_query_log_file = /data/mysql/logs/slow.log?
server-id?? = 1?
innodb_data_home_dir = /data/mysql/data?
innodb_data_file_path = ibdata1:10M:autoextend?
innodb_log_group_home_dir = /data/mysql/logs?
innodb_buffer_pool_size = 16M?
innodb_additional_mem_pool_size = 2M?
innodb_log_file_size = 5M?
innodb_log_buffer_size = 8M?
innodb_flush_log_at_trx_commit = 1?
innodb_lock_wait_timeout = 50?
innodb_file_per_table = 1?
[mysqldump]?
quick?
max_allowed_packet = 16M?
?
[mysql]?
no-auto-rehash?
?
[myisamchk]?
key_buffer_size = 20M?
sort_buffer_size = 20M?
read_buffer = 2M?
write_buffer = 2M?
?
[mysqlhotcopy]?
interactive-timeout?
MYSQL數據庫5,初始MySQL配置表(用戶權限表等)
?
./scripts/mysql_install_db? --basedir=/app/mysql --datadir=/data/mysql/data --user=mysql --force?
MYSQL數據庫6,設置開機啟動
?
su -?
cp /app/mysql/support-files/mysql.server /etc/init.d/mysql?
chmod +x /etc/init.d/mysql?
chkconfig -add mysql?
chkconfig --level 345 mysql on?
MYSQL數據庫7,修改Path變量
vim /etc/profile?
在句末參加
?
PATH=/app/mysql/bin:$PATH?
export PATH?
?
MYSQL數據庫啟用PATH
?
. /etc/profile?
#or?
source /etc/profile?
MYSQL數據庫8,啟動MySQL,并設置暗碼
?
service mysql start?
mysqladmin -uroot password '******'?
MYSQL數據庫至此,勝利安裝Percona 5.6.15.
歡迎參與《MYSQL教程CentOS 6.5編譯安裝Percona 5.6.15(步驟)》討論,分享您的想法,維易PHP學院為您提供專業教程。
轉載請注明本頁網址:
http://www.snjht.com/jiaocheng/12740.html