zheng安装 mysql5.6安装

mysql下载：

https://downloads.mysql.com/archives/community/

https://dev.mysql.com/downloads/mysql/

一、卸载mysql旧版本

 rpm -qa |grep mysql
 rpm -e --nodeps mysql-devel-5.1.73-8.el6_8.x86_64 mysql-5.1.73-8.el6_8.x86_64 mysql-libs-5.1.73-8.el6_8.x86_64

二、mysql安装

 rpm -ivh MySQL-devel-5.6.38-1.el6.x86_64.rpm MySQL-client-5.6.38-1.el6.x86_64.rpm
 rpm -ivh MySQL-server-5.6.38-1.el6.x86_64.rpm

三、启动mysql

service mysql start

四、设置开机启动

chkconfig --levels 235 mysql on

五、查看生成的随机mysqld数据库密码

 cat /root/.mysql_secret

输出如下：

<span style="color:#3366ff"># The random password set for the root user at Mon Feb 12 11:12:52 2018 (local time): qsW4PZWV7eHExUuI</span>

六、用刚才生成的密码登陆mysql

mysql -uroot -p

七、修改密码策略

SET PASSWORD = PASSWORD('zsl@1234')
grant ALL PRIVILEGES ON *.* to root@"%" identified by "zsl@1234" WITH GRANT OPTION; 
flush privileges;

八、使用MySQL Workbench软件将uac数据导入到mysql数据库中。