Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

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
Sign in to Comment

Related questions

Is there a difference in using INT(1) vs TINYINT(1) in MySQL?
MySql: MyISAM vs. Inno DB! [closed]
GRANT with database name wildcard in MySQL?
Truncate with condition
MySQL: Insert datetime into other datetime field
Delete from one table with join
Cannot load from mysql.proc. The table is probably corrupted
"Invalid parameter number: parameter was not defined" Inserting data
Creating tables and problems with primary key in Rails
Working with INTERVAL and CURDATE in MySQL
select from mysql table between datetime x min ago and datetime x min ago
Difference in minutes from two time fields in MySQL
How to do a count on a union query
Enable Entity Framework 6 for MySql (C#) in WinForms of Microsoft Visual Studio 2013
Check if MySQL table exists or not [duplicate]
Import CSV to Update only one column in table
MySQL: Can't create/write to file '/tmp/#sql_3c6_0.MYI' (Errcode: 2) - What does it even mean?
CakePHP - get last query run
MySQL autoincrement column jumps by 10- why?
using CASE in the WHERE clause

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!