Taking long time to connect to MySql server remotely.

Posted by Unknown at 21:27
When trying to connect from remote host to mysql server with command like this

mysql -h MySqlServerIP -u mysqlusername -p[password]

if it is taking long time. Give the following entry in /etc/my.cnf of the server

skip-name-resolve

in the [mysqld] section.

This will fix the issue. It will disable dns resolving.
Labels: , ,

15 comments:

  • 14 September 2010 at 09:36

    This is such a great resource that you are providing and you give it away for free. I enjoy seeing websites that understand the value of providing a prime resource for free. I truly loved reading your post. Thanks!

  • 21 September 2010 at 14:12

    Wow this is a great resource.. I’m enjoying it.. good article

  • Iron Doors
    25 September 2010 at 04:31

    Awesome post peter, it's been a while since I've been on here. I see that nobody has lost their passion. Good to be back.

  • 30 September 2010 at 15:27

    It's the first time I have heard that in Macedonia, obits are an unusual observe. You have wonderfully written the post. I have liked your way of writing this. Thanks for sharing this.

  • 14 October 2010 at 03:15

    My dad has been writing a book exactly on point with this blog, I have emailed him the web address so maybe he could pick up a couple pointers. Good Job.

  • 1 November 2010 at 19:17

    This is very fine web site, thank.

  • 10 November 2010 at 12:06

    I wish I found servertechs.co.cc before ! Your site is very informative, thanks.

  • mortgage help
    12 November 2010 at 14:51

    Can I link to your post?

  • forex
    13 November 2010 at 12:30

    Every time I stumble upon a great post I do one of three thing:1.Forward it to all the close contacts.2.save it in all my popular bookmarking websites.3.Make sure to return to the same site where I came accross the article.After reading this article I'm seriously concidering doing all 3...

  • kitchen remodeling
    14 November 2010 at 05:08

    When I see a really great blog post I usually do three things:1.Show it to my close friends.2.Bookmark it in all of the best social bookmarking sites.3.Make sure to return to the blog where I came accross the article.After reading this article I am really thinking of going ahead and doing all 3...

  • easy grants
    14 November 2010 at 22:27

    Thanxx

  • Motorcycle Fairing
    1 December 2010 at 18:11

    how are you?

    This post was interesting, how long did it take you to write?

  • defeomini
    4 December 2010 at 07:13

    Hi, very interesting post, greetings from Greece!

  • chicago moving company
    6 January 2011 at 22:27

    Sarah has shown incredible passion while expressing views. Thanks for the great information, I have it bookmarked

  • Everett wa dental technology
    26 January 2011 at 03:45

    The materials is undeniablably very well laid out. I sent a hyperlink to my brother, he features a comparable blog page, he could use a few of the information uncovered here to tighten up his conclusions. Thanks.

    • Post a Comment

    Subscribe to: Post Comments (Atom)