MySQL 8.0 Database Administrator — Question 92

How can mysql_multi be configured to allow MySQL instances to use the same port number?

Answer options

• A. The instances use different user accounts unique to each instance.
• B. The instances listen on different IP addresses.
• C. The instances use different socket names.
• D. The instances have appropriate net masks set.

Correct answer: B

Explanation

The correct answer is B because when MySQL instances are set to listen on different IP addresses, they can effectively share the same port number without conflict. The other options do not address the issue of port conflicts directly; using different user accounts, socket names, or net masks does not allow multiple instances to use the same port simultaneously.