How to Connect to MySQL from the Command Line on a Mac?

Establishing a MySQL Command Line Connection

Connecting to MySQL from the command line on a Mac is essential for managing databases and performing data operations. This article will provide you with a step-by-step guide to connect to MySQL, showcasing the necessary code.

Procedure

1. Open Terminal: Launch the Terminal application from the Utilities folder of your macOS or access it through the Spotlight search.

2. Install MySQL Client: If you haven't already, install the MySQL client using the Homebrew package manager:

   brew install mysql-client

3. Connect to MySQL: Establish a connection to the MySQL server using the mysql command along with your login credentials:

   mysql -u <username> -p<password> -h <hostname or IP> <database name>

4. Replace with your MySQL username.
5. Replace with your MySQL password (avoid adding a space after -p).
6. Replace with the hostname or IP address of the MySQL server.
7. Replace with the name of the database you want to connect to.

Example:

mysql -u myuser -pmypassword -h localhost mydatabase

4. Enter Password: If you didn't pass the password in the command, you will be prompted to enter it at the terminal.

5. Verify Connection: Upon successful login, you will see the MySQL prompt:

   mysql>

Additional Notes

• You can avoid entering the password in the command by specifying the -p option followed by the password without a space: mysql -u -p...
• For more detailed instructions and options, refer to the MySQL documentation provided in the answer: [http://dev.mysql.com/doc/refman/5.0/en/connecting.html](http://dev.mysql.com/doc/refman/5.0/en/connecting.html)

The above is the detailed content of How to Connect to MySQL from the Command Line on a Mac?. For more information, please follow other related articles on the PHP Chinese website!