MySQL 8.0 Database Administrator — Question 138

You have a MySQL client installed on your Linux workstation with a default installation. You have your admin login credentials to connect to a MySQL server running Microsoft Windows on remote host 192.0.2.1:3306. You wish to connect directly to the world database.
Which four options need to be specified to complete this task with a single command? (Choose four.)

Answer options

• A. --shared-memory-base-name=world
• B. --protocol=UDP
• C. --protocol=pipe
• D. --password
• E. --user=admin
• F. --host=192.0.2.1
• G. --socket=/tmp/mysql.sock
• H. --port=3306
• I. --database=world

Correct answer: A, C, D, F

Explanation

The correct options are A, C, D, and F. Option A specifies the shared memory base name, option C indicates the use of the pipe protocol for Windows connections, option D provides the password prompt, and option F defines the host address. The other options either pertain to different connection methods or are not necessary for this specific connection to the world database.