Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

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

How to allow remote access to MySQL installed on mac OSX 10.5

Hi experts,
  I have a MySQL server installed by default on my mac OSX 10.5. Now I want to allow remote access to this server from Windows virtual PC. How do I do that?
  Thanks!

Cheers,
Michael
0
michaelzhou23
Asked:
michaelzhou23
  • 4
  • 2
  • 2
  • +1
1 Solution
 
fosiul01Commented:
HI yah
I never work for Max OsX
but it might be same for every one

in my.cnf file

bind-address=YOUR-SERVER-IP

make sure firewall is open for port 3306

and also you have create user with that ip in mysql

mysql> CREATE DATABASE foo;
mysql> GRANT ALL ON foo.* TO bar@'202.54.10.20' IDENTIFIED BY 'PASSWORD'

look at this article :
http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html
0
 
mattaobCommented:
Also make sure skip-networking is not enabled in the my.cnf file
0
 
michaelzhou23Author Commented:
thanks.
hmm... it seems i cannot find the my.cnf in osx version of MySQL?
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
fosiul01Commented:
LOl
have you install mysql from rpm ??
rpm version does not have my.cnf  

there would be some file call my-small.cnf or my-medium.cnf in your sytem

you need to copy one of them and make it as my.cnf

but onething : in linux system my.cnf stay in /etc/my.cnf file
but i dont know about mac Os

let me do some google
0
 
TimYatesCommented:
> have you install mysql from rpm ??

He said he's on OS X at least twice, so I doubt he used a Red Hat package installer to do it

Michael, the Mysql setup should be fine, it will just be a case of getting the Guest OS to talk to the Host machine

Have a look in the networking config of the windows guest, and see if it has a default gateway

If so, try connecting to port 3306 on that IP address, fingers crossed MySQL should be there...

PS:  You tagged this as "Groovy", but don't think it relates...
0
 
fosiul01Commented:
Sorry i should have give more attention about rpm .. rpm is for redhat.
have a look this one

http://www.comentum.com/mysql-administration.html


in macos , my.cnf should be at /etc/ folder
or you can try to find it

sudo find / -name my-large.cnf -print



0
 
michaelzhou23Author Commented:
Thanks guys a lot for your help!
I was finally able to get it working.

Cheers,
Michael
0
 
fosiul01Commented:
@michaelzhou23

so what what the problem ?? what is default gateway  ??

0
 
TimYatesCommented:
Probably 192.168.1.1
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

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