rpm包方式安装mysql5.6

0987iu

查看是包含和安装mysql，有的话先删除
[iyunv@server1 opt]# rpm -qa | grep -i mysql
mysql-libs-5.1.71-1.el6.x86_64
[iyunv@server1 opt]# yum -y remove mysql-libs*
下载mysql rpm安装包
MySQL-server-5.6.35-1.el6.x86_64.rpm
MySQL-client-5.6.35-1.el6.x86_64.rpm
MySQL-devel-5.6.35-1.el6.x86_64.rpm
[iyunv@server1 MySQL-5.6.35-1.el6.x86_64.rpm-bundle]# rpm -ivh MySQL-server-5.6.35-1.el6.x86_64.rpm
[iyunv@server1 MySQL-5.6.35-1.el6.x86_64.rpm-bundle]# rpm -ivh MySQL-client-5.6.35-1.el6.x86_64.rpm
[iyunv@server1 MySQL-5.6.35-1.el6.x86_64.rpm-bundle]# rpm -ivh MySQL-devel-5.6.35-1.el6.x86_64.rpm
可能会出现依赖包不存在的情况 直接用yum安装即可
复制mysql配置文件
[iyunv@server1 MySQL-5.6.35-1.el6.x86_64.rpm-bundle]# cp /usr/share/mysql/my-default.cnf /etc/my.cnf
查看mysql初始密码
[iyunv@server1 MySQL-5.6.35-1.el6.x86_64.rpm-bundle]# more /root/.mysql_secret
# The random password set for the root user at Wed Jan 18 14:32:33 2017 (local time): h7LDPJpSSXB9ErhR
启动mysql服务
[iyunv@server1 MySQL-5.6.35-1.el6.x86_64.rpm-bundle]# service mysql start
用初始密码登陆mysql
[iyunv@server1 MySQL-5.6.35-1.el6.x86_64.rpm-bundle]# mysql -uroot -ph7LDPJpSSXB9ErhR
修改密码为自己的密码 此处设为了root
mysql> SET PASSWORD = PASSWORD('root');
Query OK, 0 rows affected (0.00 sec)
mysql> exit
Bye
设置开机启动
[iyunv@server1 MySQL-5.6.35-1.el6.x86_64.rpm-bundle]# chkconfig mysql on
[iyunv@server1 MySQL-5.6.35-1.el6.x86_64.rpm-bundle]# chkconfig --list mysql