mysql-5.7（centos-6.9環境）源碼安裝

標籤：setup   ati   string   pass   lob   schema   安裝   機器   x86_64   

2017-12-25

# 配置主機名稱完整顯示vim /etc/bashrc  # Turn on checkwinsize  shopt -s checkwinsize  [ "$PS1" = "\\s-\\v\\\$ " ] && PS1="[\[email protected]\H \W]\\$ "# 配置主機名稱永久生效vim /etc/sysconfig/networkNETWORKING=yesHOSTNAME=mysql-5.7-master# 配置主機名稱臨時生效hostname mysql-5.7-master# 配置hosts解析vim /etc/hosts127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4::1         localhost localhost.localdomain localhost6 localhost6.localdomain610.0.0.156  mysql-5.7-master master10.0.0.157  mysql-5.7-slave  slave# 配置Yum倉庫cd /etc/yum.repos.dwget http://mirrors.163.com/.help/CentOS6-Base-163.repowget http://mirrors.aliyun.com/epel/epel-release-latest-6.noarch.rpm rpm -ivh epel-release-latest-6.noarch.rpmyum clean all && yum makecache# 配置SSH互信ssh-keygen -t rsacat /root/.ssh/id_rsa.pub >> /root/.ssh/authorized_keysssh-copy-id slave# 檢查殘留包yum list|grep mysqlyum -y remove mysql.x86_64yum -y remove mysql-libs.x86_64# 刪除預設位置設定檔/etc/my.cnfrm -rf /etc/my.cnf# 建立目錄mkdir -p /app/mysql/etcmkdir -p /data/mysql/my3306# 建立使用者groupadd dba && useradd mysql -g dba# 下載源碼包wget http://mirrors.sohu.com/mysql/MySQL-5.7/mysql-boost-5.7.18.tar.gz# 解壓源碼包tar -zxf mysql-boost-5.7.18.tar.gz -C /usr/local/src/ && cd /usr/local/src/mysql-5.7.18# 安裝依賴包yum -y install ncurses ncurses-devel gcc libtool gcc-c++ make cmake readline-devel zlib-devel bison perl-Module-Install.noarch # 先行編譯time cmake -DCMAKE_INSTALL_PREFIX=/app/mysql -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1  -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_PERFSCHEMA_STORAGE_ENGINE=1 -DWITH_FEDERATED_STORAGE_ENGINE=1 -DWITHOUT_EXAMPLE_STORAGE_ENGINE=1 -DDEFAULT_CHARSET=utf8mb4 -DDEFAULT_COLLATION=utf8mb4_general_ci -DEXTRA_CHARSETS=all -DENABLED_LOCAL_INFILE=ON -DWITH_BOOST=/usr/local/src/mysql-5.7.18/boost # 重新編譯（可選）make cleanrm -rf CMakeCache.txt# 編譯、安裝make && make install# 複製設定檔cp ~/my.cnf /app/mysql/etc/my.cnfln -s /app/mysql/etc/my.cnf /etc/my.cnf# 修改目錄所屬組、使用者chown -R mysql.dba /app/mysql/chown -R mysql.dba /data/mysql/# 初始化資料庫/app/mysql/bin/mysqld --defaults-file=/app/mysql/etc/my.cnf --initialize --basedir=/app/mysql --datadir=/data/mysql/my3306 --tmpdir=/data/mysql/my3306 --user=mysql# 配置環境變數vim ~/.bash_profileMYSQL_BASE=/app/mysqlPATH=$PATH:$HOME/bin:$MYSQL_BASE/binsource ~/.bash_profile# 配置ssl登入mysql_ssl_rsa_setup  --datadir=/data/mysql/my3306# 複製啟動指令碼cp /app/mysql/support-files/mysql.server /etc/rc.d/init.d/mysqld# 啟動資料庫service mysqld start# 擷取初始化密碼[[email protected]-5.7-master my3306]# grep ‘temporary password‘ /data/mysql/my3306/error.log     2017-12-22T15:39:53.526557Z 1 [Note] A temporary password is generated for [email protected]: bDjk&nU:h2Zl[[email protected]-5.7-slave my3306]# grep ‘temporary password‘ /data/mysql/my3306/error.log 2017-12-25T17:32:27.298337Z 1 [Note] A temporary password is generated for [email protected]: lR(;EGObl8q?# 登入資料庫mysql -uroot -p‘bDjk&nU:h2Zl‘mysql -uroot -p‘lR(;EGObl8q?‘# 修改密碼並允許其他機器上用戶端登入set global validate_password_policy=0;# 重設root密碼ALTER USER ‘root‘@‘localhost‘ IDENTIFIED BY ‘[email protected]‘;grant all privileges on *.* to ‘root‘@‘%‘ identified by ‘[email protected]‘ with grant option;  # 退出並重新登入資料庫mysql -uroot -p‘[email protected]‘# 查看資料庫使用者及許可權select User,Host,authentication_string,account_locked from mysql.user;# 設定免密碼登陸路徑mysql_config_editor set --login-path=my3306 --user=root --password --port=3306 --socket=/data/mysql/my3306/mysql.sock# 查看免密碼登陸路徑mysql_config_editor print --all# 刪除免密碼登陸路徑（可選）mysql_config_editor remove --login-path=my3306# 本地免密碼登陸資料庫mysql --login-path=my3306# 設定開機啟動chkconfig mysqld onchkconfig --list | grep mysql

 

mysql-5.7（centos-6.9環境）源碼安裝