Home / Questions / 152723
Accepted
Fernando
Asked: 2020-04-04 16:09:28 +0800 CST 2020-04-04 16:09:28 +0800 CST

How to connect to MySQL without having to specify the full path

  • 772

Since I installed MySQL, it only allows me to connect like this:

/usr/local/mysql/bin/mysql -u user -p

I would like to know how I can connect in this other way:

mysql -u user -p.

Without having to specify the full path, because it's a bit awkward. Someone who knows what I should do to change the way to connect to MySQL.

I am on Mac OS, I have version 5.7.21.

shell

1 Answers

  1. Best Answer

    1 you can make a symbolic link to the mysql executable inside the folder /urs/local/binthis path should be in the path and any command you write if it exists there it is not necessary to put the full path

    $ ln -s /usr/local/mysql/bin/mysql /usr/local/bin/mysql

    2 you can also add /usr/local/mysql/bin/to the path

    $ sudo nano /etc/paths

    way 2 is recommended if you are going to use mysqldumpand other tools that are in the mysql bin

    3 add to the path only in your console profile: search for a file .profileor edit it .bash_profilein your user folder homeand put the following line at the end:

    PATH="${PATH}:/usr/local/mysql/bin/:"
export $PATH

    Way 3 is the least intrusive, way 2 is global (it asks for admin password), way 1 is generic for a single executable (it will also ask for admin permission)

    • 4