Mac system xampp in MySQL command line client configuration using

In the course of PHP learning, MySQL estimates are bound to come into contact.

MySQL management believes that you will also use phpMyAdmin:

Well, phpMyAdmin is really the artifact of MySQL management, you want, he has a lot of, in the process of development, the design of the background database to help really great.

However, the protagonist in this article is not it.

MySQL Client

inside the MySQL installation package, in a folder named Bin, a lot of toolkits are placed, but the way they're used is the command line (PS: recently hooked).

On Mac systems, use the command line tool to use the system's own terminal:

Incidentally, I use the PHP+MYSQL environment is the Mac version of the Xampp,mysql Client tool is placed in the Bin folder xampp inside.

But how can you use this client?

In terminal enter the Bin folder of XAMPP, enter the command:

Mysql-u root-p

And there is no result I want, should be prompted to enter the password ah??????

In terminal feedback to me is indeed: command not found

What? Clearly in front of, how not found, this under the bitter force! Well, it seems to take some time to find out where the problem lies.

After a long, long, long time ... and so on. Time, finally ....

It turns out that when you enter a command, the system will look for the command you entered in the/usr/bin location, and if you do not bring the command to this location, no matter where you direct the CD to the tool specific location, it is a waste

Kung Fu. As long as the absolute position of the tool is introduced into the/usr/bin, all the problems are solved, as long as we execute the command:

Ln-s/applications/xampp/bin/mysql/usr/bin

At this point, we re-enter the link Database command, and then:

Well, you've succeeded, you can enter your password, and you'll be able to view your MySQL management!!!!!!!!