[SOLVED] which mysql?

[Recreational_Champ]

Hello~

 

I have two mysql servers running on my computer, the one I installed by itself and the one that came packaged with MAMP.

 

I have created a path in a file called .bash_login:

 

export PATH="/usr/local/mysql/bin:$PATH"  and I am not quit sure why this path is set as such because mysql_sock is located in /tmp.

 

I want to be able to run the MAMP mysql server from the cli and know that I can create a sym link to accomplish this task:

 

sudo ln -s /Applications/MAMP/tmp/mysql/mysql.sock /tmp/mysql.sock

 

If I create the sym link will I be able to run the mysql server packed with mamp from cli?

 

What will be the effects on the current mysql server?

 

What is mysql looking for to actually run?

 

If I have supplied enough information, could you help me understand what is going on here.

 

I would also be happy to keep everything as is and do something like:

 

mysql -u 'user' -h '/path/to/mamp_mysql_file' -p, but still want to understand whats going on.

 

[Recreational_Champ]

Thanks for moving the post:  I noticed I had posted in the wrong spot after submission.

 

I have solved my problem!!!

 

forget about symbolic links and just update .bash_login(or whatever your file name might be)

 

#path is now set to MAMP mysql server and as a default I have added my other path as well
export PATH="/Applications/MAMP/Library/bin:/usr/local/mysql/bin:$PATH"

 

I understand that I can opt to run the two servers on different ports and just specify which mysql I want by that means instead, but I haven't tried that yet.