mysql 以 localhost 和 127.0.0.1 登陆的区别

robch

已于 2023-06-07 11:50:36 修改

阅读量185

点赞数

分类专栏：数据库文章标签： mysql 数据库

于 2023-06-06 17:14:40 首次发布

本文链接：https://blog.csdn.net/cpxsxn/article/details/131072021

版权

数据库专栏收录该内容

36 篇文章 0 订阅

订阅专栏

以 localhost 登陆，表示用 socket 登陆

➜  ~ mysql -uroot -hlocalhost  -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2036
Server version: 5.7.23 MySQL Community Server (GPL)

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> status
--------------
mysql  Ver 14.14 Distrib 5.7.23, for macos10.13 (x86_64) using  EditLine wrapper

Connection id:			2036
Current database:
Current user:			root@localhost
SSL:			    	Not in use
Current pager:			less
Using outfile:			''
Using delimiter:		;
Server version:			5.7.23 MySQL Community Server (GPL)
Protocol version:		10
Connection:				Localhost via UNIX socket
Server characterset:	latin1
Db     characterset:	latin1
Client characterset:	utf8
Conn.  characterset:	utf8
UNIX socket:			/tmp/mysql.sock
Uptime:				4 days 6 hours 9 min 25 sec

Threads: 1  Questions: 71  Slow queries: 0  Opens: 117  Flush tables: 1  Open tables: 110  Queries per second avg: 0.000
--------------

mysql>

以 127.0.0.1 登陆，表示用 TCP/IP 登陆

➜  ~ mysql -uroot -h127.0.0.1 -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2037
Server version: 5.7.23 MySQL Community Server (GPL)

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> status
--------------
mysql  Ver 14.14 Distrib 5.7.23, for macos10.13 (x86_64) using  EditLine wrapper

Connection id:			2037
Current database:
Current user:			root@localhost
SSL:					Not in use
Current pager:			less
Using outfile:			''
Using delimiter:		;
Server version:			5.7.23 MySQL Community Server (GPL)
Protocol version:		10
Connection:				127.0.0.1 via TCP/IP
Server characterset:	latin1
Db     characterset:	latin1
Client characterset:	utf8
Conn.  characterset:	utf8
TCP port:		3306
Uptime:			4 days 6 hours 13 min 33 sec

Threads: 1  Questions: 76  Slow queries: 0  Opens: 117  Flush tables: 1  Open tables: 110  Queries per second avg: 0.000
--------------

mysql>