1、下載軟體包：mysql-8.0.15-1.el7.x86_64.rpm-bundle.tar和mysql-connector-java-8.0.15.zip檔案，
2、將軟體包通過moba上傳到linux系統，/usr/local/soft/
3、解壓軟體包
tar -xvf mysql-8.0.15-1.el7.x86_64.rpm-bundle.tar
4、卸載系統自帶mariadb
rpm -qa | grep mariadb
yum -y remoe mariadb-libs-5.5.52-1.el7.x86_64v
5、下載依賴包
yum -y install openssl-devel perl-JSON
yum install -y libaio.x86_64 libaio-devel.x86_64
yum install -y openssl-devel.x86_64 openssl.x86_64
yum install -y perl.x86_64 perl-devel.x86_64
yum install -y perl-JSON.noarch
yum install -y autoconf
yum install net-tools -y
6、順序安裝mysql
rpm -ivh mysql-community-common-8.0.15-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.15-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-8.0.15-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-8.0.15-1.el7.x86_64.rpm
rpm -ivh mysql-community-devel-8.0.15-1.el7.x86_64.rpm
安裝完默認是mysql用戶、用戶組和權限
chown -R mysql:mysql /var/lib/mysql/
7、重啟mysql服務
systemctl restart mysqld.service
systemctl status mysqld.service
若啟動失敗查看：
tail -n 100 /var/log/mysqld.log
8、查看密碼
cat /var/log/mysqld.log | grep password
或
cd /var/log/
cat mysqld.log
9、資料庫登陸
mysql -u root -p
輸入第八步中的密碼進行登陸
10、設定登陸密碼復雜度
set global validate_password.length=4;
set global validate_password.policy=0;
SHOW VARIABLES LIKE 'validate_password%';
11、修改密碼
ALTER USER 'root'@'localhost' IDENTIFIED BY 'root123';
flush privileges;
12、開放所有IP都能訪問
use mysql;
select host, user, authentication_string, plugin from user;
CREATE USER 'root'@'%' IDENTIFIED BY 'root123';
grant all privileges ON *.* to 'root'@'%' with grant option;
flush privileges;
13、修改加密方式
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'root123';
select host, user, authentication_string, plugin from user;
14、重啟資料庫
quit
/bin/systemctl restart mysqld.service
或：systemctl start mysqld
設定開機自啟動
systemctl enable mysqld.service
15、遠程navicat連接測驗
創建名字為hive的資料庫
轉載請註明出處，本文鏈接：https://www.uj5u.com/qita/379434.html
標籤：其他
上一篇：從零搭建秒殺系統
下一篇：Shell基礎知識