MYSQL: OS X Enable Remote Acess

Posted on 2009-12-31
Last Modified: 2012-05-08
Getting Connection fail with the following message when trying to connect to another machine on the network:
Host '' is not allowed to connect to this MYSQL Server.

How can this be enabled on OS X?
Question by:smudgemouse
    LVL 81

    Accepted Solution

    Hello smudgemouse,

    You need to add user and the correct host on the mysql.user table

    From command line :

    If user IP is and you want to create a new root (it's just a name) :

    CREATE USER 'root'@' ' IDENTIFIED BY 'some_pass';

    Open in new window


    Author Closing Comment

    Thank you very much
    LVL 81

    Expert Comment

    You're welcome! Thanks for the points!

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    More Fun with XML and MySQL – Parsing Delimited String with a Single SQL Statement Are you ready for another of my SQL tidbits?  Hopefully so, as in this adventure, I will be covering a topic that comes up a lot which is parsing a comma (or other…
    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.
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    729 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

    17 Experts available now in Live!

    Get 1:1 Help Now