• 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

Solving "sh: mysql: command not found" In MAMP Pro 2 and MAMP Pro 3

General · August 21, 2014

If you are reading this there is a possibility you have run into this error message in your terminal window: sh: mysql: command not found

This error is being displayed because MAMP Pro stores MySQL in a location on your Mac that isn’t added to your main $PATH. MySQL is stored in the MAMP Pro bin folder here: /Applications/MAMP/Library/bin/mysql

Fortunately the fix is rather simple following the below steps:

  • In your home directory create or edit the file “.bash_profile” you can access your home directory by typing: cd ~/
  • Add this to the top of the file: export PATH=$PATH:/Applications/MAMP/Library/bin
  • Save the file and then restart your Terminal
  • In your newly restarted Terminal window type: mysql –version

This will now map MySQL to your path and allow you to access it by just typing “mysql”

Dwayne

Leave a Reply Cancel reply

3 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
Moh
Moh
7 years ago

I did the above step but now getting below error:

ERROR 1044 (42000): Access denied for user ”@’localhost’

0
Tousif
Tousif
6 years ago

Thank you,

Worked for me.

0
Gökhan ALKAN
Gökhan ALKAN
5 years ago

Thanks.

0

Primary Sidebar

Popular

  • Testing Event Listeners In Jest (Without Using A Library)
  • How To Get The Hash of A File In Node.js
  • Waiting for an Element to Exist With JavaScript
  • Thoughts on the Flipper Zero
  • How To Get Last 4 Digits of A Credit Card Number in Javascript
  • How To Mock uuid In Jest
  • How To Paginate An Array In Javascript
  • Reliably waiting for network responses in Playwright
  • How to Copy Files Using the Copy Webpack Plugin (without copying the entire folder structure)
  • Wild Natural Deodorant Review

Recent Comments

  • Dwayne on Is Asking Developers How to Write FizzBuzz Outdated?
  • kevmeister68 on Is Asking Developers How to Write FizzBuzz Outdated?
  • Kevmeister68 on Start-Ups and Companies That Embrace Work From Anywhere Will Be More Likely to Survive the Coming Recession in 2023
  • kevmeister68 on What Would Get People Back Into the Office?
  • Dwayne on PHP Will Not Die

Copyright © 2023 · Dwayne Charrington · Log in

wpDiscuz