Archive for November, 2006

Quick method to enable MySQL networking on Mac OS X server.

Published by
Mike
at November 15, 2006 in Technology. Closed

I am not sure why this isn’t more obviously and plainly laid out somewhere. I had to run around and look for this info, so I’m putting it up here in hopes that it’s easier and more straight forward to find for others.

  1. Launch the MySQL Manager(/Application/MySQL Manager)
  2. Stop MySQL if it’s running.
  3. Check the “Allow Network Connections” box in the lower left corner of the window.
  4. Start MySQL
  5. Use the command line or phpMyAdmin to create a user
    GRANT USAGE ON <database_name> . * TO '<username>'@'%' IDENTIFIED BY '<password>';
  6. To test download the MySQL Administrator tools and install.
  7. Launch the MySQL Administrator application.
  8. At the Connect to MySQL Instance window fill in the host name username and password to the MySQL server. Also add /var/mysql/mysql.sock to the Connect using socket option. It should look similar to the below image.

    mysql-administrator001.png
  9. If all goes well you will see an Information window with a Server is Running message

    mysql-administrator002.png

Let me know if you had to do something differently for your system.