本篇文章小编给大家分享一下mysql的登陆和退出命令格式代码示例 文章代码介绍的很详细小编觉得
挺不错的 现在分享给大家供大家参考，有需要的小伙伴们可以来看看。
mysql登陆的命令格式为：
1个
- mysql -h [hostip] -u [username] -p [password] [database]
1.普通登陆mysql数据库
命令格式：mysql -u用户名-p密码，例如：mysql -u root -p root
如果在-p后没有提供密码，逐步在执行命令后要求用户输入密码
2.准备端口号登陆，mysql的默认端口号是3306，
命令格式：mysql -u用户名-p密码-P扩展号
即可 注意指定端口的字母P为大写，而标识密码的p为小写。
3.指定IP地址和端口号登录MySQL数据库
命令格式为：mysql -h ip -u用户-p -P扩展号
例如：mysql -h 127.0.0.1 -u root -p -P 3306
4.编制数据库登陆
mysql -h ip地址-u用户名-p密码数据库名
例如：mysql -h 127.0.0.1 -u root -p测试
查看当前登陆用户和数据库
1个
- 2
- select user();
- select database();
退出登陆命令
登陆进入mysql进入之后 可能到下面的提示信息，可以帮助看看输出结果
- mysql> help
- 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.
- For server side help, type 'help contents'
通过输出信息 我们知道如下三条退出mysql的命令
1.退出
2.退出
3.问 |
