• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

I Like Kill Nerds

The blog of Australian Front End / Aurelia Javascript Developer & brewing aficionado Dwayne Charrington // Aurelia.io Core Team member.

  • Home
  • Aurelia 2
  • Aurelia 1
  • About
  • Aurelia 2 Consulting/Freelance Work

Getting Navicat To Work With MAMP Pro MySQL

General · September 26, 2014

After recently deciding to switch to Navicat on my MacBook Pro from Sequel Pro, I encountered an issue where Navicat couldn’t connect to my MySQL server using either localhost or the local IP of 127.0.0.1. This is because MAMP will start the MySQL server using a socket. This just means you need to tell Navicat where your socket server is.

When creating a new connection you should see tabs; General, Advanced, SSL, SSH and HTTP. We want to specify the socket in the advanced tab.

You should see the following (as pictured below):

Screen Shot 2014-09-26 at 9.47.49 am

In the “Use socket file” field copy and paste this: /Applications/MAMP/tmp/mysql/mysql.sock

Now hit “Test Connection” and everything should work. You’ve now got Navicat working with your MAMP MySQL.

Dwayne

Leave a Reply Cancel reply

2 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
Tim
Tim
4 years ago

thank you friend

0
Kiwami
Kiwami
3 years ago

“Just google it” .. haha VERY useful post.. Thank you.

0

Primary Sidebar

Popular

  • Testing Event Listeners In Jest (Without Using A Library)
  • How To Get The Hash of A File In Node.js
  • Which Neural DSP Archetype Plugins Should You Buy?
  • Smoke Detector Randomly Goes Off Early Hours of The Morning
  • How To Mock uuid In Jest
  • Neural DSP Reveal Details About the Long-Awaited Quad Cortex Desktop Editor
  • Deno Raises $21M - but is anyone using it yet?
  • Web 3.0 may have died before it even started
  • NBN Box Installed Inside of Garage, Where Do You Put The Modem?
  • How to Use Neural DSP Archetype Plugins With the Quad Cortex

Recent Comments

  • Jay on Neural DSP Reveal Details About the Long-Awaited Quad Cortex Desktop Editor
  • john on Deno Raises $21M – but is anyone using it yet?
  • Oranges on How To Store Users In Firestore Using Firebase Authentication
  • Precious on Fixing Sequel Pro SQL Encoding Error For Imported SQL Files
  • James on A List of WordPress Gutenberg Core Blocks

Copyright © 2022 · Dwayne Charrington · Log in

wpDiscuz