mysql命令行连接

最新推荐文章于 2025-03-21 16:34:31 发布

wan_zaiyunduan

最新推荐文章于 2025-03-21 16:34:31 发布

阅读量2.1w

点赞数

分类专栏：数据库文章标签： mysql命令行连接 mysql

本文链接：https://blog.csdn.net/wan_zaiyunduan/article/details/80191170

版权

数据库专栏收录该内容

18 篇文章

订阅专栏

命令行连接

mysql -u 用户名 -p密码 -h 服务器IP地址 -P 服务器端MySQL端口号 -D 数据库名

注意：

(1)服务器端口标志-P一定要大些以区别于用户-p,如果直接连接数据库标志-D也要大写；

(2)如果要直接输入密码-p后面不能留有空格如-pmypassword;

(3)命令结束段没有';'分号。

MC:~ Smarter$ mysql -u usrname -h hostname -P port -D dbname -p

Enter password: 

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A




Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 25561133

Server version: 5.6.36-82.0-log Percona Server (GPL), Release 82.0, Revision 58e846a




Copyright (c) 2000, 2017, 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>