MYSQL: OS X Enable Remote Acess

Getting Connection fail with the following message when trying to connect to another machine on the network:
Host 'xxx.xxx.x.xxx' is not allowed to connect to this MYSQL Server.

How can this be enabled on OS X?
smudgemouseAsked:
Who is Participating?
 
leakim971PluritechnicianCommented:
Hello smudgemouse,

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

From command line : http://dev.mysql.com/doc/refman/5.1/en/adding-users.html

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

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

Open in new window

0
 
smudgemouseAuthor Commented:
Thank you very much
0
 
leakim971PluritechnicianCommented:
You're welcome! Thanks for the points!
0
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.