1. 安裝Mysql8

1.下載 安裝Mysql yum Repository

wget https://dev.mysql.com/get/mysql80-community-release-el8-4.noarch.rpm   #下載
yum localinstall mysql80-community-release-el8-4.noarch.rpm       #安裝
yum repolist all | grep mysql   #查看可安裝mysql版本列表，如果版本不對(duì)，修改/etc/yum.repos.d/mysql-community.repo文件
yum module disable mysql      #安裝
vi /etc/yum.repos.d/mysql-community.repo    #修改默認(rèn)的mysql服務(wù)器安裝版本，這里選擇8.0

/etc/yum.repos.d/mysql-community.repo文件選擇8.0后的版本列表，mysql80-community的狀態(tài)為enabled

2.安裝、啟動(dòng)、關(guān)閉、重啟Mysql，并查詢(xún)mysql狀態(tài)

yum install mysql-community-server   #安裝mysql
systemctl status mysqld       #查看mysql狀態(tài)
systemctl start mysqld   #啟動(dòng)mysql
systemctl stop mysqld   #關(guān)閉mysql
systemctl restart mysqld   #重啟mysql

mysql正常hi啟動(dòng)后的狀態(tài)顯示

3.設(shè)置mysql密碼

grep 'temporary password' /var/log/mysqld.log  #查看初始密碼
mysql -u root -p   #初始密碼登陸mysql控制臺(tái)，在控制臺(tái)中依次執(zhí)行以下sql，修改密碼
mysql>alter user 'root'@'localhost' identified by  'newpassword';   #修改密碼
mysql> flush privileges;   #刷新數(shù)據(jù)庫(kù)
mysql> quit  #退出mysql控制臺(tái)
vim /etc/my.cnf   #修改配置文件，刪除[mysqld]后面的免密登陸屬性“skip-grant-tables”
systemctl restart mysqld   #重啟mysql

3.允許客戶(hù)端遠(yuǎn)程連接

grant all privileges on *.* to 'root'@'localhost' with grant option; #先確保自己有授權(quán)權(quán)限
flush privileges;#刷新系統(tǒng)
use mysql;   #切換到mysql數(shù)據(jù)庫(kù)
create user 'root'@'%' identified by  'newpassword'; #創(chuàng)建新用戶(hù),這里的localhost換成%通配符，匹配所有host
grant all on *.* to 'root'@'%'; #放開(kāi)客戶(hù)端連接
flush privileges;#刷新系統(tǒng)

4.設(shè)置mysql編碼為utf8mb4，支持emoji表情文字等多字節(jié)數(shù)據(jù)

vim /etc/my.cnf   #修改配置文件，增加以下內(nèi)容
  ###################分割線########################
  [client]
  default-character-set = utf8mb4

  [mysql]
  default-character-set = utf8mb4
  
  [mysqld]
  character-set-client-handshake = FALSE
  character-set-server = utf8mb4
  collation-server = utf8mb4_unicode_ci
  init_connect='SET NAMES utf8mb4'
  ###################分割線########################
systemctl restart mysqld   #重啟mysql
mysql -u root -p   #登陸mysql控制臺(tái)
mysql> update user set authentication_string=password('newpassword') where user='root';   #關(guān)閉mysql

設(shè)置utf8mb4增加的配置

2、卸載MySQL

systemctl stop mysqld #停止mysql服務(wù)
yum list installed | grep mysql #查看含有mysql的服務(wù)
yum remove mysql-community-client mysql-community-common mysql-community-server mysql-community-libs #卸載mysql相關(guān)服務(wù)
whereis mysql #將列出來(lái)的內(nèi)容通過(guò) rm 命令刪除掉即可，至此，就可以將整個(gè)MySQL卸載了。