Port 3306 is required for MySQL and MariaDB.

See Installation.

MariaDB

Inbound rule, port 3306 is automatically opened when installing the MariaDB version of the trial installer.

• It will most likely have a name starting with MariaDB (e.g., MariaDB 10.5 (x64)).
• The network types are private and domain.
  • If using a public network type, reach out to IT to resolve this.
• Only opens 3306 for TCP connections.
• If MariaDB is uninstalled, the rule is deleted.

MySQL

Opening port 3306 must be done manually for MySQL users. Do this on the server only, not on each workstation install. Depending on your installed operating system, these steps may vary. Consult with your IT as needed.

1. In Windows, open the Control Panel.
2. In the Control Panel, click Windows Defender Firewall.
3. In the Windows Defender Firewall window, click Advanced Settings from the sidebar.
4. In the Windows Defender Firewall with Advanced Security window, select Inbound Rules from the sidebar.
5. From the Actions sidebar, click New Rule....
6. In the New Inbound Rule Wizard, set up the new port rule:
   1. Select Rule Type of Port, and click Next.
   2. In the Protocols and Ports step
      1. Select TCP.
      2. Enter 3306 into Specific local ports.
   3. Click Next.
   4. In the Action step, choose Allow the connection, and click Next.
   5. In the Profile step, check Domain and Private, and click Next.
      • This step may vary depending on your network setup. We recommend consulting with your IT for more information.
   6. In the Name step, enter MySQL as Name and Description..
      • If using MySQL for multiple applications, use Open Dental MySQL as the name and description instead to avoid confusion.
   7. Click Finish.

In some cases an outbound rule has to be created for port 3306 if the Network Administrator has blocked outbound traffic from a workstation. Follow the steps above for an outbound rule as well.