How to connect MySQL workbench with MAMP PRO?

Question

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

score 85 · Answer 1 · edited Apr 06 '17 at 12:55

85

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

edited Apr 06 '17 at 12:55

spassas

4,778
2
31
39

answered Nov 23 '10 at 12:43

Mike

871
1
7
6

This was precisely what I was looking for! – Lothre1 Nov 02 '13 at 17:34
1

Wonder why the other answer was selected :) – Ram Feb 22 '14 at 17:08
3

After I set the above parameters, I received: "Can't connect to local MySQL server through socket '/Applications/MAMP/tmp/mysql/mysql.sock' (2)" – HuongOrchid Jul 13 '17 at 15:22

score 23 · Answer 2 · edited May 23 '17 at 11:46

23

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 permanent and you will be able to connect to mysql using the mysqlcli or any other external tool.

edited May 23 '17 at 11:46

Community

1
1

answered Jan 06 '12 at 04:18

elboletaire

5,180
2
36
46

score 10 · Accepted Answer · answered Sep 07 '09 at 23:13

10

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

answered Sep 07 '09 at 23:13

Chris Hough

3,389
3
41
80

score 9 · Answer 4 · edited Nov 30 '19 at 15:37

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.

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.

score 2 · Answer 5 · answered Apr 22 '13 at 08:41

2

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

answered Apr 22 '13 at 08:41

Jörn

845
5
16

Sometimes things are very simple – Olivier de Jonge May 04 '13 at 08:33

score 2 · Answer 6 · answered Oct 03 '17 at 08:52

2

Connection to DB with MAMP. You must use local connection

answered Oct 03 '17 at 08:52

Dmitry Krychylskyy

199
3
12

score 2 · Answer 7 · answered Jul 25 '18 at 14:05

2

In my case the problem was the ports. As well explained here, the default mysql port in MAMP is 8889, and not 3306, although in MAMP localhost website says that it`s running in 3306.

answered Jul 25 '18 at 14:05

brunoramonalmeida

98
6

score 0 · Answer 8 · answered Aug 28 '12 at 08:54

0

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.

answered Aug 28 '12 at 08:54

Jonas Stensved

14,378
5
51
80

score 0 · Answer 9 · edited May 23 '17 at 12:25

0

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:

edited May 23 '17 at 12:25

Community

1
1

answered Jan 21 '13 at 08:23

Christopher Jones

23
4

score 0 · Answer 10 · answered Apr 17 '13 at 18:14

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.

score 0 · Answer 11 · answered Oct 29 '16 at 01:34

0

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 :)

answered Oct 29 '16 at 01:34

here

2,790
25
30

score 0 · Answer 12 · answered Jan 25 '21 at 08:42

0

MAMP server typically uses 8889 port instead of 3306. You can check it in MAMP/SQL section.

answered Jan 25 '21 at 08:42

Tariq Kamal

468
1
8
17

How to connect MySQL workbench with MAMP PRO?

12 Answers12