Opens a MySQL console using credentials from wp-config.php
- Use a specific database. Defaults to DB_NAME.
- Use a specific character set. Defaults to DB_CHARSET when defined.
- Username to pass to mysql. Defaults to DB_USER.
- Password to pass to mysql. Defaults to DB_PASSWORD.
- Extra arguments to pass to mysql. Refer to mysql docs.
- Loads the environment’s MySQL option files. Default behavior is to skip loading them to avoid failures due to misconfiguration.
# Open MySQL console $ wp db cli mysql>
GLOBAL PARAMETERS GLOBAL PARAMETERS
These global parameters have the same behavior across all commands and affect how WP-CLI interacts with WordPress.
||Path to the WordPress files.|
||Pretend request came from given URL. In multisite, this argument is how the target site is specified.|
||Perform operation against a remote server over SSH (or a container using scheme of “docker”, “docker-compose”, “vagrant”).|
||Perform operation against a remote WordPress installation over HTTP.|
||Set the WordPress user.|
||Skip loading all plugins, or a comma-separated list of plugins. Note: mu-plugins are still loaded.|
||Skip loading all themes, or a comma-separated list of themes.|
||Skip loading all installed packages.|
||Load PHP file before running the command (may be used more than once).|
||Execute PHP code before running the command (may be used more than once).|
||Whether to colorize the output.|
||Show all PHP errors and add verbosity to WP-CLI output. Built-in groups include: bootstrap, commandfactory, and help.|
||Prompt the user to enter values for all command arguments, or a subset specified as comma-separated values.|
||Suppress informational messages.|
Command documentation is regenerated at every release. To add or update an example, please submit a pull request against the corresponding part of the codebase.