suse 12 sp1 安装 mysql5.7.16

下载
wget  http://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.16-1.sles12.x86_64.rpm-bundle.tar 

rpm -qa | grep mysql

解压mysql
tar -xvf mysql-5.7.16-1.sles12.x86_64.rpm-bundle.tar 

安装mysql
rpm -ivh mysql-community-common-5.7.16-1.sles12.x86_64.rpm 
rpm -ivh mysql-community-libs-5.7.16-1.sles12.x86_64.rpm 
rpm -ivh mysql-community-client-5.7.16-1.sles12.x86_64.rpm 
rpm -ivh mysql-community-server-5.7.16-1.sles12.x86_64.rpm 

启动mysql
systemctl start mysql

开机启动mysql
systemctl enable mysql

生成随机密码
grep 'temporary password' /var/log/mysql/mysqld.log

初始化默认密码
mysql -uroot -p
ALTER USER 'root'@'localhost' IDENTIFIED BY 'Report@123';
FLUSH PRIVILEGES;
允许root用户在任何地方进行远程登录，并具有所有库任何操作权限
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'Report@123' WITH GRANT OPTION;
FLUSH PRIVILEGES;