如何通過命令列(command line)登陸rhel4 mysql
[root@localhost mysql]# mysql -h192.168.2.213 -uyisile -pdfyd8088
mysql: Unknown OS character set 'GB18030'.
mysql: Switching to the default character set 'latin1'.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 64377
Server version: 5.5.0-m2-community-log MySQL Community Server (GPL)
mysql: Unknown OS character set 'GB18030'.
mysql: Switching to the default character set 'latin1'.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 64377
Server version: 5.5.0-m2-community-log MySQL Community Server (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
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/
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.
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.
For server side help, type 'help contents'
mysql> use yisile_sns
Database changed
mysql> use yisile
Database changed
mysql> exit
Bye
Database changed
mysql> use yisile
Database changed
mysql> exit
Bye
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/9240380/viewspace-665149/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- MySQL命令列登陸,遠端登陸MySQLMySql命令列
- MySQL登陸命令列引數MySql命令列
- 解決Mysql中只能通過localhost登陸不能通過ip登陸的問題MySqllocalhost
- 如何(rhel4 mysql 5.5)在命令列模式中操作mysql(一)MySql命令列模式
- 通過session模擬登陸Session
- 如何登陸solaris10時進入字元模式(命令列)字元模式命令列
- rhel4 mysql5.1登陸ERROR 1045 (28000): Access denied for userMySqlError
- FFmpeg command line tool(Android中使用FFmpeg命令列)Android命令列
- 通過cmd命令列連線mysql資料庫命令列MySql資料庫
- 如何通過Python暴力破解網站登陸密碼Python網站密碼
- Python系列(5)- 命令列應用 (Command Line Application)Python命令列APP
- 如何在OS X 10.9 Mavericks下安裝Command Line Tools(命令列工具)命令列
- 通過論壇實現登陸的程式碼
- IDEA命令列縮短器助你解決此問題:Command line is too long. Shorten command line...Idea命令列
- postgresql如何登陸SQL
- fastadmin命令列模式--commandAST命令列模式
- MySQL入門--如何呼叫命令列命令MySql命令列
- MySQL 5.7 Command Line Client 閃屏退出MySqlclient
- [技巧]如何防止Linux命令列下MySQL登入密碼洩露?Linux命令列MySql密碼
- 如何通過命令列升級 Debian 9 為 Debian 10命令列
- 本地連線時,通過localhost不能登陸到指定的埠localhost
- 盤點Mysql的登陸方式MySql
- uni-app 通過命令列編譯打包APP命令列編譯
- Linux 通過命令列解析JSON字串Linux命令列JSON字串
- APEX 通過資料庫中使用者資訊驗證登陸資料庫
- 如何快速接入 GitHub 登陸Github
- 命令列客戶端MySQL如何使用命令列客戶端MySql
- mysql登陸報錯mysql: unknown variable 'basedir=MySql
- 教程:已在其地方登陸或會話已過期,請重新登陸會話
- 命令列登入Oracle命令列Oracle
- MySQL 遠端登陸踩坑記MySql
- Go通過cobra快速構建命令列應用Go命令列
- 通過RFT命令列執行測試指令碼命令列指令碼
- laravel:從linux命令列執行commandLaravelLinux命令列
- SSH安全登陸原理:密碼登陸與公鑰登陸密碼
- 【ARM-WINCE】WinCE5.0/6.0下,通過command line實現自動化編譯編譯
- MySQL通過通用列索引來提供一個JSON列索引MySql索引JSON
- 通過抓包實現Python模擬登陸各網站原理分析Python網站