第一步:下載RPM包
wget http://repo.mysql.com/mysql57-community-release-el7-10.noarch.rpm
第二步:安裝軟件源
rpm? -Uvh mysql57-community-release-el7-10.noarch.rpm
第三步:安裝服務端
yum install -y mysql-community-server
第四步:啟動mysql
service mysqld start
systemctl start mysqld.service
第五步:查找默認密碼
grep 'temporary password' /var/log/mysqld.log
第六步:登陸并修改密碼
修改密碼: ALTER USER 'root'@'localhost' IDENTIFIED BY '密碼';
密碼過于簡單:
(1),修改validate_password_policy參數(shù)的值
set global validate_password_policy=0;
(2),再修改密碼的長度
set global validate_password_length=1;
(3),修改密碼
ALTER USER 'root'@'localhost' IDENTIFIED BY '密碼';
第七步:授權(quán)其他機器登陸
GRANT ALL PRIVILEGES ON *.* TO 'root' @ '%' IDENTIFIED BY '數(shù)據(jù)庫密碼' WITH GRANT OPTION;
FLUSH PRIVILEGES;
第八步:數(shù)據(jù)庫重啟
service mysqld restart
systemctl restart mysqld.service
