MySQL :: MySQL 5.7 Reference Manual :: 18.2.2.2 Connecting using Individual Parameters

8.0

MySQL 5.7 Reference Manual / ... / Connecting using Individual Parameters

18.2.2.2 Connecting using Individual Parameters

In addition to specifying connection parameters using a URI, it is also possible to define the connection data using separate parameters for each value.

Use the following parameters:

--dbuser (-u) value
--dbpassword value
--host (-h) value
--port (-P) value
--schema (-D) value
--password (-p)
--socket (-S)

The first 5 parameters match the tokens used in the URI format described at Section 18.2.2.1, “Connecting using a URI String”.

The --password parameter indicates the user should connect without a password.

For consistency, the following aliases are supported for some parameters:

--user is equivalent to --dbuser
--password is equivalent to --dbpassword
--database is equivalent to --schema

When parameters are specified in multiple ways, the following rules apply:

If an argument is specified more than once the value of the last appearance is used.
If both individual connection arguments and --uri are specified, the value of --uri is taken as the base and the values of the individual arguments override the specific component from the base URI.

Attempt to establish an XSession with a specified user at port 33065.

shell> mysqlsh -u user -h localhost -P 33065

Attempt to establish a Classic Session with a specified user.

shell> mysqlsh -u user -h localhost --classic

Attempt to establish a Node Session with a specified user.

shell> mysqlsh --node -u user -h localhost

PREV HOME UP NEXT

User Comments