API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Sep 26th, 2017
85
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.59 KB | None | 0 0
raw download clone embed print report
  1. --character-sets-dir=name
  2. Directory where character sets are.
  3. --default-character-set=name
  4. Set the default character set.
  5. -?, --help Display this help and exit.
  6. -h, --host=name Connect to host.
  7. -p, --password[=name]
  8. Password to use when connecting to server. If password is
  9. not given it's asked from the tty.
  10. -P, --port=# Port number to use for connection or 0 for default to, in
  11. order of preference, my.cnf, $MYSQL_TCP_PORT,
  12. /etc/services, built-in default (3306).
  13. --protocol=name The protocol of connection (tcp,socket,pipe,memory).
  14. -r, --relative Show difference between current and previous values when
  15. used with -i. Currently works only with extended-status.
  16. -O, --set-variable=name
  17. Change the value of a variable. Please note that this
  18. option is deprecated; you can set variables directly with
  19. --variable-name=value.
  20. -s, --silent Silently exit if one can't connect to server.
  21. -S, --socket=name Socket file to use for connection.
  22. -i, --sleep=# Execute commands again and again with a sleep between.
  23. --ssl Enable SSL for connection (automatically enabled with
  24. other flags). Disable with --skip-ssl.
  25. --ssl-ca=name CA file in PEM format (check OpenSSL docs, implies
  26. --ssl).
  27. --ssl-capath=name CA directory (check OpenSSL docs, implies --ssl).
  28. --ssl-cert=name X509 cert in PEM format (implies --ssl).
  29. --ssl-cipher=name SSL cipher to use (implies --ssl).
  30. --ssl-key=name X509 key in PEM format (implies --ssl).
  31. --ssl-verify-server-cert
  32. Verify server's "Common Name" in its cert against
  33. hostname used when connecting. This option is disabled by
  34. default.
  35. -u, --user=name User for login if not current user.
  36. -v, --verbose Write more information.
  37. -V, --version Output version information and exit.
  38. -E, --vertical Print output vertically. Is similar to --relative, but
  39. prints output vertically.
  40. -w, --wait[=#] Wait and retry if connection is down.
  41. --connect_timeout=#
  42. --shutdown_timeout=#
  43.  
  44. Variables (--variable-name=value)
  45. and boolean options {FALSE|TRUE} Value (after reading options)
  46. --------------------------------- -----------------------------
  47. count 0
  48. force FALSE
  49. compress FALSE
  50. character-sets-dir (No default value)
  51. default-character-set (No default value)
  52. host localhost
  53. port 0
  54. relative FALSE
  55. socket (No default value)
  56. sleep 0
  57. ssl FALSE
  58. ssl-ca (No default value)
  59. ssl-capath (No default value)
  60. ssl-cert (No default value)
  61. ssl-cipher (No default value)
  62. ssl-key (No default value)
  63. ssl-verify-server-cert FALSE
  64. user root
  65. verbose FALSE
  66. vertical FALSE
  67. connect_timeout 43200
  68. shutdown_timeout 3600
  69.  
  70. Default options are read from the following files in the given order:
  71. /etc/my.cnf ~/.my.cnf
  72. The following groups are read: mysqladmin client
  73. The following options may be given as the first argument:
  74. --print-defaults Print the program argument list and exit
  75. --no-defaults Don't read default options from any options file
  76. --defaults-file=# Only read default options from the given file #
  77. --defaults-extra-file=# Read this file after the global files are read
  78.  
  79. Where command is a one or more of: (Commands may be shortened)
  80. create databasename Create a new database
  81. debug Instruct server to write debug information to log
  82. drop databasename Delete a database and all its tables
  83. extended-status Gives an extended status message from the server
  84. flush-hosts Flush all cached hosts
  85. flush-logs Flush all logs
  86. flush-status Clear status variables
  87. flush-tables Flush all tables
  88. flush-threads Flush the thread cache
  89. flush-privileges Reload grant tables (same as reload)
  90. kill id,id,... Kill mysql threads
  91. password new-password Change old password to new-password, MySQL 4.1 hashing.
  92. old-password new-password Change old password to new-password in old format.
  93.  
  94. ping Check if mysqld is alive
  95. processlist Show list of active threads in server
  96. reload Reload grant tables
  97. refresh Flush all tables and close and open logfiles
  98. shutdown Take server down
  99. status Gives a short status message from the server
  100. start-slave Start slave
  101. stop-slave Stop slave
  102. variables Prints variables available
  103. version Get version info from server
  104. [root@ks207191 ~]# mysqladmin -h localhost -u root password Simplicity23@#
  105. mysqladmin: connect to server at 'localhost' failed
  106. error: 'Access denied for user 'root'@'localhost' (using password: NO)'
  107. [root@ks207191 ~]# mysqladmin -h localhost -u root -p
  108. mysqladmin Ver 8.41 Distrib 5.0.77, for redhat-linux-gnu on x86_64
  109. Copyright (C) 2000-2006 MySQL AB
  110. This software comes with ABSOLUTELY NO WARRANTY. This is free software,
  111. and you are welcome to modify and redistribute it under the GPL license
  112.  
  113. Administration program for the mysqld daemon.
  114. Usage: mysqladmin [OPTIONS] command command....
  115. -c, --count=# Number of iterations to make. This works with -i
  116. (--sleep) only.
  117. -#, --debug[=name] Output debug log. Often this is 'd:t:o,filename'.
  118. -f, --force Don't ask for confirmation on drop database; with
  119. multiple commands, continue even if an error occurs.
  120. -C, --compress Use compression in server/client protocol.
  121. --character-sets-dir=name
  122. Directory where character sets are.
  123. --default-character-set=name
  124. Set the default character set.
  125. -?, --help Display this help and exit.
  126. -h, --host=name Connect to host.
  127. -p, --password[=name]
  128. Password to use when connecting to server. If password is
  129. not given it's asked from the tty.
  130. -P, --port=# Port number to use for connection or 0 for default to, in
  131. order of preference, my.cnf, $MYSQL_TCP_PORT,
  132. /etc/services, built-in default (3306).
  133. --protocol=name The protocol of connection (tcp,socket,pipe,memory).
  134. -r, --relative Show difference between current and previous values when
  135. used with -i. Currently works only with extended-status.
  136. -O, --set-variable=name
  137. Change the value of a variable. Please note that this
  138. option is deprecated; you can set variables directly with
  139. --variable-name=value.
  140. -s, --silent Silently exit if one can't connect to server.
  141. -S, --socket=name Socket file to use for connection.
  142. -i, --sleep=# Execute commands again and again with a sleep between.
  143. --ssl Enable SSL for connection (automatically enabled with
  144. other flags). Disable with --skip-ssl.
  145. --ssl-ca=name CA file in PEM format (check OpenSSL docs, implies
  146. --ssl).
  147. --ssl-capath=name CA directory (check OpenSSL docs, implies --ssl).
  148. --ssl-cert=name X509 cert in PEM format (implies --ssl).
  149. --ssl-cipher=name SSL cipher to use (implies --ssl).
  150. --ssl-key=name X509 key in PEM format (implies --ssl).
  151. --ssl-verify-server-cert
  152. Verify server's "Common Name" in its cert against
  153. hostname used when connecting. This option is disabled by
  154. default.
  155. -u, --user=name User for login if not current user.
  156. -v, --verbose Write more information.
  157. -V, --version Output version information and exit.
  158. -E, --vertical Print output vertically. Is similar to --relative, but
  159. prints output vertically.
  160. -w, --wait[=#] Wait and retry if connection is down.
  161. --connect_timeout=#
  162. --shutdown_timeout=#
  163.  
  164. Variables (--variable-name=value)
  165. and boolean options {FALSE|TRUE} Value (after reading options)
  166. --------------------------------- -----------------------------
  167. count 0
  168. force FALSE
  169. compress FALSE
  170. character-sets-dir (No default value)
  171. default-character-set (No default value)
  172. host localhost
  173. port 0
  174. relative FALSE
  175. socket (No default value)
  176. sleep 0
  177. ssl FALSE
  178. ssl-ca (No default value)
  179. ssl-capath (No default value)
  180. ssl-cert (No default value)
  181. ssl-cipher (No default value)
  182. ssl-key (No default value)
  183. ssl-verify-server-cert FALSE
  184. user root
  185. verbose FALSE
  186. vertical FALSE
  187. connect_timeout 43200
  188. shutdown_timeout 3600
  189.  
  190. Default options are read from the following files in the given order:
  191. /etc/my.cnf ~/.my.cnf
  192. The following groups are read: mysqladmin client
  193. The following options may be given as the first argument:
  194. --print-defaults Print the program argument list and exit
  195. --no-defaults Don't read default options from any options file
  196. --defaults-file=# Only read default options from the given file #
  197. --defaults-extra-file=# Read this file after the global files are read
  198.  
  199. Where command is a one or more of: (Commands may be shortened)
  200. create databasename Create a new database
  201. debug Instruct server to write debug information to log
  202. drop databasename Delete a database and all its tables
  203. extended-status Gives an extended status message from the server
  204. flush-hosts Flush all cached hosts
  205. flush-logs Flush all logs
  206. flush-status Clear status variables
  207. flush-tables Flush all tables
  208. flush-threads Flush the thread cache
  209. flush-privileges Reload grant tables (same as reload)
  210. kill id,id,... Kill mysql threads
  211. password new-password Change old password to new-password, MySQL 4.1 hashing.
  212. old-password new-password Change old password to new-password in old format.
  213.  
  214. ping Check if mysqld is alive
  215. processlist Show list of active threads in server
  216. reload Reload grant tables
  217. refresh Flush all tables and close and open logfiles
  218. shutdown Take server down
  219. status Gives a short status message from the server
  220. start-slave Start slave
  221. stop-slave Stop slave
  222. variables Prints variables available
  223. version Get version info from server
  224. [root@ks207191 ~]#
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!