1.下載 MySQL 所需要的安裝包
????? ? 網(wǎng)址:https://dev.mysql.com/downloads/mysql/
2.Select Operating System: 選擇 Red Hat ,CentOS 是基于紅帽的,Select OS Version: 選擇 linux 7刻两,選擇 RPM Bundle 點(diǎn)擊 Download
3.不需要注冊(cè)筒扒!點(diǎn)擊?No thanks, just start my download. 進(jìn)行下載挽拔,裝個(gè)迅雷 速度嗖嗖的
4.連上你的虛擬機(jī)
5.創(chuàng)建一個(gè)目錄,把剛下載的包放進(jìn)去 ,我的目錄/usr/local/mysql
6.解壓:tar -xvf mysql-8.0.11-1.el7.x86_64.rpm-bundle.tar? 命令解壓?tar 包
7.安裝mysql 之前?通過?rpm -qa | grep mariadb 命令查看?mariadb 的安裝包(linux默認(rèn)裝了的,不刪除會(huì)導(dǎo)致mysql沖突歇式,刪掉!)
rpm -e mariadb-libs-5.5.56-2.el7.x86_64 --nodeps 命令裝卸?mariadb
8.下面開始安裝mysql?
1.rpm -ivh mysql-community-common-8.0.16-1.el7.x86_64.rpm --nodeps --force
2.rpm -ivh mysql-community-libs-8.0.16-1.el7.x86_64.rpm --nodeps --force
3.rpm -ivh?mysql-community-client-8.0.16-1.el7.x86_64.rpm??--nodeps --force
4.rpm -ivh?mysql-community-server-8.0.16-1.el7.x86_64.rpm??--nodeps --force
裝完之后命令查看下:rpm -qa | grep mysql??
9.通過以下命令胡野,完成對(duì) mysql 數(shù)據(jù)庫的初始化和相關(guān)配置
mysqld --initialize;
chown mysql:mysql /var/lib/mysql -R;
systemctl start mysqld.service;
systemctl? enable mysqld;
10.通過?cat /var/log/mysqld.log | grep password 命令查看數(shù)據(jù)庫的隨機(jī)生成的密碼
11. 登陸看看 mysql -uroot -p 密碼就上上面查出來的
12.登陸成功改個(gè)密碼材失,好記的~,
13.通過以下命令硫豆,進(jìn)行遠(yuǎn)程訪問的授權(quán)
create user 'root'@'%' identified with mysql_native_password by 'root';
grant all privileges on *.* to 'root'@'%' with grant option;
flush privileges;
14.通過?
ALTER USER 'root'@'localhost' IDENTIFIED BY 'root' PASSWORD EXPIRE NEVER;
window:alter user 'root'@'%' identified with mysql_native_password by 'Admin@123';
?命令修改加密規(guī)則龙巨,MySql8.0 版本 和 5.0 的加密規(guī)則不一樣,改完用?flush privileges; 命令刷新修該后的權(quán)限 最后退出 exit
15.通過以下命令熊响,關(guān)閉 firewall
systemctl stop firewalld.service;
systemctl disable firewalld.service;
systemctl mask firewalld.service;
16.通過?yum -y install iptables-services? 命令安裝 iptables 防火墻
17.通過以下命令啟動(dòng)設(shè)置防火墻
systemctl enable iptables;
systemctl start iptables;
18.通過 vim /etc/sysconfig/iptables 命令編輯防火墻旨别,添加端口,加入下面的配置(位置看圖):
-A INPUT -m state --state NEW -m tcp -p tcp --dport 80 -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 443 -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 8080 -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 8090 -j ACCEPT
18.通過?systemctl restart iptables.service 命令重啟防火墻使配置生效
19.通過?systemctl enable iptables.service 命令設(shè)置防火墻開機(jī)啟動(dòng)
20.用navicat 遠(yuǎn)程連接: