• 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
4 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
  • Thoughts on the Flipper Zero
  • Waiting for an Element to Exist With JavaScript
  • How To Paginate An Array In Javascript
  • Handling Errors with the Fetch API
  • How To Get Last 4 Digits of A Credit Card Number in Javascript
  • ChatGPT Stopping Part Way Through a Response? Here Is How You Fix It
  • How to Use Neural DSP Archetype Plugins With the Quad Cortex
  • How To Mock uuid In Jest

Recent Comments

  • CJ on Microsoft Modern Wireless Headset Review
  • Dwayne on Microsoft Modern Wireless Headset Review
  • CJ on Microsoft Modern Wireless Headset Review
  • john on Microsoft Modern Wireless Headset Review
  • Dwayne on Why You Should Be Using globalThis Instead of Window In Your Javascript Code

Copyright © 2023 · Dwayne Charrington · Log in

wpDiscuz