SUSE 12 SP 2 Install Mysql 5.7.16

 
mysqlをダウンロードします

wget -N -p /root/ http://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.16-1.sles12.x86_64.rpm-bundle.tar

ストレス解消mysql

tar -xvf /root/mysql-5.7.16-1.sles12.x86_64.rpm-bundle.tar -C /root/

mysqlインストール 

zypper ar -y /root/mysql-community-common-5.7.16-1.sles12.x86_64.rpm /root/mysql-community-libs-5.7.16-1.sles12.x86_64.rpm /root/mysql-community-client-5.7.16-1.sles12.x86_64.rpm /root/mysql-community-server-5.7.16-1.sles12.x86_64.rpm

mysqlを起動します

systemctl start --now mysql

rootパスワードの設定

mysql -uroot -p`cat  /var/log/mysql/mysqld.log | grep 'password is generated' | awk '{print $NF}'` --connect-expired-password -e "alter user root@localhost identified by 'Report@123';"

mysqlリモートログイン権限を付与します.

mysql -uroot -pReport@123 -e "update user set Host='%' where User='root'; ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'Report@123'; flush privileges;"