Configure and use the MySQL command line client in XAMPP of MAC system

In the PHP learning process, MySQL is estimated to be in contact.

I believe you will also use phpmyadmin for MySQL management:

Well, phpmyadmin is indeed an artifact of MySQL management. You may want many of them. During the development process, it helps a lot in the design architecture of the background database.

However, the main character in this article is indeed not it.

MySQL client

In the MySQL installation package, many toolkit are placed in a folder named bin, but the command line is used (ps: Recently addicted ).

In MAC systems, the command line tool can use the Terminal provided by the system:

By the way, the php + mysql environment used by the author is XAMPP for MAC, and the MySQL client tool is placed in the bin folder in XAMPP.

But how can I use this client?

Enter the XAMPP bin folder in Terminal and enter the following command:

Mysql-u root-p

I didn't want any results. I was prompted to enter the password ??????

In Terminal, the message is indeed: command not found.

What? Clearly in front, how not found, this is hard! Well, it seems that it takes some time to find the problem.

After a long and long period of time ....

Originally, when you enter the command time, the system will search for the command you entered in the/usr/bin location. If you did not introduce the command to this location, whether you call cd directly to the specific location of the tool, it is in vain.

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

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

At this time, enter the database connection command, and then:

Okay, you have succeeded. Enter the password to view and manage your MySQL !!!!!!!!