mysql连接命令行,从命令行连接到MySQL

How can you connect to MySQL from the command line in a Mac? (i.e. show me the code)

I'm doing a PHP/SQL tutorial, but it starts by assuming you're already in MySQL.

解决方案mysql -u USERNAME -pPASSWORD -h HOSTNAMEORIP DATABASENAME

The options above means:

-u: username

-p: password (**no space between -p and the password text**)

-h: host

last one is name of the database that you wanted to connect.

Look into the the link, it's detailed there!

As already mentioned by Rick, you can avoid passing the password as the part of the command by not passing the password like this:

mysql -u USERNAME -h HOSTNAMEORIP DATABASENAME -p

People editing this answer: PLEASE DONOT ADD A SPACE between -p and PASSWORD