Mac system xampp in MySQL command line client configuration using

In the course of PHP learning. MySQL is expected to be in touch.

MySQL management believes that you will also use phpMyAdmin:

All right. phpMyAdmin is really the artifact of MySQL management that you want. He has a lot of it, in the process of development. The design architecture for the back-end database is really very helpful.

But. In this article the protagonist is indeed not it.

Mysqlclient

mysql install package inside. In a directory named Bin, a lot of toolkits are placed, but the way they are used is the command line (PS: recent addiction).

On the Mac system. Using the command line tool, you can use the terminal that comes with your system:

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

But how can you use this client?

Enter the bin directory in the terminal to XAMPP. Enter the command:

Mysql-u root-p

There is no result that I want, should be prompt input password ah??????

In terminal feedback to me is indeed: command not found

What? Plainly is in front of, how not found. This is a bitter force!

All right. It seems to take some time to find out where the problem lies.

After a very long, very long, very long ..... Time, and finally ....

It turns out that when you enter the command time. The system will look for the command you entered in the/usr/bin location. Suppose you didn't bring the command into this position. Regardless of your direct CD to the tool detailed location call, is also in vain

Kung Fu. Simply introduce the absolute position of the tool into the/usr/bin. All the problems will be solved. Just want us to run this command:

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

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

All right. You did it. Enter password and you will be able to view the management of your MySQL!!.!!

！

！

！

Mac system xampp in MySQL command line client configuration using