建站
咨詢
售后
建站咨詢
新聞中心
1.添加用戶
groupadd mysql
useradd -r -g mysql mysql
創(chuàng)新互聯(lián)公司自成立以來，一直致力于為企業(yè)提供從網(wǎng)站策劃、網(wǎng)站設(shè)計、成都做網(wǎng)站、網(wǎng)站建設(shè)、電子商務(wù)、網(wǎng)站推廣、網(wǎng)站優(yōu)化到為企業(yè)提供個性化軟件開發(fā)等基于互聯(lián)網(wǎng)的全面整合營銷服務(wù)。公司擁有豐富的網(wǎng)站建設(shè)和互聯(lián)網(wǎng)應(yīng)用系統(tǒng)開發(fā)管理經(jīng)驗、成熟的應(yīng)用系統(tǒng)解決方案、優(yōu)秀的網(wǎng)站開發(fā)工程師團隊及專業(yè)的網(wǎng)站設(shè)計師團隊。
2.編譯安裝
tar xf mysql-5.6.34.tar.gz
cd mysql-5.6.34
#默認情況下是安裝在/usr/local/mysql
# cmake編譯參數(shù)可以自己調(diào)整
cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/data/mydata -DSYSCONFDIR=/etc -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_READLINE=1 -DWITH_SSL=system -DWITH_ZLIB=system -DMYSQL_UNIX_ADDR=/tmp/mysql.sock -DMYSQL_TCP_PORT=3306 -DENABLED_LOCAL_INFILE=1 -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 -DWITH_LIBWRAP=0 -DDEFAULT_COLLATION=utf8_general_ci
**************************************************************
-- Looking for asprintf
-- Looking for asprintf - found
-- Check size of pthread_t
-- Check size of pthread_t - done
-- Using cmake version 2.8.12.2
-- Not building NDB
-- Performing Test HAVE_PEERCRED
-- Performing Test HAVE_PEERCRED - Success
-- Library mysqlclient depends on OSLIBS -lpthread;/usr/lib64/libz.so;m;rt;/usr/lib64/libssl.so;/usr/lib64/libcrypto.so;dl
-- Googlemock was not found. gtest-based unit tests will be disabled. You can run cmake . -DENABLE_DOWNLOADS=1 to automatically download and build required components from source.
-- If you are inside a firewall, you may need to use an http proxy: export http_proxy=http://example.com:80
-- Library mysqlserver depends on OSLIBS -lpthread;/usr/lib64/libz.so;m;rt;/usr/lib64/libssl.so;/usr/lib64/libcrypto.so;dl;crypt
-- CMAKE_BUILD_TYPE: RelWithDebInfo
-- COMPILE_DEFINITIONS: HAVE_CONFIG_H
-- CMAKE_C_FLAGS: -Wall -Wextra -Wformat-security -Wvla -Wwrite-strings -Wdeclaration-after-statement
-- CMAKE_CXX_FLAGS: -Wall -Wextra -Wformat-security -Wvla -Woverloaded-virtual -Wno-unused-parameter
-- CMAKE_C_FLAGS_RELWITHDEBINFO: -O3 -g -fabi-version=2 -fno-omit-frame-pointer -fno-strict-aliasing -DDBUG_OFF
-- CMAKE_CXX_FLAGS_RELWITHDEBINFO: -O3 -g -fabi-version=2 -fno-omit-frame-pointer -fno-strict-aliasing -DDBUG_OFF
-- Configuring done
-- Generating done
CMake Warning:
Manually-specified variables were not used by the project:
WITH_READLINE
-- Build files have been written to: /root/mysql-5.6.34
**************************************************************
cmake編譯報錯需要刪除編譯緩存，修復(fù)錯誤后再次重新編譯
rm -f CMakeCache.txt
3.make && make install
注意事項：
重新編譯時，需要清除舊的對象文件和緩存信息。
# make clean
# rm -f CMakeCache.txt
# rm -rf /etc/my.cnf
4.改變數(shù)據(jù)存儲目錄所有者為mysql
chown -R mysql.mysql /usr/local/mysql
chown -R mysql.mysql /data/mydata
5.啟動腳本初始化數(shù)據(jù)庫
cd /usr/local/mysql
# scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/data/mydata
6.注冊服務(wù)
cp support-files/mysql.server /etc/rc.d/init.d/mysqld
#使用默認配置文件
cp support-files/my-default.cnf /etc/my.cnf
#讓chkconfig管理mysql服務(wù)
chkconfig --add mysqld
#開機啟動
chkconfig mysqld on
編輯/etc/my.cnf配置，加入以下內(nèi)容
innodb_file_per_table = 1
datadir = /data/mydata
log-bin=/data/binlogs/mysql-bin
注意：
經(jīng)過實際測試innodb_file_per_table = ON這條參數(shù)需要innodb_file_per_table = 1 才能生效，具體可以通過
mysql> show variables like '%per_table%';來查詢
mkdir /data/binlogs
chown -R mysql.mysql /data/binlogs
8.將mysql命令加入環(huán)境變量中
vim /etc/profile.d/mysql.sh
加入
export PATH=/usr/local/mysql/bin:$PATH
默認密碼為空
9修改/etc/security/limits.conf，然后加入以下內(nèi)容，退出再重新登陸即可(不需要重啟，退出當(dāng)前的連接shell即可)
# ulimit -n 查看參數(shù)是否生效
* hard nofile 655350
* soft nofile 655350
否則報錯如下：
錯誤#23: Out of resources when opening file './XX/USER.MYD' (Errcode: 24)
同時
vim /etc/security/limits.d/90-nproc.conf
刪除如下這行接觸centos對文件操作句柄的限制：
* soft nproc 1024
網(wǎng)站名稱：CentOS6.5環(huán)境源碼編譯安裝MySQL5.6.34
網(wǎng)址分享：http://fisionsoft.com.cn/article/coceioc.html
