blocks|key|1100793|text|如果您已经登录到命令行客户端，请尝试执行以下操作：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1100794|mysql>+select+user();|code-block|syntax|javascript|1100795|它将输出类似以下内容的内容：|1100796|%2B----------------%2B
%7C+user()+++++++++%7C
%2B----------------%2B
%7C+root@localhost+%7C
%2B----------------%2B
1+row+in+set+(0.41+sec)|1100797|在上面的示例中，我以root的身份从localhost登录。|offset|length|style|CODE|1100798|要查找端口号和其他有趣的设置，请使用以下命令：|1100799|mysql>+show+variables;|1100800|entityMap^0|0|0|0|0|A|4|I|9|0|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|@$M|11|N|12|O|P]|$M|13|N|14|O|P]]|9|@]|A|$]]|$1|Q|3|R|5|6|7|15|8|@]|9|@]|A|$]]|$1|S|3|T|5|D|7|16|8|@]|9|@]|A|$E|F]]|$1|U|3|-4|5|6|7|17|8|@]|9|@]|A|$]]]|V|$]]

If you're already logged into the command line client try this:

<pre><code>mysql&gt; select user();
</code></pre>

It will output something similar to this:

<pre><code>+----------------+
| user() |
+----------------+
| root@localhost |
+----------------+
1 row in set (0.41 sec)
</code></pre>

In my example above, I was logged in as <code>root</code> from <code>localhost</code>.

To find port number and other interesting settings use this command:

<pre><code>mysql&gt; show variables;
</code></pre>

blocks|key|1100923|text|例如，您可以尝试：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1100924|//If+you+want+to+get+user,+you+need+start+query+in+your+mysql:
SELECT+user();+//+output+your+user:+root@localhost
SELECT+system_user();+//+--

//If+you+want+to+get+port+your+"mysql://user:pass@hostname:port/db"
SELECT+@@port;+//3306+is+default

//If+you+want+hostname+your+db,+you+can+execute+query
SELECT+@@hostname;|code-block|syntax|javascript|1100925|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

For example, you can try:

<pre><code>//If you want to get user, you need start query in your mysql:
SELECT user(); // output your user: root@localhost
SELECT system_user(); // --

//If you want to get port your "mysql://user:pass@hostname:port/db"
SELECT @@port; //3306 is default

//If you want hostname your db, you can execute query
SELECT @@hostname;
</code></pre>

blocks|key|1100976|text|如果您不知道确切的变量名，请使用like，因为结果可能包含超过500行：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1100977|mysql>+show+variables+like+"%25port%25";|code-block|syntax|javascript|1100978|entityMap^0|G|4|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|$]]

If you don't know the exact variable name use <code>like</code>, as the result may contain more than 500 rows:

<pre><code>mysql&gt; show variables like "%port%";
</code></pre>

blocks|key|886009|text|default-username+=+root
password+=+you-know-it-better
url+for+localhost+=++jdbc:mysql://localhost
default-port+=+3306|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|886010|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>default-username = root
password = you-know-it-better
url for localhost = jdbc:mysql://localhost
default-port = 3306
</code></pre>

blocks|key|1101089|text|如果使用MySQL工作台，只需查看位于侧边栏的信息窗格中的会话选项卡。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1101090|​|1101091|📷|atomic|offset|length|1101092|1101093|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/3ad08eb5cdc593a76104a2c19aefaca3.png|imageAlt^0|0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@$G|V|H|W|1|X]]|A|$]]|$1|I|3|C|5|6|7|Y|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|Q|R|-4]]]]

If using MySQL Workbench, simply look in the Session tab in the Information pane located in the sidebar.

<a href="https://i.stack.imgur.com/ihaIr.png" rel="noreferrer"><img src="https://i.stack.imgur.com/ihaIr.png" alt="enter image description here"></a>

blocks|key|1100856|text|如果您使用phpMyAdmin，请单击顶部菜单上的Home，然后单击Variables。在页面上查找port设置。它设置的值是运行MySQL服务器的端口。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1100857|entityMap^0|P|4|Y|9|1E|4|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]|$9|M|A|N|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|O|8|@]|D|@]|E|$]]]|G|$]]

If you use phpMyAdmin, click on <code>Home</code>, then <code>Variables</code> on the top menu. Look for the <code>port</code> setting on the page. The value it is set to is the port your MySQL server is running on.

blocks|key|1100894|text|mysql>+SHOW+VARIABLES+WHERE+Variable_name+=+'hostname';
%2B---------------%2B-----------%2B
%7C+Variable_name+%7C+Value+++++%7C
%2B---------------%2B-----------%2B
%7C+hostname++++++%7C+karola-pc+%7C
%2B---------------%2B-----------%2B
1+row+in+set+(0.00+sec)|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1100895|例如，在我的例子中：karola-pc是运行mysql的机器的主机名。并且它是我本地的PC主机名。|unstyled|offset|length|style|CODE|1100896|如果是远程计算机，则您可以直接ping通该主机，前提是，如果您与该计算机处于网络中，则应该能够ping通该主机。|1100897|如果在终端中使用UNIX+or+Linux+you+can+run+"hostname"+command命令来检查主机名。如果是windows，您可以在MyComputer->+right+click+->+properties+->Computer+Name中看到相同的值(即系统属性)|1100898|希望它能回答你的问题。|1100899|entityMap^0|0|A|9|0|0|8|18|24|1I|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|T|8|@$G|U|H|V|I|J]]|9|@]|A|$]]|$1|K|3|L|5|F|7|W|8|@]|9|@]|A|$]]|$1|M|3|N|5|F|7|X|8|@$G|Y|H|Z|I|J]|$G|10|H|11|I|J]]|9|@]|A|$]]|$1|O|3|P|5|F|7|12|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|F|7|13|8|@]|9|@]|A|$]]]|R|$]]

<pre><code>mysql&gt; SHOW VARIABLES WHERE Variable_name = 'hostname';
+---------------+-----------+
| Variable_name | Value |
+---------------+-----------+
| hostname | karola-pc |
+---------------+-----------+
1 row in set (0.00 sec)
</code></pre>

For Example in my case : <code>karola-pc</code> is the host name of the box where my mysql is running. And it my local PC host name. 

If it is romote box than you can ping that host directly if, If you are in network with that box you should be able to ping that host.

If it <code>UNIX or Linux you can run "hostname" command</code> in terminal to check the host name.
if it is windows you can see same value in <code>MyComputer-&gt; right click -&gt; properties -&gt;Computer Name</code> you can see ( i.e System Properties) 

Hope it will answer your Q.

blocks|key|886343|text|在本地主机或专用服务器上，转到phpMyAdmin内部的config.inc文件|type|unstyled|depth|inlineStyleRanges|entityRanges|data|886344|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

on local host or dedicated server, go to config.inc file inside phpMyAdmin

I need to find my MySQL username. When I open the MySQL command line client, it only asks me for my password. I don't remember my username. And for connectivity with JDBC, I need the URL, host and port number. Where do I find all of these?

How do I find out my MySQL URL, host, port and username?

服务器

MySQL

Linux

我需要找到我的MySQL用户名。当我打开MySQL命令行客户端时，它只要求我输入密码。我不记得我的用户名了。为了与JDBC连接，我需要URL、主机和端口号。我在哪里可以找到所有这些？

问如何找到我的MySQL地址、主机、端口和用户名？
EN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何找到我的MySQL地址、主机、端口和用户名？EN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何找到我的MySQL地址、主机、端口和用户名？
EN