How to connect MySQL workbench with MAMP PRO?

What is the fix to connect the MySQL Workbench tool with the MAMP PRO MySQL database?

MAMP Pro: How to connect to MySql server on Mac OS via Network?

I have a PC with Mac OS 10.6 that is running as Webserver on LAN. I use MAMP Pro for that (Apache + MySql). Today, I have problem that: From other PC on LAN, I try to connect to Mysql server on Mac an

Using MySQL to connect to MAMP

I have MAMP installed as apache/php/mysql , I know how to connect to mysql through accessing mysql from terminal in MAMP directory. then I installed MySQL via homebrew and copied MAMP my.cnf into /etc

anyone get mysql workbench 5.2 to work with mamp?

i cannot get mysql workbench 5.2 to work. i have mamp and mamp pro installed and running and no matter what type of connection i try it just wont connect. what can i do? i have a mac with snow leopard

MySQL Workbench connection to local network MAMP server

I have MAMP installed on my Macbook Pro retina 13, which is in the same network as my workstation Windows machine. I would like to have MySQL Workbench to communicate with my MAMP server (instead of i

Could not connect to MySQL server MAMP Pro

Alright after a whole day of researching and several attempts… I can’t get this to work. It has worked in the past. So, I launch mamp pro and I get a /Applications/MAMP/Library/bin/mysqlcheck: Got e

Connecting to MySQL from Java to WAMP / MAMP Pro

I am trying to connect from java to a MySQL database from an external computer on a machine hosting WAMP and other hosting MAMP Pro. The connection to WAMP is fine but on MAMP Pro, I get the following

how to backup your mamp pro mysql dbs?

while I find the apache portion of mamp pretty easy to backup, what is everyone using or how are you performing a scheduled backup of your mysql databases? It would be kinda annoying to export each DB

Mamp pro 3.0.5 mysql start up warning

Running osx 10.9.4 Mamp Pro 3.0.5 When I start Apache and MySQL I get this warning. Such a file could interfere with MySQL in MAMP. In case of problems remove /etc/my.cnf, /etc/mysql/my.cnf or ~/.my.c

MySQL Connection Refused on MAMP Pro

I apologize if this is a duplicate, but so far I have not found any answers to this question. I recently installed MAMP Pro, and have been having some issues with MySQL. The display seems to indicate

Mac OS X mySQL custom database path (MAMP PRO)

I’m using MAMP (OS-X 10.6.6) and I want to move my mySQL db folder to my dropbox folder. The MySQL server MAMP runs stores its databases in /Library/Application Support/appsolute/MAMP PRO/db/mysql ..

Answers

I was able to get http://www.sequelpro.com/ working by pointing it to the socket: /Applications/MAMP/tmp/mysql/mysql.sock

Change the connection type from TCP/IP to Local, then point it to the socket:

/Applications/MAMP/tmp/mysql/mysql.sock

Your username and pw will most likely be root / root

As Mike said you can use the Local option and point it to the socket:

/Applications/MAMP/tmp/mysql/mysql.sock

Or you can generate a symbolic link to your mysql socket (from your terminal):

sudo ln -s /Applications/MAMP/tmp/mysql/mysql.sock /tmp/

Doing it this way the changes will be permanently and you will be able to connect to mysql using the mysqlcli or any other external tool.

I’m only able to connect if I use the socket /Applications/MAMP/tmp/mysql/mysql.sock AND set “Run Apache/MySQL as user www/mysql” in the gerneral tab.

If, after following Mike’s answer you receive:

Operation failed: /usr/local/mysql/support-files/mysql.server start is invalid

Follow the instructions here. For me, I had to replace /usr/local/mysql with /Application/MAMP/Library in the fields:

  • Start MySQL:
  • Stop MySQL:
  • Check MySQL Status:

When I have to make this connection, I set my TCP/IP connection to socket and UN/pw both to root as Mike suggests above. However workbench was still telling me that it was looking for a cnf file at this location (/etc/my.cnf).

I created a symlink from my MAMP cnf file to the location that Workbench was looking for it. (sudo ln -s /Applications/MAMP/Library/support-files/my.cnf /etc/my.cnf)

setup finalized without issue.

I had the same problem and fixed it by unchecking the “Allow local access only” checkbox in the Server->MySQL Tab

After looking around for quite some time, Mike’s answer worked great.

However, I also discovered that going into MySQL tab and checking “Allow network access to MySQL” and choosing the “only from this Mac” radio button I was able to connect using the previously saved connection in MySQL Workbench that I had been using with standard MAMP before upgrading to MAMP Pro.

How to connect MySQL workbench with MAMP PRO?

So for those of you who are moving from MAMP to MAMP Pro and already have your connections setup in MySQL Workbench, this option is quicker than setting up a new connection using a unix socket.

Make sure MySQL is set to “on” in addition to Apache or nginx. The Servers button may not toggle all of them.

In my case, only Apache was running šŸ™‚