Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to connect MySQL workbench with MAMP PRO?

Tags:

mysql

macos

mamp

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

like image 871
Chris Hough Avatar asked Sep 07 '09 22:09

Chris Hough


People also ask

How do I run MySQL on MAMP?

In MAMP, you need to open phpMyAdmin to create a MySQL database. If you have installed MAMP with the default ports, open the Welcome page in your browser (http://localhost:8888/MAMP/), then click the phpMyAdmin link at the top of the screen. The main phpMyAdmin screen will appear.

How do I connect to MAMP database?

Connect to MAMP via a standard TCP/IP connection Enter 127.0. 0.1 for the Host. Enter root for the username and for the password. The default MySQL port used by MAMP is 8889.


1 Answers

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

like image 109
Mike Avatar answered Sep 23 '22 03:09

Mike