mysqladmin

Question

Hi what is the role of mysqladmin in mysql server? Thanks

Chintan Rathod · Answer

Purpose : mysqladmin is a client for performing administrative operations. You can use it to check the server's configuration and current status to create and drop databases and more.. shell> mysqladmin [ options ] command [ command-arg ] [ command [ command-arg ]] Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable{mso-style-name:Table Normal;mso-tstyle-rowband-size:0;mso-tstyle-colband-size:0;mso-style-noshow:yes;mso-style-priority:99;mso-style-qformat:yes;mso-style-parent:;mso-padding-alt:0in 5.4pt 0in 5.4pt;mso-para-margin-top:0in;mso-para-margin-right:0in;mso-para-margin-bottom:10.0pt;mso-para-margin-left:0in;line-height:115%;mso-pagination:widow-orphan;font-size:11.0pt;font-family:Calibrisans-serif;mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;mso-fareast-font-family:Times New Roman;mso-fareast-theme-font:minor-fareast;mso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;} mysqladmin supports the following commands. Some of the commands take an argument following the command name. Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable{mso-style-name:Table Normal;mso-tstyle-rowband-size:0;mso-tstyle-colband-size:0;mso-style-noshow:yes;mso-style-priority:99;mso-style-qformat:yes;mso-style-parent:;mso-padding-alt:0in 5.4pt 0in 5.4pt;mso-para-margin-top:0in;mso-para-margin-right:0in;mso-para-margin-bottom:10.0pt;mso-para-margin-left:0in;line-height:115%;mso-pagination:widow-orphan;font-size:11.0pt;font-family:Calibrisans-serif;mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;mso-fareast-font-family:Times New Roman;mso-fareast-theme-font:minor-fareast;mso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;}table.MsoTableGrid{mso-style-name:Table Grid;mso-tstyle-rowband-size:0;mso-tstyle-colband-size:0;mso-style-priority:59;mso-style-unhide:no;border:solid black 1.0pt;mso-border-themecolor:text1;mso-border-alt:solid black .5pt;mso-border-themecolor:text1;mso-padding-alt:0in 5.4pt 0in 5.4pt;mso-border-insideh:.5pt solid black;mso-border-insideh-themecolor:text1;mso-border-insidev:.5pt solid black;mso-border-insidev-themecolor:text1;mso-para-margin:0in;mso-para-margin-bottom:.0001pt;mso-pagination:widow-orphan;font-size:11.0pt;font-family:Calibrisans-serif;mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;mso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;} Command Meaning create db_name Create a new database named db_name . debug Tell the server to write debug information to the error log. drop db_name Delete the database named db_name and all its tables. extended-status Display the server status variables and their values. flush-hosts Flush all information in the host cache. flush-logs Flush all logs. flush-privileges Reload the grant tables flush-status Clear status variables. flush-tables Flush all tables. flush-threads Flush the thread cache. kill id  id ... Kill server threads. If multiple thread ID values are given there must be no spaces in the list. old-password new-password This is like the password command but stores the password using the old password-hashing format. password new-password Set a new password. This changes the password to new-password for the account that you use with mysqladmin for connecting to the server. Ping Check whether the server is available. Processlist Show a list of active server threads. Reload Reload the grant tables. Refresh Flush all tables and close and open log files. Shutdown Stop the server. start-slave Start replication on a slave server. Status Display a short server status message. stop-slave Stop replication on a slave server. Variables Display the server system variables and their values. Version Display version information from the server.