[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 343
  • Last Modified:

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?
0
smudgemouse
Asked:
smudgemouse
  • 2
1 Solution
 
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

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now