1.安裝環(huán)境
此教程適用于centos7.0及以上兼容版本的安裝
2.實(shí)現(xiàn)方案
①運(yùn)行以下命令
- 安裝MySQL5.7
wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm;
yum -y install mysql57-community-release-el7-10.noarch.rpm;
（下面出錯(cuò)如果是秘鑰過(guò)期執(zhí)行下面語(yǔ)句 rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022）
yum -y install mysql-community-server;
systemctl start mysqld.service;
systemctl status mysqld.service;
yum -y remove mysql57-community-release-el7-10.noarch;
grep "password" /var/log/mysqld.log;
- 安裝MySQL8.0
wget https://repo.mysql.com//mysql80-community-release-el7-3.noarch.rpm
yum -y install mysql80-community-release-el7-3.noarch.rpm
上面報(bào)錯(cuò)執(zhí)行 rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
3.默認(rèn)安裝MySQL8.0洒宝，如果需要安裝MySQL5.7的話需要修改/etc/yum.repos.d/mysql-community.repo配置文件
將mysql80中enabled屬性改為0誓禁，并添加圖中紅框內(nèi)代碼(安裝MySQL8.0跳過(guò)該步驟)
image.png
yum -y install mysql-community-server
systemctl start mysqld.service
cat /var/log/mysqld.log | grep password
大約等待3分鐘，然后會(huì)生成一個(gè)root用戶的隨機(jī)密碼
image
②復(fù)制該密碼禀忆，mysql -u root -p
③粘貼隨機(jī)密碼，不顯示密碼，直接回車登錄
image
設(shè)置密碼策略
mysql5.7
set global validate_password_policy=0;
mysql8.0
set global validate_password.policy=0;
然后將隨機(jī)密碼修改成自己定義的密碼
ALTER USER 'root'@'localhost' IDENTIFIED BY '你想設(shè)置的密碼';
③然后重新登錄mysql哈踱，創(chuàng)建mysql用戶
CREATE USER '你的用戶名'@'%' IDENTIFIED BY '你的密碼';
④對(duì)所有庫(kù)授權(quán)
grant all on *.* to '你創(chuàng)建的用戶名'@'%';
或者對(duì)指定庫(kù)進(jìn)行授權(quán)
grant all on庫(kù)名.* to '你創(chuàng)建的用戶名'@'%';
⑤刷新權(quán)限
flush privileges;
⑥開(kāi)放3306端口
firewall-cmd --zone=public --add-port=3306/tcp --permanent
⑦重啟防火墻
firewall-cmd --reload
⑧navicat連接mysql
image
轉(zhuǎn)載：centos7.0快速安裝mysql
