MYSQL: OS X Enable Remote Acess

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?
Who is Participating?
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

smudgemouseAuthor Commented:
Thank you very much
You're welcome! Thanks for the points!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.