Suse Install Mysql 5.7.15

下载

wget  http://cdn.MySQL.com//Downloads/MySQL-5.7/mysql-5.7.15-1.sles11.x86_64.rpm-bundle.tar

解压
tar xvf mysql-5.7.15-1.sles11.x86_64.rpm-bundle.tar 

查看原来安装的Mysql
rpm -qa | grep mysql

安装Mysql安装顺序安装
rpm -ivh mysql-community-common-5.7.15-1.sles11.x86_64.rpm 
rpm -ivh mysql-community-libs-5.7.15-1.sles11.x86_64.rpm 
rpm -ivh mysql-community-client-5.7.15-1.sles11.x86_64.rpm 
rpm -ivh mysql-community-server-5.7.15-1.sles11.x86_64.rpm 

启动Mysql服务
service mysql start

查看MySQL服务器的状态 
service mysql status

设置开机启动   
chkconfig mysql on

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

初始化默认密码
mysql -uroot -p
ALTER USER 'root'@'localhost' IDENTIFIED BY 'Report@123';

允许root用户在任何地方进行远程登录，并具有所有库任何操作权限
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'Report@123' WITH GRANT OPTION;
FLUSH PRIVILEGES;