夜空中的星x 2019-07-28 13:14 采纳率: 0%
浏览 1119

Navicat 连接不上虚拟机centos的mysql

[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的密码也没错

为什么就是连接不上呢?

  • 写回答

4条回答

  • dabocaiqq 2019-07-28 16:27
    关注
    评论

报告相同问题?

悬赏问题

  • ¥15 iOS 自定义输入法-第三方输入法
  • ¥15 很想要一个很好的答案或提示
  • ¥15 扫描项目中发现AndroidOS.Agent、Android/SmsThief.LI!tr
  • ¥15 怀疑手机被监控,请问怎么解决和防止
  • ¥15 Qt下使用tcp获取数据的详细操作
  • ¥15 idea右下角设置编码是灰色的
  • ¥15 全志H618ROM新增分区
  • ¥15 在grasshopper里DrawViewportWires更改预览后,禁用电池仍然显示
  • ¥15 NAO机器人的录音程序保存问题
  • ¥15 C#读写EXCEL文件,不同编译