MySQL Install on Windows won't accept remote host connections

Posted on 2007-10-03
Last Modified: 2012-05-05
Everything works great from the localhost, but remote connections get an error like "MySQL Connection is not allowed from host, YOURHOST"

Obviously I'm missing a config of some sort, this is a fresh install of 5.0.45 on Windows Server 2003 32-bit.

Thanks for any help with what I need to do/add/configure/etc
Question by:dban00b
    LVL 17

    Accepted Solution

    You have to use the GRANT command to allow access from other servers, like:
    GRANT ALL ON yourDatabase.yourTable TO yourUser@yourHost IDENTIFIED BY 'yourPassword';

    See more here:
    LVL 7

    Expert Comment

    My suggest stems from Linux, but I believe Windows might have something similar going on. Latest version of MySQL at least will by default bind itself to "localhost" (loopback interface) instead of "" (all available interfaces) as a security measure. This setting can be changed from within my.cnf (my.ini, whatever:) with setting "bind-address" (which is under section "mysqld").

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Foreword This is an old article.  Instead of using the MySQL extension that was used in the original code examples, please choose one of the currently supported database extensions instead.  More information is available here: MySQLi / PDO (http://…
    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now