[root@bogon ~]# service mysql start
Redirecting to /bin/systemctl start mysql.service
[root@bogon ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.6.45 MySQL Community Server (GPL)
Copyright (c) 2000, 2019, 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> grant all privileges on . to root@"%" identified by "new_mysql";
Query OK, 0 rows affected (0.00 sec)
mysql> grant all privileges on . to root@"bogon" identified by "new_mysql";
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> quit
Bye
[root@bogon ~]# iptables -F
[root@bogon ~]# systemctl stop firewalld
[root@bogon ~]# systemctl disable firewalld
[root@bogon ~]# ifconfig
ens33: flags=4163 mtu 1500
inet 192.168.131.131 netmask 255.255.255.0 broadcast 192.168.131.255
inet6 fe80::20c:29ff:fe4e:4a5b prefixlen 64 scopeid 0x20<link>
ether 00:0c:29:4e:4a:5b txqueuelen 1000 (Ethernet)
RX packets 284 bytes 28044 (27.3 KiB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 395 bytes 31836 (31.0 KiB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0
lo: flags=73 mtu 65536
inet 127.0.0.1 netmask 255.0.0.0
inet6 ::1 prefixlen 128 scopeid 0x10<host>
loop txqueuelen 1000 (Local Loopback)
RX packets 0 bytes 0 (0.0 B)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 0 bytes 0 (0.0 B)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0
virbr0: flags=4099 mtu 1500
inet 192.168.122.1 netmask 255.255.255.0 broadcast 192.168.122.255
ether 52:54:00:d0:d8:4b txqueuelen 1000 (Ethernet)
RX packets 0 bytes 0 (0.0 B)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 0 bytes 0 (0.0 B)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0
[root@bogon ~]# ping www.baidu.com
PING www.a.shifen.com (163.177.151.109) 56(84) bytes of data.
64 bytes from 163.177.151.109 (163.177.151.109): icmp_seq=1 ttl=128 time=38.4 ms
64 bytes from 163.177.151.109 (163.177.151.109): icmp_seq=2 ttl=128 time=34.7 ms
64 bytes from 163.177.151.109 (163.177.151.109): icmp_seq=3 ttl=128 time=33.1 ms
^A64 bytes from 163.177.151.109 (163.177.151.109): icmp_seq=4 ttl=128 time=33.2 ms
64 bytes from 163.177.151.109 (163.177.151.109): icmp_seq=5 ttl=128 time=30.1 ms
64 bytes from 163.177.151.109 (163.177.151.109): icmp_seq=6 ttl=128 time=32.9 ms
64 bytes from 163.177.151.109 (163.177.151.109): icmp_seq=7 ttl=128 time=47.0 ms
http://img.mukewang.com/climg/5d3d2999000169bb05660668.jpg
虚拟机网络是通的
Navicat的ip地址也没错
root的密码也没错
为什么就是连接不上呢？
https://blog.csdn.net/qq_40087740/article/details/80897693
出现该问题可能的原因：
1、网络不通；
2、服务未启动；
3、防火墙未关闭；
4、服务器上防火墙端口未开放；
5、端口未被监听；
6、权限不足。
也可以参考下，连接MySQL的10060错误:Can't connect to MySQL server on '*.*.*.*'(10060)：https://www.cnblogs.com/mmzs/p/9201558.html
看下你的服务器的 MySQL 配置的 user 表中 root 帐号的 host 列是不是限定了本机访问了：
use mysql;update user set host='%' where user='root';flush privileges;
1.先查看下虚拟机里面的防火墙
2.然后在外面ping以下你的虚拟机的ip
3.然后telnet下你的端口