Exam 1z0-908 All QuestionsBrowse all questions from this exam
Question 135

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.)

    Correct Answer: D, E, F, I

    To connect to a MySQL server running on a remote host, you need to specify the following options: the user for authentication (admin), the password for authentication, the host to specify the remote server’s address (192.0.2.1), and the database you want to connect to (world). These are the required options needed for establishing a connection to the MySQL server and accessing the specific database.

Discussion
marklvOptions: ACHI

ACFH is it for windows. Windows has shared memory and pipe.

marklv

sorry, answered other question. DEF and H, user password host and port

marklv

Sorry again, DEFI, user, password, host or ip, and database H is not needed because its the default port.

LrnsTgh

why not C?

marklv

You are connecting from Linux, there is no pipe connection from linux to windows.