Which port and protocol is commonly used by MySQL databases?

Study for the CPSA Port Numbers Exam. Practice with flashcards and multiple choice questions, each with hints and explanations. Get ready for your test!

Multiple Choice

Which port and protocol is commonly used by MySQL databases?

Explanation:
MySQL databases are accessed over TCP on the default port 3306. This port is the standard listening port configured in most MySQL server setups, and clients connect to it using the MySQL protocol. Other ports serve different services—445 is for SMB file sharing, 3389 is for Remote Desktop Protocol, and 1433 is the default port for Microsoft SQL Server—so they aren’t used for MySQL. While MySQL can be configured to use another port or a Unix socket, 3306 TCP remains the conventional and most common option.

MySQL databases are accessed over TCP on the default port 3306. This port is the standard listening port configured in most MySQL server setups, and clients connect to it using the MySQL protocol. Other ports serve different services—445 is for SMB file sharing, 3389 is for Remote Desktop Protocol, and 1433 is the default port for Microsoft SQL Server—so they aren’t used for MySQL. While MySQL can be configured to use another port or a Unix socket, 3306 TCP remains the conventional and most common option.

Subscribe

Get the latest from Examzify

You can unsubscribe at any time. Read our privacy policy