建立software目錄并切換
mkdir -p /opt/software && cd /opt/software

下載下傳mysql-RPM包
wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm
yum localinstall安裝mysql-RPM包,相比rpm -ivh方式,此方式會自動解決安裝依賴
yum localinstall mysql57-community-release-el7-8.noarch.rpm -y
yum repolist enabled | grep “mysql.-community.”
安裝mysql
yum install mysql-community-server -y
啟動mysql并設定開機自啟(檢視mysql目前狀态)
systemctl start mysqld
systemctl enable mysqld
systemctl status mysqld
擷取mysql初始密碼
grep ‘temporary password’ /var/log/mysqld.log
登入mysql
mysql -uroot -p’ZnOsap;&>2VC’
修改mysqlroot密碼
ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘[email protected]’;
或(alter user [email protected] identified by ‘[email protected]’;)