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数据库中。