MYSQL
添加源 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
安裝 yum -y install mysql-community-server
啟動(dòng) systemctl start mysqld.service
-
查看狀態(tài) systemctl status mysqld.service
查看狀態(tài) -
查看密碼 grep "password" /var/log/mysqld.log
查看密碼
- 登陸MySQL mysql -u root -p
- 修改密碼 ALTER USER 'root'@'localhost' IDENTIFIED BY 'new password';
-
密碼過(guò)于簡(jiǎn)單設(shè)置不成功
密碼設(shè)置不成功
設(shè)置密碼安全等級(jí)
set global validate_password_policy=0;
set global validate_password_length=1;
- 移除源 yum -y remove mysql57-community-release-el7-10.noarch
- 授權(quán)遠(yuǎn)端連接 grant all on . to root@'%' identified by 'password';
