blocks|key|985740|text|查看此处http://dev.mysql.com/doc/refman/5.0/en/connecting.html|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|985741|mysql+-u+USERNAME+-pPASSWORD+-h+HOSTNAMEORIP+DATABASENAME+|code-block|syntax|javascript|985742|上面的选项意味着：|985743|-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.+|985744|查看链接，在那里有详细信息！|985745|985746|正如Rick已经提到的，通过不像下面这样传递密码，可以避免将密码作为命令的一部分进行传递：|985747|mysql+-u+USERNAME+-h+HOSTNAMEORIP+DATABASENAME+-p|985748|985749|编辑此答案的人员:请不要在-p和PASSWORD之间添加空格|style|CODE|985750|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/doc/refman/5.0/en/connecting.html|1|https://stackoverflow.com/a/23642685/298455^0|4|1I|0|0|0|0|0|0|0|2|4|1|0|0|0|D|2|G|8|0^^$0|@$1|2|3|4|5|6|7|18|8|@]|9|@$A|19|B|1A|1|1B]]|C|$]]|$1|D|3|E|5|F|7|1C|8|@]|9|@]|C|$G|H]]|$1|I|3|J|5|6|7|1D|8|@]|9|@]|C|$]]|$1|K|3|L|5|F|7|1E|8|@]|9|@]|C|$G|H]]|$1|M|3|N|5|6|7|1F|8|@]|9|@]|C|$]]|$1|O|3|-4|5|6|7|1G|8|@]|9|@]|C|$]]|$1|P|3|Q|5|6|7|1H|8|@]|9|@$A|1I|B|1J|1|1K]]|C|$]]|$1|R|3|S|5|F|7|1L|8|@]|9|@]|C|$G|H]]|$1|T|3|-4|5|6|7|1M|8|@]|9|@]|C|$]]|$1|U|3|V|5|6|7|1N|8|@$A|1O|B|1P|W|X]|$A|1Q|B|1R|W|X]]|9|@]|C|$]]|$1|Y|3|-4|5|6|7|1S|8|@]|9|@]|C|$]]]|Z|$10|$5|11|12|13|C|$14|15]]|16|$5|11|12|13|C|$14|17]]]]

See here <a href="http://dev.mysql.com/doc/refman/5.0/en/connecting.html" rel="noreferrer">http://dev.mysql.com/doc/refman/5.0/en/connecting.html</a>
<pre><code>mysql -u USERNAME -pPASSWORD -h HOSTNAMEORIP DATABASENAME 
</code></pre>
The options above means:
<pre><code>-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. 
</code></pre>
Look into the link, it's detailed there!
<hr />
As already mentioned by <a href="https://stackoverflow.com/a/23642685/298455">Rick</a>, you can avoid passing the password as the part of the command by not passing the password like this:
<pre><code>mysql -u USERNAME -h HOSTNAMEORIP DATABASENAME -p
</code></pre>
<hr />
People editing this answer: PLEASE DONOT ADD A SPACE between <code>-p</code> and <code>PASSWORD</code>

blocks|key|771297|text|最佳实践是mysql+-u+root+-p。然后，在您按enter键后，MySQL将提示输入密码。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|771298|entityMap^0|5|G|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

Best practice would be to <code>mysql -u root -p</code>.
Then MySQL will prompt for password after you hit enter.

blocks|key|985971|text|在运行MySQL外壳程序之后，您将看到以下内容：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|985972|mysql-js>|code-block|syntax|javascript|985973|首先，你应该：|985974|mysql-js>\sql|985975|其次：|985976|+mysql-sql>\connect+username@servername+(root@localhost)|985977|最后：|985978|Enter+password:*********|985979|entityMap^0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|W|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|Y|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|Z|8|@]|9|@]|A|$E|F]]|$1|O|3|P|5|6|7|10|8|@]|9|@]|A|$]]|$1|Q|3|R|5|D|7|11|8|@]|9|@]|A|$E|F]]|$1|S|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|T|$]]

After you run MySQL Shell and you have seen following:

<pre><code>mysql-js&gt;
</code></pre>

Firstly, you should:

<pre><code>mysql-js&gt;\sql
</code></pre>

Secondly:

<pre><code> mysql-sql&gt;\connect username@servername (root@localhost)
</code></pre>

And finally:

<pre><code>Enter password:*********
</code></pre>

blocks|key|771366|text|使用以下命令连接到MySQL数据库|type|unstyled|depth|inlineStyleRanges|entityRanges|data|771367|mysql+-u用户名-h主机名-p|771368|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

Use the following command to get connected to your MySQL database

mysql -u USERNAME -h HOSTNAME -p

blocks|key|985921|text|使用正确的MySQL用户名和密码直接连接到MySQL的一种方法是：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|985922|mysql+--user=root+--password=mypass|code-block|syntax|javascript|985923|这里,|985924|root+is+the+MySQL+username
mypass+is+the+MySQL+user+password|985925|如果您的密码为空，这将非常有用。|985926|例如，如果您的MySQL用户名为root，但密码为空，则只需使用|offset|length|style|CODE|985927|mysql+--user=root+--password=|985928|entityMap^0|0|0|0|0|0|G|4|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Y|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|Z|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|10|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|11|8|@$O|12|P|13|Q|R]]|9|@]|A|$]]|$1|S|3|T|5|D|7|14|8|@]|9|@]|A|$E|F]]|$1|U|3|-4|5|6|7|15|8|@]|9|@]|A|$]]]|V|$]]

One way to connect to MySQL directly using proper MySQL username and password is:

<pre><code>mysql --user=root --password=mypass
</code></pre>

Here, 

<pre><code>root is the MySQL username
mypass is the MySQL user password
</code></pre>

This is useful if you have a blank password. 

For example, if you have MySQL user called <code>root</code> with an empty password, just use 

<pre><code>mysql --user=root --password=
</code></pre>

blocks|key|771499|text|有时您可能需要为端口添加-P：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|771500|mysql+-u+USERNAME+-pPASSWORD+-h+HOSTNAME+-P+PORTNUMBER+DATABASE;|code-block|syntax|javascript|771501|entityMap^0|C|2|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|P|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|L|$]]

Sometimes you may need to add <code>-P</code> for port:
<pre class="lang-sql prettyprint-override"><code>mysql -u USERNAME -pPASSWORD -h HOSTNAME -P PORTNUMBER DATABASE;
</code></pre>

blocks|key|771522|text|在我的例子中，它在Mac上使用以下命令工作。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|771523|运行MySQL外壳程序后，您将看到以下内容：|771524|mysql-js>|code-block|syntax|javascript|771525|首先，你应该：|771526|mysql-js>\sql|771527|第二步：|771528|MySQL++SQL+>+\c+--mysql+username@host|771529|最后，根据提示提供密码|771530|entityMap^0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|V|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|W|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|X|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|Y|8|@]|9|@]|A|$G|H]]|$1|M|3|N|5|6|7|Z|8|@]|9|@]|A|$]]|$1|O|3|P|5|F|7|10|8|@]|9|@]|A|$G|H]]|$1|Q|3|R|5|6|7|11|8|@]|9|@]|A|$]]|$1|S|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|T|$]]

In my case, it worked with the following command on Mac.
After you run MySQL Shell and you have seen the following:
<pre class="lang-sh prettyprint-override"><code>mysql-js&gt;
</code></pre>
Firstly, you should:
<pre class="lang-sh prettyprint-override"><code>mysql-js&gt;\sql
</code></pre>
Second step:
<pre class="lang-sh prettyprint-override"><code>MySQL SQL &gt; \c --mysql username@host
</code></pre>
Then finally provide the password as prompted

blocks|key|771461|text|这对我很有效::-|type|unstyled|depth|inlineStyleRanges|entityRanges|data|771462|mysql+--host=hostNameorIp+--user=username+--password=password++|code-block|syntax|javascript|771463|或|771464|mysql+--host=hostNameorIp+--user=username+--password=password+database_name|771465|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

This worked for me ::-

<pre><code>mysql --host=hostNameorIp --user=username --password=password 
</code></pre>

or

<pre><code>mysql --host=hostNameorIp --user=username --password=password database_name
</code></pre>

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.

connecting to MySQL from the command line

SQL数据库

数据库

MySQL

在苹果电脑中，如何从命令行连接到MySQL？(即给我看代码)我正在做一个PHP/SQL教程，但它首先假设您已经在MySQL中。

问从命令行连接到MySQL
EN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问从命令行连接到MySQLEN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问从命令行连接到MySQL
EN