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

博客 9个月前 小西瓜
8,401 23
广告也精彩

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

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

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

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

23 条评论

  • 茶余饭后导航
    茶余饭后导航 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!

    回复
  • ulule.com
    ulule.com Vip1

    scoliosis
    My partner and I stumbled over here different web
    address and thought I might check things out. I like what I see
    so i am just following you. Look forward to looking over
    your web page repeatedly. scoliosis

    回复
  • bit.ly
    bit.ly Vip1

    scoliosis
    Magnificent beat ! I would like to apprentice while you amend your website, how can i
    subscribe for a blog site? The account aided me a acceptable deal.
    I had been tiny bit acquainted of this your broadcast offered bright clear concept scoliosis

    回复
  • asmr when
    asmr when Vip1

    Excellent goods from you, man. I have consider your stuff prior to and you
    are simply extremely excellent. I really like what you have bought here, really like what you are saying and the best way
    in which you are saying it. You make it entertaining
    and you continue to care for to stay it smart.
    I can't wait to read much more from you. That is really a
    wonderful web site.

    回复
  • in dating sites

    Everything is very open with a very clear explanation of the issues.
    It was truly informative. Your website is useful. Many
    thanks for sharing!

    回复
  • scoliosis surgery with

    I'm really loving the theme/design of your blog.
    Do you ever run into any web browser compatibility issues?

    A small number of my blog visitors have complained about my blog not working correctly in Explorer but looks great
    in Chrome. Do you have any ideas to help fix this problem?

    回复
  • of scoliosis surgery

    I'm really impressed with your writing skills as well as with the layout on your blog.
    Is this a paid theme or did you customize it yourself?
    Either way keep up the excellent quality writing, it's rare to see a great blog like this
    one today.

    回复
  • free dating sites that

    Good day! I could have sworn I've visited this site
    before but after browsing through some of the posts I realized
    it's new to me. Nonetheless, I'm certainly pleased I stumbled upon it and I'll be book-marking it and checking
    back often!

    回复
  • my dating sites

    What's up, this weekend is fastidious in favor of me, for the reason that this moment i am reading
    this fantastic educational article here at my home.

    回复
  • tinyurl.com

    Great info. Lucky me I ran across your blog by accident (stumbleupon).
    I've book-marked it for later!

    回复
  • ableton live 10.1 crack reddit

    Hello I am so delighted I found your blog page, I really found you by accident, while I was searching on Yahoo for something else, Nonetheless I am here now and would just like to say thank you for a fantastic post and a all round exciting blog (I also love the theme/design), I don't have time to read it all at the minute but I have book-marked it and also added your RSS feeds, so when I have time I will be back to read a great deal more, Please do keep up the fantastic work.|

    回复
  • ableton live 10.1 crack mac reddit

    Exceptional post but I was wondering if you could write a litte more on this subject? I'd be very grateful if you could elaborate a little bit further. Kudos!|

    回复