Troubleshooting MySQL Service Won't Start

When you attempt to open Open Dental on your server or any workstation, you receive an error message stating "Unable to connect to any of the specified MySQL hosts." When you check the Windows Services on your server, you see that the MySQL (or MariaDB) service is listed as "Stopped" or "Paused," and clicking "Start" results in an error message saying the service started and then stopped, or it simply fails to start altogether.

Quick Fix

If your MySQL service suddenly stops, it is often due to a temporary conflict with security software.

1. Disable Antivirus/Backup Software: Temporarily disable your antivirus or automated backup software on the server.
2. Restart the Service: Open the Windows Services console (press Windows Key + R, type services.msc, and press Enter). Locate the MySQL or MariaDB service, right-click it, and select Start.
3. Re-enable Security: If the service starts successfully, you know your security software is interfering. You will need to add an exclusion for the MySQL data folder (typically C:\mysql\data\) in your antivirus settings to prevent this from happening again.

Step-by-Step Troubleshooting

If the quick fix above does not work, follow these steps in order to identify the root cause.

1. Check for "Read-Only" Database Files:
   Sometimes Windows updates or file permission changes mark your database folder as "Read-Only," which prevents the service from starting.

   • Navigate to C:\mysql\data\ (or your specific data path).
   • Right-click the opendental folder and select Properties.
   • Look at the "Attributes" section. If the "Read-only" box is checked or filled, click it until it is completely blank.
   • Click Apply, select "Apply changes to this folder, subfolders, and files," and click OK. Try starting the service again.

2. Verify Database File Integrity:
   If the database files were moved or corrupted, the service will fail to start.

   • Open C:\mysql\data\opendental\.
   • You should see approximately 1,200 files. If this folder is missing or empty, the database files have likely been moved or deleted.
   • If you find the files in a different location, move them back to C:\mysql\data\opendental\ and try starting the service.

3. Check for Port Conflicts:
   Open Dental requires Port 3306 to communicate. If another program is using this port, MySQL cannot start.

   • Open the Command Prompt as an Administrator.
   • Type netstat -ano | findstr :3306 and press Enter.
   • If you see a result, another program is using the port. You will need to identify that program and stop it, or change the port configuration in your my.ini file.

4. Review the my.ini Configuration:
   If you recently made changes to your server or updated your software, the configuration file might be incorrect.

   • Locate your my.ini file (usually in C:\Program Files\MySQL\MySQL Server 5.5\my.ini or the MariaDB equivalent).
   • Ensure the datadir path matches the actual location of your data folder.
   • If you are using a RAID setup or a specific drive configuration, ensure the innodb_flush_method is set to normal if you are experiencing "Error 1067."

Why This Happens

The MySQL service is the "engine" that allows Open Dental to read and write your patient data. When the service won't start, it usually means the software is encountering a "roadblock"—either a security program is blocking access to the files, the files themselves are locked (Read-Only), or the configuration file (my.ini) is pointing to a location that doesn't exist.

How to Prevent This

1. Set Antivirus Exclusions: Always add an exclusion for your entire MySQL data folder (C:\mysql\data\) in your antivirus software. This is the #1 cause of service crashes.
2. Keep Software Updated: Use the Help > Update menu in Open Dental to ensure you are on the latest stable version. Updates often include fixes for database stability.
3. Regular Backups: Ensure your backups are running successfully. If a database file becomes corrupted, a recent backup is your only path to recovery.

When to Contact Open Dental Support

If you have tried the steps above and the service still refuses to start, or if you receive a specific "Error 1067" or "Error 87" that persists after checking the my.ini file, stop immediately. Do not attempt to delete or move database files, as this can lead to permanent data loss. Contact the official support team at 503-363-5432. They have specialized tools to repair database corruption that are not available to the public.

Need better visibility into your Open Dental data? DentalCanvas gives you a visual dashboard — no SQL required.

This article is provided by opendentalsupport.com, an independent community resource. We are not affiliated with Open Dental Software, Inc.