mysql的登陸和退出命令

發(fā)布時間：2020-10-29 21:09:49 來源：億速云閱讀：156 作者：Leah 欄目：開發(fā)技術(shù)

這篇文章運(yùn)用簡單易懂的例子給大家介紹mysql的登陸和退出命令，內(nèi)容非常詳細(xì)，感興趣的小伙伴們可以參考借鑒，希望對大家能有所幫助。

mysql登陸的命令格式為：

mysql -h [hostip] -u [username] -p [password] [database]

1.普通登陸mysql數(shù)據(jù)庫
命令格式：mysql -u 用戶名 -p 密碼，例如: mysql -u root -p root如果在-p后沒有提供密碼，則會在執(zhí)行命令后要求用戶輸入密碼

mysql的登陸和退出命令

2.制定端口號登陸，mysql的默認(rèn)端口號是3306，
命令格式：mysql -u 用戶名 -p 密碼 -P 端口號
即可，注意指定端口的字母P為大寫，而標(biāo)識密碼的p為小寫。

mysql的登陸和退出命令

3.指定IP地址和端口號登錄MySQL數(shù)據(jù)庫
命令格式為：mysql -h ip -u 用戶 -p -P 端口號
例如：mysql -h 127.0.0.1 -u root -p -P 3306

mysql的登陸和退出命令

4.制定數(shù)據(jù)庫登陸
mysql -h ip地址 -u 用戶名 -p 密碼數(shù)據(jù)庫名
例如：mysql -h 127.0.0.1 -u root -p test

查看當(dāng)前登陸用戶和數(shù)據(jù)庫

mysql的登陸和退出命令

select user();
  select database();

退出登陸命令
登陸進(jìn)入mysql進(jìn)入之后，可能到下面的提示信息，可以help看看輸出結(jié)果

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 ';'
&#63;     (\&#63;) 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. exit
2. quit
3. \q

關(guān)于mysql的登陸和退出命令就分享到這里了，希望以上內(nèi)容可以對大家有一定的幫助，可以學(xué)到更多知識。如果覺得文章不錯，可以把它分享出去讓更多的人看到。

向AI問一下細(xì)節(jié)

mysql的登陸和退出命令

猜你喜歡

最新資訊

相關(guān)推薦

相關(guān)標(biāo)簽