CentOS7快速安裝mysql5.7

1. 擷取安裝包

   wget https://repo.mysql.com/mysql57-community-release-el7.rpm
              

2. 安裝

   rpm -ivh mysql57-community-release-el7.rpm
   yum -y install mysql mysql-server
              

3. 啟動

   systemctl start mysqld.service 
   systemctl enable mysqld.service  # 設定開機自啟
              

4. 檢視密碼

   grep 'temporary password' /var/log/mysqld.log
              

5. 登入

   mysql -u root -p 
   ## 輸入步驟4顯示的密碼
              

6. 修改密碼

   use mysql;
   set password for [email protected] = password('root'); # 修改密碼
   update mysql.user set host="%" where user="root"; ##設定遠端通路權限
   flush privileges; # 立即生效