• 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 ReplyCancel reply

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

thank you friend

0
Kiwami
Kiwami
4 years ago

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

0

Primary Sidebar

Popular

  • Handling Errors with the Fetch API
  • How To Get The Hash of A File In Node.js
  • Thoughts on the Flipper Zero
  • How To Paginate An Array In Javascript
  • Testing Event Listeners In Jest (Without Using A Library)

Copyright © 2023 · Dwayne Charrington · Log in

wpDiscuz