Ask Different is a question and answer site for power users of Apple hardware and software. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have installed MySql on a Mac Mini that I want to use as a dev database server. I have created a toy database on the server. I have created a wireless network using Airport. I now want to connect to the database from a MySql client on my Macbook Air. I am using the root user with no security at all (hey, it's a toy database), but cannot connect as the Macbook is not allowed to connect.

What do I need to do to configure my WLAN so that the client can see the server?

share|improve this question
up vote 1 down vote accepted
  1. Open terminal.
  2. Type ifconfig
  3. Find something like inet netmask
  4. is local ip of your machine in your WLAN. You can connect to mysql using this ip.
share|improve this answer
afraid this doesn't work. I try to connect using the MySql using the Workbench GUI and get the error Your connection attempt failed for user 'root' from your host to server at Host '' is not allowed to connect to this MySQL server I this because the IP is created dynamically (by Airport)? – Aidan Aug 2 '12 at 12:40
This is not WLAN problem. Your mysql server doen't allow non-local connecetions. Read this ( article to configure your server. – Daniil Ryzhkov Aug 2 '12 at 12:53
That fixed it, thanks! – Aidan Aug 6 '12 at 9:42

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.