no way to compare when less than two revisions
Differences
This shows you the differences between two versions of the page.
| — | mysqladmin [2014/08/28 16:30] (current) – created - external edit 127.0.0.1 | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | ====== mysqladmin ====== | ||
| + | * [[MySQL]] | ||
| + | * [[MySQL Privileges]] | ||
| + | * [[mysqldump]] | ||
| + | * [[mysqlimport]] | ||
| + | |||
| + | **Syntax** | ||
| + | |||
| + | < | ||
| + | mysqladmin [options] < | ||
| + | </ | ||
| + | |||
| + | == Create Database == | ||
| + | |||
| + | < | ||
| + | mysqladmin create < | ||
| + | </ | ||
| + | |||
| + | == Drop Database == | ||
| + | |||
| + | < | ||
| + | mysqladmin drop < | ||
| + | </ | ||
| + | |||
| + | == Flush logs == | ||
| + | |||
| + | **Gotcha:** '' | ||
| + | |||
| + | < | ||
| + | mysqladmin flush | ||
| + | </ | ||
| + | |||
| + | == Privileges == | ||
| + | |||
| + | Reload the grant tables. | ||
| + | |||
| + | < | ||
| + | mysqladmin flush-privileges | ||
| + | </ | ||
| + | |||
| + | Or: | ||
| + | |||
| + | < | ||
| + | mysqladmin reload | ||
| + | </ | ||
| + | |||
| + | == Change Password == | ||
| + | |||
| + | Mine: | ||
| + | |||
| + | < | ||
| + | mysqladmin password < | ||
| + | </ | ||
| + | |||
| + | Another user' | ||
| + | |||
| + | < | ||
| + | mysqladmin -u < | ||
| + | </ | ||
| + | |||
| + | == Show Processes == | ||
| + | |||
| + | < | ||
| + | mysqladmin proc | ||
| + | </ | ||
| + | |||
| + | == Kill Process == | ||
| + | |||
| + | < | ||
| + | mysqladmin kill <id> | ||
| + | mysqladmin kill < | ||
| + | </ | ||
| + | |||
| + | == Server status == | ||
| + | |||
| + | < | ||
| + | mysqladmin status | ||
| + | Uptime: 59507 Threads: 1 Questions: 1423 Slow queries: 1 Opens: 2784 Flush tables: 1 Open tables: 64 Queries per second avg: 0.23 | ||
| + | </ | ||
| + | |||
| + | == Show system variables == | ||
| + | |||
| + | < | ||
| + | mysqladmin variables | ||
| + | </ | ||
