下載:
wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
安裝:
yum -y install mysql80-community-release-el7-3.noarch.rpm
yum install mysql-community-server
開啟服務(wù)
systemctl start? mysqld.service
獲取臨時密碼:
grep "password"? /var/log/mysqld.log
設(shè)置密碼:
先用臨時密碼登陸
mysql -uroot -p
->mysql? set global validate_password.policy=0;
->mysql? set global validate_password.length=1;
再設(shè)置自己的密碼
->mysql? alter user 'root'@'localhost' identified by '123456';
開啟遠(yuǎn)程訪問:(?mysql默認(rèn)不允許遠(yuǎn)程登錄,所以需要開啟遠(yuǎn)程訪問權(quán)限 )
mysql -uroot -p
->mysql? use mysql;
->mysql? select user,authentication_string,host from user;
->mysql? update user set host = '%' where user = 'root';
->mysql? FLUSH PRIVILEGES;
->mysql? alter user 'root'@'%' identified with mysql_native_password by '123456';