Which command connects to an external MySQL database given host, user, password, and database name?

Which command connects to an external MySQL database given host, user, password, and database name?

• A. mysql -h <db> -p <pass> <name> -u <user>
• B. mysql -h <db> -p <pass> <name>
• C. psql -h <db> -U <user> -W <pass> <name>
• D. mysql -h <db> -u <user> -p <pass> <name>

Answer: (D)

Connecting to a MySQL database from the client requires specifying where to connect, which user to authenticate as, the password, and which database to use. The host is given with -h, the user with -u, the password with -p, and the database name is supplied as the final argument. The command that follows this exact pattern is the clear, conventional way to connect: it sets the host, the user, the password, and then selects the database to use. The other options either point to a different database client (PostgreSQL) or arrange the flags in a nonstandard way, making them unsuitable for connecting to a MySQL database.

Connecting to a MySQL database from the client requires specifying where to connect, which user to authenticate as, the password, and which database to use. The host is given with -h, the user with -u, the password with -p, and the database name is supplied as the final argument. The command that follows this exact pattern is the clear, conventional way to connect: it sets the host, the user, the password, and then selects the database to use. The other options either point to a different database client (PostgreSQL) or arrange the flags in a nonstandard way, making them unsuitable for connecting to a MySQL database.