1. 下載mysql源: wget https://repo.mysql.com/mysql80-community-release-el7.rpm
2. 安裝mysql源: yum -y localinstall mysql80-community-release-el7.rpm
3. 在線安裝MySQL: yum -y install mysql-community-server
4. 啟動(dòng)Mysql服務(wù): systemctl start mysqld
5. 設(shè)置開機(jī)啟動(dòng): systemctl enable mysqld; systemctl daemon-reload
6. 修改root本地登錄密碼: grep "A temporary password is generated for root@localhost" /var/log/mysqld.log (查看默認(rèn)密碼)
7. 更改root賬戶臨時(shí)密碼: ALTER USER 'root'@'localhost' IDENTIFIED BY 'Waizsy@9083';
8. 遠(yuǎn)程訪問(wèn): 修改mysql庫(kù)user表 update user set host = '%' where user = 'root'; GRANT ALL ON *.* TO 'root'@'%'; FLUSH PRIVILEGES
9. mysql8.0密碼策略默認(rèn)為caching_sha2_password。與5.7策略caching_sha_password有所不同 (現(xiàn)在有很多語(yǔ)言及連接工具不支持);
9.1 ALTER USER 'root'@'%' IDENTIFIED BY 'Waizsy@9083' PASSWORD EXPIRE NEVER;
9.2 ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'Waizsy@9083';
9.3 FLUSH PRIVILEGES; (配置生效)
1. 配置主庫(kù):
vim /etc/my.cnf
[mysqld]
log-bin=mysql-bin #同步的日志路徑及文件名,一定注意這個(gè)目錄要是mysql有權(quán)限寫入的(配置不成功就用默認(rèn))
server-id=1 #master端的ID號(hào)
binlog-do-db=test #要同步的數(shù)據(jù)庫(kù)名
binlog-ignore-db = mysql #不同步mysql庫(kù)
重啟服務(wù):service mysqld restart
查看bin-log: show master status;
2. 創(chuàng)建訪問(wèn)用戶:
CREATE USER 'salveUsers'@'%' IDENTIFIED BY 'salveUsers@1234'; #創(chuàng)建用戶
GRANT ALL PRIVILEGES ON *.* TO 'salveUsers'@'%' IDENTIFIED BY 'salveUsers@1234'; #授權(quán)給從數(shù)據(jù)庫(kù)服務(wù)器權(quán)限
3. 配置從庫(kù)
CHANGE MASTER TO MASTER_HOST='192.168.204.128',MASTER_PORT=3306,MASTER_USER='salveUsers',MASTER_PASSWORD='salveUsers@1234',MASTER_LOG_FILE='mysql-bin.000001',MASTER_LOG_POS=155;
start slave; #啟動(dòng)slave進(jìn)程
show slave status\G #查看slave進(jìn)程狀態(tài) Slave_IO_Running: Yes; Slave_SQL_Running: Yes 表示配置正確