centos7的yum源中沒有mysql安裝包。
先在linux中安裝wget的命令
yum install wget
再使用wget獲取網(wǎng)絡(luò)上的mysql安裝包
wget https://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm
需要放置到本地倉庫中
rpm -ivh mysql57-community-release-el7-9.noarch.rpm進(jìn)入倉庫運(yùn)行安裝mysql的代碼
cd /etc/yum.repos.d/
yum -y install mysql-server
安裝報錯,提示無公共秘鑰
解決方法:
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
然后再次安裝
啟動mysql服務(wù)
systemctl start mysqld.service
查看臨時密碼
grep 'temporary password' /var/log/mysqld.log
登錄mysql
mysql -uroot -p
設(shè)置密碼策略為低
set global validate_password_policy=LOW;
設(shè)置密碼
set password for root@localhost = password('aaa123') ;
給防火墻加白名單,放開3306端口?;蛘哧P(guān)閉防火墻。
設(shè)置遠(yuǎn)程訪問權(quán)限
grant all privileges on . to root@'%' identified by 'aaa123';
flush privileges;