Which option is supplied to ensure TCP/IP connection to local server?

Solution (By Examveda Team)

This question is asking about how you connect to a MySQL server using the command line.

When you want to connect to a MySQL server, you need to tell the MySQL client where the server is located.

The options provided are different ways to specify this location:

Option A: -localhost is the correct answer.
This option tells the MySQL client to connect to the server running on the same computer as the client.

Option B: -host is used to connect to a server at a different address. You would follow this with the server's IP address or hostname.
Option C: -hostlocal and Option D: -connectlocal are not standard MySQL options.

Think of it like this:

If you're in your own house (your computer), you would say "I'm at home" to refer to yourself.

In MySQL, "-localhost" is like saying "I'm at home" - it means you want to connect to the MySQL server that's running on the same computer.

So, the right answer is Option A: -localhost.