MYSQL terminal Mac command not working 'mysql'

Question

I have a hidden file in my home directory called .profile with the following:

MYSQL_HOME = /usr/local/mysql/bin/mysql
export PATH=$MYSQL_HOME/bin:$PATH

The following command works:

$ /usr/local/mysql/bin/mysql

However mysql does not. How can I change the path to make the command work? I have MAMP installed, I'm just not sure how to use it. Thanks!

Answer 1

I believe the error is in your first line:

   MYSQL_HOME=/usr/local/mysql/bin/mysql 

Which should be like this:

  MYSQL_HOME=/usr/local/mysql