Enum DatabaseCommand

pub enum DatabaseCommand {
    CreateDb(DatabaseCreateArgs),
    DropDb(DatabaseDropArgs),
    ShowDb(DatabaseShowArgs),
    ShowDbPrivs(DatabaseShowPrivsArgs),
    EditDbPrivs(DatabaseEditPrivsArgs),
}

Variants

CreateDb(DatabaseCreateArgs)

Create one or more databases

DropDb(DatabaseDropArgs)

Delete one or more databases

ShowDb(DatabaseShowArgs)

Print information about one or more databases

If no database name is provided, all databases you have access will be shown.

ShowDbPrivs(DatabaseShowPrivsArgs)

Print user privileges for one or more databases

If no database names are provided, all databases you have access to will be shown.

EditDbPrivs(DatabaseEditPrivsArgs)

Change user privileges for one or more databases. See edit-db-privs --help for details.

This command has two modes of operation:

1. Interactive mode: If nothing else is specified, the user will be prompted to edit the privileges using a text editor.

   You can configure your preferred text editor by setting the VISUAL or EDITOR environment variables.

   Follow the instructions inside the editor for more information.

2. Non-interactive mode: If the -p flag is specified, the user can write privileges using arguments.

   The privilege arguments should be formatted as <db>:<user>:<privileges> where the privileges are a string of characters, each representing a single privilege. The character A is an exception - it represents all privileges.

   The character-to-privilege mapping is defined as follows:

   • s - SELECT
   • i - INSERT
   • u - UPDATE
   • d - DELETE
   • c - CREATE
   • D - DROP
   • a - ALTER
   • I - INDEX
   • t - CREATE TEMPORARY TABLES
   • l - LOCK TABLES
   • r - REFERENCES
   • A - ALL PRIVILEGES

If you provide a database name, you can omit it from the privilege string, e.g. edit-db-privs my_db -p my_user:siu is equivalent to edit-db-privs -p my_db:my_user:siu. While it doesn’t make much of a difference for a single edit, it can be useful for editing multiple users on the same database at once.

Example usage of non-interactive mode:

Enable privileges `SELECT`, `INSERT`, and `UPDATE` for user `my_user` on database `my_db`:

  `mysqladm edit-db-privs -p my_db:my_user:siu`

Enable all privileges for user `my_other_user` on database `my_other_db`:

  `mysqladm edit-db-privs -p my_other_db:my_other_user:A`

Set miscellaneous privileges for multiple users on database `my_db`:

  `mysqladm edit-db-privs my_db -p my_user:siu my_other_user:ct``

Trait Implementations

impl Clone for DatabaseCommand

fn clone(&self) -> DatabaseCommand

Returns a copy of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl CommandFactory for DatabaseCommand

fn command<'b>() -> Command

Build a Command that can instantiate Self.

fn command_for_update<'b>() -> Command

Build a Command that can update self.

impl Debug for DatabaseCommand

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl FromArgMatches for DatabaseCommand

fn from_arg_matches(__clap_arg_matches: &ArgMatches) -> Result<Self, Error>

Instantiate Self from ArgMatches, parsing the arguments as needed.

fn from_arg_matches_mut( __clap_arg_matches: &mut ArgMatches, ) -> Result<Self, Error>

Instantiate Self from ArgMatches, parsing the arguments as needed.

fn update_from_arg_matches( &mut self, __clap_arg_matches: &ArgMatches, ) -> Result<(), Error>

Assign values from ArgMatches to self.

fn update_from_arg_matches_mut<'b>( &mut self, __clap_arg_matches: &mut ArgMatches, ) -> Result<(), Error>

Assign values from ArgMatches to self.

impl Parser for DatabaseCommand

fn parse() -> Self

Parse from std::env::args_os(), exit on error.

fn try_parse() -> Result<Self, Error>

Parse from std::env::args_os(), return Err on error.

fn parse_from<I, T>(itr: I) -> Self

where I: IntoIterator<Item = T>, T: Into<OsString> + Clone,

Parse from iterator, exit on error.

fn try_parse_from<I, T>(itr: I) -> Result<Self, Error>

where I: IntoIterator<Item = T>, T: Into<OsString> + Clone,

Parse from iterator, return Err on error.

fn update_from<I, T>(&mut self, itr: I)

where I: IntoIterator<Item = T>, T: Into<OsString> + Clone,

Update from iterator, exit on error.

fn try_update_from<I, T>(&mut self, itr: I) -> Result<(), Error>

where I: IntoIterator<Item = T>, T: Into<OsString> + Clone,

Update from iterator, return Err on error.

impl Subcommand for DatabaseCommand

fn augment_subcommands<'b>(__clap_app: Command) -> Command

Append to Command so it can instantiate Self via FromArgMatches::from_arg_matches_mut

fn augment_subcommands_for_update<'b>(__clap_app: Command) -> Command

Append to Command so it can instantiate self via FromArgMatches::update_from_arg_matches_mut

fn has_subcommand(__clap_name: &str) -> bool

Test whether Self can parse a specific subcommand