一、進(jìn)入官網(wǎng)
二、確定對(duì)應(yīng)的下載網(wǎng)址
1.點(diǎn)擊直接下載
2.出現(xiàn)
No thanks, just start my download.
也就是：https://cdn.mysql.com//archives/mysql-8.0/mysql-8.0.13-linux-glibc2.12-x86_64.tar.xz
三、linux確認(rèn)wget
yun install wget
四、下載剛才的文件
wget https://cdn.mysql.com//archives/mysql-8.0/mysql-8.0.13-linux-glibc2.12-x86_64.tar.xz
五、解壓
可以先創(chuàng)建一個(gè)mysql目錄，然后移動(dòng)（mv mysql-8.0.13-linux-glibc2.12-x86_64.tar.xz /mysql）剛才的文件進(jìn)去，或者一開始就在這個(gè)目錄下 ,并且重命名
mkdir mysql
mkdir /data/mysql8_data/mysql/mysql-bin
mv mysql-8.0.13-linux-glibc2.12-x86_64.tar.xz /mysql
cd mysql
tar -xvf mysql-8.0.13-linux-glibc2.12-x86_64.tar.xz
mv /mysql/mysql-8.0.13-linux-glibc2.12-x86_64 /usr/local/mysql8.0/
六、刪除center os 自帶mariadb
1.這個(gè)mariadb是自帶的一個(gè)類似Mysql的數(shù)據(jù)，要先確認(rèn)下有沒有。不然安裝mysql會(huì)出現(xiàn)問題
rpm -qa | grep mariadb
2.刪除對(duì)應(yīng)的數(shù)據(jù)庫
rpm -e mariadb-libs-5.5.60-1.el7_5.x86_64 --nodeps
七、添加命令路徑到系統(tǒng)中
vi /etc/profile
export PATH=$PATH:/usr/local/mysql8.0//bin
export PATH=$PATH:/usr/local/mysql8.0//support-files
#生效
source /etc/profile
八、用戶組信息
1.創(chuàng)建用戶及用戶組
用戶組
groupadd mysql
** 用戶 （用戶名/密碼）**
useradd -g mysql mysql
2.授權(quán)
chown -R mysql.mysql /usr/local/mysql8.0/
chown -R mysql.mysql /data/mysql8_data/
九、初始化
配置腳本
[mysql]
# 默認(rèn)字符集
default-character-set=utf8mb4
[client]
port = 3306
socket = /tmp/mysql.sock
[mysqld]
port = 3306
server-id = 3306
user = mysql
socket = /tmp/mysql.sock
# 安裝目錄
basedir = /usr/local/mysql8.0
# 數(shù)據(jù)存放目錄
datadir = /data/mysql8_data/mysql
log-bin = /data/mysql8_data/mysql/mysql-bin
innodb_data_home_dir =/data/mysql8_data/mysql
innodb_log_group_home_dir =/data/mysql8_data/mysql
# 日志及進(jìn)程數(shù)據(jù)的存放目錄
log-error =/data/mysql8_data/mysql/mysql.log
pid-file =/data/mysql8_data/mysql/mysql.pid
# 服務(wù)端字符集
character-set-server=utf8mb4
#大小寫不敏感
lower_case_table_names=1
autocommit =1
##### 以上涉及文件夾明，注意修改
skip-external-locking
key_buffer_size = 256M
max_allowed_packet = 1M
table_open_cache = 1024
sort_buffer_size = 4M
net_buffer_length = 8K
read_buffer_size = 4M
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 64M
thread_cache_size = 128
#query_cache_size = 128M
tmp_table_size = 128M
explicit_defaults_for_timestamp = true
max_connections = 500
max_connect_errors = 100
open_files_limit = 65535
binlog_format=mixed
binlog_expire_logs_seconds =864000
# 創(chuàng)建表時(shí)使用的默認(rèn)存儲(chǔ)引擎
default_storage_engine = InnoDB
innodb_data_file_path = ibdata1:10M:autoextend
innodb_buffer_pool_size = 1024M
innodb_log_file_size = 256M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
transaction-isolation=READ-COMMITTED
#跳過驗(yàn)證
#skip-grant-tables
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer_size = 256M
sort_buffer_size = 4M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
初始化與刪除
#1、初始化
mysqld --initialize --user=mysql
#2、移除
mysqld remove
如果出現(xiàn)libaio的問題，那么 查看mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such f_y
初始化后，當(dāng)中有信息為賬戶密碼信息
**A temporary password is generated for root@localhost: (ApP.Zu_R6hp
十、啟動(dòng)服務(wù)
mysql.server start
出現(xiàn)了報(bào)錯(cuò)，那么需要查看對(duì)應(yīng)的support-files/mysql.server 命令內(nèi)容,配置安裝路徑。
保存后，重新啟動(dòng)
十一、登錄
mysql -uroot -p
輸入先前的密碼進(jìn)行登錄
十二、修改密碼
alter user 'root'@'localhost' identified by 'Tyjs@2023';
重新登錄成功
十三、設(shè)置允許遠(yuǎn)程訪問，遠(yuǎn)程連接報(bào)錯(cuò)可嘗試修改加密方式：
#新建用戶遠(yuǎn)程訪問
CREATE USER 'root'@'%' IDENTIFIED BY '密碼';
grant all privileges on *.* to 'root'@'%';
#刷新權(quán)限
FLUSH PRIVILEGES;
#修改密碼加密方式
alter user 'root'@'%' identified with mysql_native_password by '你的密碼';
十四、數(shù)據(jù)庫初始化腳本
①先登錄mysql數(shù)據(jù)庫,輸入命令
mysql -u root -p
②再使用數(shù)據(jù)庫testDB, 進(jìn)入數(shù)據(jù)庫 use testDB
use testDB
③導(dǎo)入備份文件.
source /home/testDB.sql
以上就完成了數(shù)據(jù)的備份和恢復(fù)操作?。?！
MySQL備份腳本寫入Crontab計(jì)劃性任務(wù)之后生成的備份文件大小為0解決方法，MySQL的mysqldump未識(shí)別。
方法一
source /etc/profile
方法二
mysqldump 修改為絕對(duì)路徑 /usr/local/mysql/bin/mysqldump ...
