1.先下载mysql5.6的rpm
链接:https://pan.baidu.com/s/1atBhYURE_EPOVgS6TGEnXQ 密码:8nzq
2.将mysql文件上传至虚拟机
3. 查看centos安装的mysql
[root@localhost local]# rpm -qa|grep mysql
mysql-libs-5.1.71-1.el6.x86_64
4.卸载mysql
[root@localhost local]# rpm -e --nodeps mysql-libs-5.1.71-1.el6.x86_64
5.解压mysql
[root@localhost mysql]# tar -xvf MySQL-5.6.39-1.el6.x86_64.rpm-bundle.tar
MySQL-embedded-5.6.39-1.el6.x86_64.rpm
MySQL-test-5.6.39-1.el6.x86_64.rpm
MySQL-shared-5.6.39-1.el6.x86_64.rpm
MySQL-server-5.6.39-1.el6.x86_64.rpm
MySQL-devel-5.6.39-1.el6.x86_64.rpm
MySQL-client-5.6.39-1.el6.x86_64.rpm
MySQL-shared-compat-5.6.39-1.el6.x86_64.rpm
6.通过rpm -ivh安装(按照顺序)
[root@localhost mysql]# rpm -ivh MySQL-client-5.6.39-1.el6.x86_64.rpm
[root@localhost mysql]# rpm -ivh MySQL-devel-5.6.39-1.el6.x86_64.rpm
[root@localhost mysql]# rpm -ivh MySQL-server-5.6.39-1.el6.x86_64.rpm
[root@localhost mysql]# rpm -ivh MySQL-shared-5.6.39-1.el6.x86_64.rpm
7. mysql5.6数据库会自动生成随机密码, 通过安装的日志查询到密码在 /root/.mysql_secret 文件里
.
8. 复制生成的随机密码
[root@localhost ~]# cat .mysql_secret
# The random password set for the root user at Sat Sep 15 11:25:09 2018 (local time): 0NHZ5NAnEpBNDBBT
9.启动mysql
[root@localhost ~]# service mysql start
10.第一次密码就使用刚拷贝.mysql_secret文件里的随机密码:0NHZ5NAnEpBNDBBT
[root@localhost ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.6.39
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> exit
Bye
11.设置密码
mysql> set password = password('123456');
Query OK, 0 rows affected (0.01 sec)
mysql> exit
Bye
12.添加服务 和开机自启
[root@localhost ~]# chkconfig --add mysql
[root@localhost ~]# chkconfig mysql on
13. 这时候通过navicat 链接数据库还是链接不了 ,进入mysql设置连接用户
mysql> grant all privileges on *.* to 'root' @'%' identified by '123456';
Query OK, 0 rows affected (0.01 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> exit
Bye
14.开放系统端口
[root@localhost ~]# /sbin/iptables -I INPUT -p tcp --dport 3306 -j ACCEPT
[root@localhost ~]# /etc/rc.d/init.d/iptables save
iptables: Saving firewall rules to /etc/sysconfig/iptables:[ OK ]
完成 !