更新系統到最新
yum update
檢查系統中是否有安裝mysql或者其他殘留
rpm -qa|grep mysql
檢查系統中是否有安裝Mariadb
rpm -qa|grep mariadb
刪除自帶的Mariadb
rpm -e ——nodeps mariadb-libs-5。5。68-1。el7。x86_64
建立使用者和使用者組
groupadd mysqluseradd -r -g mysql mysql
安裝所需的基礎依賴
yum install -y gcc gcc-c++ cmake ncurses ncurses-devel bison openssl openssl-devel autoconf
建立資料夾
mkdir -p /usr/local/mysqlmkdir -p /usr/local/mysql/var/logmkdir -p /usr/local/mysql/var/runchown -R mysql：mysql /usr/local/mysql
下載安裝包
下載地址：https：//downloads。mysql。com/archives/community/wget https：//downloads。mysql。com/archives/get/p/23/file/mysql-boost-5。7。31。tar。gztar -zxvf mysql-boost-5。7。31。tar。gz -C /usr/local/mysql
開始編譯
cd /usr/local/mysqlcmake -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_BOOST=boost
開始安裝
make && make install
配置資料庫配置檔案
vim /etc/my。cnf
［client］port = 3306socket = /tmp/mysql。sock［mysqld］port = 3306socket = /tmp/mysql。sockuser = mysqlbasedir = /usr/local/mysqldatadir = /usr/local/mysql/datapid-file = /usr/local/mysql/var/run/mysql。pidlog_error = /usr/local/mysql/var/log/mysql-error。logslow_query_log = 1long_query_time = 1slow_query_log_file = /usr/local/mysql/var/log/mysql-slow。logskip-external-lockingkey_buffer_size = 32Mmax_allowed_packet = 1024Mtable_open_cache = 128sort_buffer_size = 768Knet_buffer_length = 8Kread_buffer_size = 768Kread_rnd_buffer_size = 512Kmyisam_sort_buffer_size = 8Mthread_cache_size = 16query_cache_size = 16Mtmp_table_size = 32Mperformance_schema_max_table_instances = 1000explicit_defaults_for_timestamp = true#skip-networkingmax_connections = 500max_connect_errors = 100open_files_limit = 65535log_bin=mysql-binbinlog_format=mixedserver_id = 232expire_logs_days = 10early-plugin-load = “”default_storage_engine = InnoDBinnodb_file_per_table = 1innodb_buffer_pool_size = 128Minnodb_log_file_size = 32Minnodb_log_buffer_size = 8Minnodb_flush_log_at_trx_commit = 1innodb_lock_wait_timeout = 50［mysqldump］quickmax_allowed_packet = 16M［mysql］no-auto-rehash［myisamchk］key_buffer_size = 32Msort_buffer_size = 768Kread_buffer = 2Mwrite_buffer = 2M
處理系統軟連結
ln -s /usr/local/mysql/bin/mysql /usr/bin/
初始化資料庫
/usr/local/mysql/bin/mysqld ——initialize-insecure ——user=mysql ——basedir=/usr/local/mysql ——datadir=/usr/local/mysql/data
複製支援檔案到系統
cd /usr/local/mysql/support-filescp mysql。server /etc/init。d/mysqld
加入系統服務
vim /usr/lib/systemd/system/mysql。serice
［Unit］Description=mysqlSourcePath=/etc/init。d/mysqldBefore=shutdown。target［Service］User=mysqlType=forkingExecStart=/etc/init。d/mysqld startExecStop=/etc/init。d/mysqld stop［Install］WantedBy=multi-user。target
系統伺服器指令
systemctl enable mysql #把mysql加入開機啟動systemctl disable mysql #把mysql從開機自啟動中移除systemclt start mysql #開啟mysqlsystemctl stop mysql #關閉mysqlsystemctl restart mysql #重啟mysql
