本地Navicat连接不上服务器的MySQL

博客 4个月前 小西瓜
3,115 12
广告也精彩

本想用navicat连接服务器数据库练习一些查询语句,无奈一直报错,通过Google/baidu 查出是数据库权限问题,虽然开放了3306的端口,但是服务器不允许 其他ip的访问,需要进入数据库给与 root 新的权限。

困扰的问题终于解决了,以此做个记录

参考文章
本地Navicat连接不上远端服务器的MySQL
解决Navicat无法连接到MySQL的问题

版权声明:小西瓜 发表于 2021-01-18 18:15:46。
转载请注明:本地Navicat连接不上服务器的MySQL | 西瓜导航

12 条评论

  • 茶余饭后导航
    茶余饭后导航 Vip1

    茶余饭后导航,网址guide.qitablog.com,已添加贵站为首页友链

    回复
  • 0mniartist

    Ahaa, its good conversation regarding this paragraph at this place at this web site, I
    have read all that, so now me also commenting here.
    asmr 0mniartist

    回复
  • bitly.com
    bitly.com Vip1

    If you wish for to take a good deal from this post then you have to apply such strategies to your
    won webpage. 0mniartist asmr

    回复
  • gamefly where

    Great article. I am going through a few of these issues
    as well..

    回复
  • asmr why
    asmr why Vip1

    I’m gone to tell my little brother, that he should
    also pay a visit this blog on regular basis to get updated from hottest news.

    回复
  • and asmr
    and asmr Vip1

    Everything is very open with a clear explanation of the
    issues. It was really informative. Your site is very helpful.
    Thanks for sharing!

    回复
  • my asmr
    my asmr Vip1

    Thanks on your marvelous posting! I seriously enjoyed reading it, you can be a
    great author. I will remember to bookmark your blog and will eventually come back at some point.
    I want to encourage you to continue your great writing,
    have a nice morning!

    回复
  • on gamefly

    Hi there! This is my first visit to your blog! We are
    a collection of volunteers and starting a new initiative in a
    community in the same niche. Your blog provided
    us useful information to work on. You have done a extraordinary
    job!

    回复
  • asmr that
    asmr that Vip1

    When I initially commented I clicked the “Notify me when new comments are added” checkbox
    and now each time a comment is added I get four
    e-mails with the same comment. Is there any way you can remove people from that service?
    Thank you!

    回复
  • bit.ly
    bit.ly Vip1

    Oh my goodness! Awesome article dude! Thank you, However I am
    encountering difficulties with your RSS. I don’t know why I cannot join it.

    Is there anybody else getting identical RSS issues?
    Anybody who knows the answer will you kindly respond?
    Thanks!!

    回复
  • with asmr
    with asmr Vip1

    Woah! I’m really enjoying the template/theme of this website.
    It’s simple, yet effective. A lot of times it’s difficult to get
    that “perfect balance” between user friendliness and appearance.

    I must say that you’ve done a excellent job with this.
    In addition, the blog loads extremely quick for me on Chrome.
    Exceptional Blog!

    回复
  • asmr our
    asmr our Vip1

    Good write-up. I absolutely love this site. Keep writing!

    回复