Advertisement
Guest User

Untitled

a guest
Aug 14th, 2017
136
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.61 KB | None | 0 0
  1. Microsoft Windows XP [Versión 5.1.2600]
  2. (C) Copyright 1985-2001 Microsoft Corp.
  3.  
  4. C:\Documents and Settings\Administrador>/mysql/bin/mysql - User -p -h icc.uandes
  5. .cl
  6. /mysql/bin/mysql Ver 14.14 Distrib 5.5.11, for Win32 (x86)
  7. Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
  8.  
  9. Oracle is a registered trademark of Oracle Corporation and/or its
  10. affiliates. Other names may be trademarks of their respective
  11. owners.
  12.  
  13. Usage: /mysql/bin/mysql [OPTIONS] [database]
  14. -?, --help Display this help and exit.
  15. -I, --help Synonym for -?
  16. --auto-rehash Enable automatic rehashing. One doesn't need to use
  17. 'rehash' to get table and field completion, but startup
  18. and reconnecting may take a longer time. Disable with
  19. --disable-auto-rehash.
  20. (Defaults to on; use --skip-auto-rehash to disable.)
  21. -A, --no-auto-rehash
  22. No automatic rehashing. One has to use 'rehash' to get
  23. table and field completion. This gives a quicker start of
  24. mysql and disables rehashing on reconnect.
  25. --auto-vertical-output
  26. Automatically switch to vertical output mode if the
  27. result is wider than the terminal width.
  28. -B, --batch Don't use history file. Disable interactive behavior.
  29. (Enables --silent.)
  30. --character-sets-dir=name
  31. Directory for character set files.
  32. --column-type-info Display column type information.
  33. -c, --comments Preserve comments. Send comments to the server. The
  34. default is --skip-comments (discard comments), enable
  35. with --comments.
  36. -C, --compress Use compression in server/client protocol.
  37. -#, --debug[=#] This is a non-debug version. Catch this and exit.
  38. --debug-check Check memory and open file usage at exit.
  39. -T, --debug-info Print some debug info at exit.
  40. -D, --database=name Database to use.
  41. --default-character-set=name
  42. Set the default character set.
  43. --delimiter=name Delimiter to be used.
  44. -e, --execute=name Execute command and quit. (Disables --force and history
  45. file.)
  46. -E, --vertical Print the output of a query (rows) vertically.
  47. -f, --force Continue even if we get an SQL error.
  48. -G, --named-commands
  49. Enable named commands. Named commands mean this program's
  50. internal commands; see mysql> help . When enabled, the
  51. named commands can be used from any line of the query,
  52. otherwise only from the first line, before an enter.
  53. Disable with --disable-named-commands. This option is
  54. disabled by default.
  55. -i, --ignore-spaces Ignore space after function names.
  56. --init-command=name SQL Command to execute when connecting to MySQL server.
  57. Will automatically be re-executed when reconnecting.
  58. --local-infile Enable/disable LOAD DATA LOCAL INFILE.
  59. -b, --no-beep Turn off beep on error.
  60. -h, --host=name Connect to host.
  61. -H, --html Produce HTML output.
  62. -X, --xml Produce XML output.
  63. --line-numbers Write line numbers for errors.
  64. (Defaults to on; use --skip-line-numbers to disable.)
  65. -L, --skip-line-numbers
  66. Don't write line number for errors.
  67. -n, --unbuffered Flush buffer after each query.
  68. --column-names Write column names in results.
  69. (Defaults to on; use --skip-column-names to disable.)
  70. -N, --skip-column-names
  71. Don't write column names in results.
  72. --sigint-ignore Ignore SIGINT (CTRL-C).
  73. -o, --one-database Ignore statements except those that occur while the
  74. default database is the one named at the command line.
  75. -p, --password[=name]
  76. Password to use when connecting to server. If password is
  77. not given it's asked from the tty.
  78. -W, --pipe Use named pipes to connect to server.
  79. -P, --port=# Port number to use for connection or 0 for default to, in
  80. order of preference, my.cnf, $MYSQL_TCP_PORT,
  81. /etc/services, built-in default (3306).
  82. --prompt=name Set the mysql prompt to this value.
  83. --protocol=name The protocol to use for connection (tcp, socket, pipe,
  84. memory).
  85. -q, --quick Don't cache result, print it row by row. This may slow
  86. down the server if the output is suspended. Doesn't use
  87. history file.
  88. -r, --raw Write fields without conversion. Used with --batch.
  89. --reconnect Reconnect if the connection is lost. Disable with
  90. --disable-reconnect. This option is enabled by default.
  91. (Defaults to on; use --skip-reconnect to disable.)
  92. -s, --silent Be more silent. Print results with a tab as separator,
  93. each row on new line.
  94. --shared-memory-base-name=name
  95. Base name of shared memory.
  96. -S, --socket=name The socket file to use for connection.
  97. --ssl Enable SSL for connection (automatically enabled with
  98. other flags).
  99. --ssl-ca=name CA file in PEM format (check OpenSSL docs, implies
  100. --ssl).
  101. --ssl-capath=name CA directory (check OpenSSL docs, implies --ssl).
  102. --ssl-cert=name X509 cert in PEM format (implies --ssl).
  103. --ssl-cipher=name SSL cipher to use (implies --ssl).
  104. --ssl-key=name X509 key in PEM format (implies --ssl).
  105. --ssl-verify-server-cert
  106. Verify server's "Common Name" in its cert against
  107. hostname used when connecting. This option is disabled by
  108. default.
  109. -t, --table Output in table format.
  110. --tee=name Append everything into outfile. See interactive help (\h)
  111. also. Does not work in batch mode. Disable with
  112. --disable-tee. This option is disabled by default.
  113. -u, --user=name User for login if not current user.
  114. -U, --safe-updates Only allow UPDATE and DELETE that uses keys.
  115. -U, --i-am-a-dummy Synonym for option --safe-updates, -U.
  116. -v, --verbose Write more. (-v -v -v gives the table output format).
  117. -V, --version Output version information and exit.
  118. -w, --wait Wait and retry if connection is down.
  119. --connect-timeout=# Number of seconds before connection timeout.
  120. --max-allowed-packet=#
  121. The maximum packet length to send to or receive from
  122. server.
  123. --net-buffer-length=#
  124. The buffer size for TCP/IP and socket communication.
  125. --select-limit=# Automatic limit for SELECT when using --safe-updates.
  126. --max-join-size=# Automatic limit for rows in a join when using
  127. --safe-updates.
  128. --secure-auth Refuse client connecting to server if it uses old
  129. (pre-4.1.1) protocol.
  130. --server-arg=name Send embedded server this as a parameter.
  131. --show-warnings Show warnings after every statement.
  132. --plugin-dir=name Directory for client-side plugins.
  133. --default-auth=name Default authentication client-side plugin to use.
  134.  
  135. Default options are read from the following files in the given order:
  136. C:\WINDOWS\my.ini C:\WINDOWS\my.cnf C:\my.ini C:\my.cnf C:\mysql\my.ini C:\mysql
  137. \my.cnf
  138. The following groups are read: mysql client
  139. The following options may be given as the first argument:
  140. --print-defaults Print the program argument list and exit.
  141. --no-defaults Don't read default options from any option file.
  142. --defaults-file=# Only read default options from the given file #.
  143. --defaults-extra-file=# Read this file after the global files are read.
  144.  
  145. Variables (--variable-name=value)
  146. and boolean options {FALSE|TRUE} Value (after reading options)
  147. --------------------------------- ----------------------------------------
  148. auto-rehash TRUE
  149. auto-vertical-output FALSE
  150. character-sets-dir (No default value)
  151. column-type-info FALSE
  152. comments FALSE
  153. compress FALSE
  154. debug-check FALSE
  155. debug-info FALSE
  156. database (No default value)
  157. default-character-set auto
  158. delimiter ;
  159. vertical FALSE
  160. force FALSE
  161. named-commands FALSE
  162. ignore-spaces FALSE
  163. init-command (No default value)
  164. local-infile FALSE
  165. no-beep FALSE
  166. host icc.uandes.cl
  167. html FALSE
  168. xml FALSE
  169. line-numbers TRUE
  170. unbuffered FALSE
  171. column-names TRUE
  172. sigint-ignore FALSE
  173. port 0
  174. prompt mysql>
  175. quick FALSE
  176. raw FALSE
  177. reconnect TRUE
  178. shared-memory-base-name (No default value)
  179. socket (No default value)
  180. ssl FALSE
  181. ssl-ca (No default value)
  182. ssl-capath (No default value)
  183. ssl-cert (No default value)
  184. ssl-cipher (No default value)
  185. ssl-key (No default value)
  186. ssl-verify-server-cert FALSE
  187. table FALSE
  188. user (No default value)
  189. safe-updates FALSE
  190. i-am-a-dummy FALSE
  191. connect-timeout 0
  192. max-allowed-packet 16777216
  193. net-buffer-length 16384
  194. select-limit 1000
  195. max-join-size 1000000
  196. secure-auth FALSE
  197. show-warnings FALSE
  198. plugin-dir (No default value)
  199. default-auth (No default value)
  200.  
  201. C:\Documents and Settings\Administrador>/mysql/bin/mysql -u User -p -h icc.uande
  202. s.cl
  203. Enter password: *******
  204. ERROR 1045 (28000): Access denied for user 'User'@'190.162.35.182' (using passwo
  205. rd: YES)
  206.  
  207. C:\Documents and Settings\Administrador>/mysql/bin/mysql -u User -p -h icc.uande
  208. s.cl
  209. Enter password: *******
  210. ERROR 1045 (28000): Access denied for user 'User'@'190.162.35.182' (using passwo
  211. rd: YES)
  212.  
  213. C:\Documents and Settings\Administrador>/mysql/bin/mysql -u grupo05r -p -h icc.u
  214. andes.cl
  215. Enter password: *******
  216. ERROR 1045 (28000): Access denied for user 'grupo05r'@'190.162.35.182' (using pa
  217. ssword: YES)
  218.  
  219. C:\Documents and Settings\Administrador>/mysql/bin/mysql -u grupo05 -p -h icc.ua
  220. ndes.cl
  221. Enter password: *******
  222. Welcome to the MySQL monitor. Commands end with ; or \g.
  223. Your MySQL connection id is 113
  224. Server version: 5.0.77 Source distribution
  225.  
  226. Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
  227.  
  228. Oracle is a registered trademark of Oracle Corporation and/or its
  229. affiliates. Other names may be trademarks of their respective
  230. owners.
  231.  
  232. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
  233.  
  234. mysql>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement