31 - Mysql - 登陆 - mysql -u用户名 -p

MySQL基本命令

mysql -h127.0.0.1 -P3306 -uroot -pxxx -Dtest
# 参数
-h:host主机，默认本地127.0.0.1
-P:port端口，默认3306
-u:user用户名
-p:password密码
-D:database数据库
mysql -u root -p
mysql -u xxx -p

-p后面不要加密码，虽然可以，但是不要这样做，为了安全
然后输入密码，输入正确密码后立刻进入mysql

此时可以使用库 - 进入 - use XXX; 进入您创建的数据库，也可以进入初始库：初始库1/4 - information_schema - 信息数据库详解、初始库2/4 - mysql - 详解、初始库3/4 - performance_schema - 性能优化详解

也可以使用监控类的sql语句：监控 - 执行性能监控 - Show Profile

详细释义一下输出的信息：

Welcome to the MySQL monitor. Commands end with ; or \g.
欢迎进入MySQL监视器 通过分号; 和\g结束命令

Your MySQL connection id is 15
你本次的MySQL连接id是15，如果你exit退出MySQL在连上来会增加为16

Server version: 8.3.0 MySQL Community Server - GPL
系统版本是8.3.0

Copyright (c) 2000, 2024, Oracle and/or its affiliates.
来自Oracle公司的产品

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
可以help;或者\h 来获得帮助
键入’\c’以清除当前输入语句

help;和\h 帮助

For information about MySQL products and services, visit:
http://www.mysql.com/
For developer information, including the MySQL Reference Manual, visit:
http://dev.mysql.com/
To buy MySQL Enterprise support, training, or other products, visit:
https://shop.mysql.com/

List of all MySQL commands:
Note that all text commands must be first on line and end with ‘;’
? (\?) Synonym for `help’.
clear (\c) Clear the current input statement.
connect (\r) Reconnect to the server. Optional arguments are db and host.
delimiter (\d) Set statement delimiter.
edit (\e) Edit command with $EDITOR.
ego (\G) Send command to mysql server, display result vertically.
exit (\q) Exit mysql. Same as quit.
go (\g) Send command to mysql server.
help (\h) Display this help.
nopager (\n) Disable pager, print to stdout.
notee (\t) Don’t write into outfile.
pager (\P) Set PAGER [to_pager]. Print the query results via PAGER.
print (\p) Print current command.
prompt (\R) Change your mysql prompt.
quit (\q) Quit mysql.
rehash (#) Rebuild completion hash.
source (.) Execute an SQL script file. Takes a file name as an argument.
status (\s) Get status information from the server.
system (!) Execute a system shell command.
tee (\T) Set outfile [to_outfile]. Append everything into given outfile.
use (\u) Use another database. Takes database name as argument.
charset (\C) Switch to another charset. Might be needed for processing binlog with multi-byte charsets.
warnings (\W) Show warnings after every statement.
nowarning (\w) Don’t show warnings after every statement.
resetconnection(\x) Clean session context.
query_attributes Sets string parameters (name1 value1 name2 value2 …) for the next query to pick up.
ssl_session_data_print Serializes the current SSL session data to stdout or file

For server side help, type ‘help contents’