How do I connect to MySQL from the command line on a Mac?

Establishing MySQL Command Line Connection

If you're embarking on a PHP/SQL tutorial, it's crucial to understand how to connect to MySQL from the command line. Here's how you can do it specifically on a Mac:

mysql -u USERNAME -pPASSWORD -h HOSTNAMEORIP DATABASENAME

Command Parameters:

• -u USERNAME: Specify the MySQL username.
• -pPASSWORD: Enter the MySQL password (without a space between -p and the password).
• -h HOSTNAMEORIP: Provide the MySQL server's hostname or IP address.
• DATABASENAME: Indicate the specific database you want to connect to.

Example Usage:

If you have a user named "root" and a password of "secret" connecting to a database named "demo" on a server with IP address "127.0.0.1", you would use the following command:

mysql -u root -psecret -h 127.0.0.1 demo

Security Tip:

To protect your MySQL password, consider using the -p option without providing the password in the command. This will prompt you to enter the password interactively, ensuring it remains concealed.

For further details and options, refer to the MySQL documentation: http://dev.mysql.com/doc/refman/5.0/en/connecting.html

The above is the detailed content of How do I connect to MySQL from the command line on a Mac?. For more information, please follow other related articles on the PHP Chinese website!