1.背景
centos7安裝mysql8.0
2.安裝步驟
步驟一：安裝準備工作
1．檢視是否有安裝過mysql
rpm -qa | grep -i mysql
2．删除mysql
yum -y remove MySQL-*
3．把所有出現的目錄統統删除
find / -name mysql
4．删除配置檔案
rm -rf /etc/my.cnf 步驟二：下載下傳安裝包
sudo rpm -Uvh https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
步驟三：安裝
sudo yum --enablerepo=mysql80-community install mysql-community-server
步驟四：啟動-狀态檢視
// 啟動
sudo service mysqld start
// 狀态檢視
service mysqld status
步驟五：檢視臨時密碼 登入
grep "A temporary password" /var/log/mysqld.log
mysql -uroot -p
步驟六：修改臨時密碼
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'Admin123@';
Query OK, 0 rows affected (0.44 sec)
步驟七：配置遠端通路
1.檢視目前使用者
select host, user, authentication_string, plugin from user;
2.添加一個使用者
CREATE USER 'root'@'%' IDENTIFIED BY 'Admin123@';
3.設定權限
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
Query OK, 0 rows affected (0.14 sec)
步驟九：修改加密方式,避免用戶端連結報錯
原因是mysql8的加密方式規則不一樣，是caching_sha2_password
需要加密方式改成mysql_native_password就行了
文法:ALTER USER ‘[使用者名]’@’%’ IDENTIFIED WITH mysql_native_password BY ‘[密碼]’;
輸入：ALTER USER ‘root’@’%’ IDENTIFIED WITH mysql_native_password BY ‘Admin123@’;
加密方式以及改成了mysql_native_password
mysql> ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'Admin123@';
Query OK, 0 rows affected (1.10 sec)
步驟十：重新整理配置生效
mysql> flush privileges;
Query OK, 0 rows affected (0.13 sec)
3.連結測試
連結成功後,該使用者支援資料庫建立等很多權限1