服務(wù)器版本為centos7

最新版mysql下載地址：MySQL :: Download MySQL Community Server

現(xiàn)在的服務(wù)器應(yīng)該都支持64位了，下載64位即可

1.首先新建文件夾，并進(jìn)入該文件夾，將下載好的mysql文件上傳至此文件夾，

mkdir /local && cd /local

?2.解壓及創(chuàng)建目錄

tar -zxvf mysql-5.7.36-linux-glibc2.12-x86_64.tar.gz mv mysql-5.7.36-linux-glibc2.12-x86_64 mysql mkdir mysql/arch mysql/data mysql/tmp

3.編輯my.cnf文件

[client] port = 3306 socket = /local/mysql/data/mysql.sock default-character-set=utf8mb4[mysqld] port = 3306 socket = /local/mysql/data/mysql.sockskip-slave-startskip-external-locking key_buffer_size = 256M sort_buffer_size = 2M read_buffer_size = 2M read_rnd_buffer_size = 4M query_cache_size= 32M max_allowed_packet = 16M myisam_sort_buffer_size=128M tmp_table_size=32Mtable_open_cache = 512 thread_cache_size = 8 wait_timeout = 86400 interactive_timeout = 86400 max_connections = 600# Try number of CPU's*2 for thread_concurrency #thread_concurrency = 32 #isolation level and default engine default-storage-engine = INNODB transaction-isolation = READ-COMMITTEDserver-id = 1739 basedir = /local/mysql datadir = /local/mysql/data pid-file = /local/mysql/data/hostname.pid#open performance schema log-warnings sysdate-is-nowbinlog_format = ROW log_bin_trust_function_creators=1 log-error = /local/mysql/data/hostname.err log-bin = /local/mysql/arch/mysql-bin expire_logs_days = 30innodb_write_io_threads=16relay-log = /local/mysql/relay_log/relay-log relay-log-index = /local/mysql/relay_log/relay-log.index relay_log_info_file= /local/mysql/relay_log/relay-log.infolog_slave_updates=1 gtid_mode=OFF enforce_gtid_consistency=OFF# slave slave-parallel-type=LOGICAL_CLOCK slave-parallel-workers=4 master_info_repository=TABLE relay_log_info_repository=TABLE relay_log_recovery=ON#other logs #general_log =1 #general_log_file = /local/mysql/data/general_log.err #slow_query_log=1 #slow_query_log_file=/local/mysql/data/slow_log.err#for replication slave sync_binlog = 500#for innodb options innodb_data_home_dir = /local/mysql/data/ innodb_data_file_path = ibdata1:1G;ibdata2:1G:autoextendinnodb_log_group_home_dir = /local/mysql/arch innodb_log_files_in_group = 4 innodb_log_file_size = 1G innodb_log_buffer_size = 200M#根據(jù)生產(chǎn)需要，調(diào)整pool size innodb_buffer_pool_size = 8G #innodb_additional_mem_pool_size = 50M #deprecated in 5.6 tmpdir = /local/mysql/tmpinnodb_lock_wait_timeout = 1000 #innodb_thread_concurrency = 0 innodb_flush_log_at_trx_commit = 2innodb_locks_unsafe_for_binlog=1#innodb io features: add for mysql5.5.8 performance_schema innodb_read_io_threads=4 innodb-write-io-threads=4 innodb-io-capacity=200 #purge threads change default(0) to 1 for purge innodb_purge_threads=1 innodb_use_native_aio=on#case-sensitive file names and separate tablespace innodb_file_per_table = 1 lower_case_table_names=1[mysqldump] quick max_allowed_packet = 128M[mysql] no-auto-rehash default-character-set=utf8mb4[mysqlhotcopy] interactive-timeout[myisamchk] key_buffer_size = 256M sort_buffer_size = 256M read_buffer = 2M write_buffer = 2M

4.創(chuàng)建用戶組及用戶

groupadd -g 101 dba useradd -u 514 -g dba -G root -d /local/mysql mysqladmin id mysqladmin

5.copy 環(huán)境變量配置文件至mysqladmin用戶的home目錄中,為了以下步驟配置個(gè)人環(huán)境變量

cp /etc/skel/.* /local/mysql

6.配置環(huán)境變量，增加兩行

vim /local/mysql/.bash_profile export MYSQL_BASE=/local/mysql export PATH=${MYSQL_BASE}/bin:$PATH

7.賦權(quán)限和用戶組，

chown mysqladmin:dba /etc/my.cnf chmod 640 /etc/my.cnf chown -R mysqladmin:dba /local/mysql chmod -R 755 /local/mysql

8.配置服務(wù)及開(kāi)機(jī)自啟動(dòng)

cd /local/mysql

#將服務(wù)文件拷貝到init.d下，并重命名為mysql

cp support-files/mysql.server /etc/rc.d/init.d/mysql

#賦予可執(zhí)行權(quán)限?

chmod +x /etc/rc.d/init.d/mysql

#刪除服務(wù)

chkconfig --del mysql

#添加服務(wù)

chkconfig --add mysql chkconfig --level 2345 mysql on

9.安裝libaio及安裝mysql的初始db

yum -y install libaio ./bin/mysqld --defaults-file=/etc/my.cnf --user=mysqladmin --basedir=/local/mysql/ --datadir=/local/mysql/data/ --initialize

#在初始化時(shí)如果加上 –initial-insecure，則會(huì)創(chuàng)建空密碼的 root@localhost 賬號(hào)，否則會(huì)創(chuàng)建帶密碼的 root@localhost 賬號(hào)，密碼直接寫在 log-error 日志文件中
?

10.查看臨時(shí)密碼

cat /local/mysql/data/hostname.err |grep password

11.啟動(dòng)mysql

#切換用戶

sudo su - mysqladmin

#啟動(dòng)mysql

service mysql start

12.登錄及修改用戶密碼

#密碼在第10個(gè)步驟

mysql -uroot -p alter user root@localhost identified by 'passwdinfo'; GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'passwdinfo' ; flush privileges; exit;

13.重啟

service mysql restart

總結(jié)

以上是生活随笔為你收集整理的mysql5.7版本安装部署详细步骤的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。