MySQL Troubleshooting

See Database Management Systems.

Read below for MySQL errors and solutions.

Error: Unable to Connect to MySQL Host.

If Open Dental has been installed properly, the "Unable to connect to any of the specified MySQL hosts" may appear after clicking OK in the Choose Database window. It's best to contact Open Dental Support, but if unable try the following:

On the Server: If Open Dental is working on the server but not on a workstation, then it could be a firewall issue.

Operating System: Make sure to use a supported operating system.

MySQL Service: MySQL needs to be running to be able to connect.

  1. If the MySQL service is not running, go to Services and try to start it.
  2. If the service won't start, an antivirus program or backup program may be interfering.
    • Temporarily disable the antivirus or backup program to see if this is the issue. After testing, always make sure that some form of antivirus software is reinstalled, either the same one, or a different brand.
  3. Try to reinstall the MySQL service. It may not be installed correctly.

Database Files: Make sure the database files are in the right place with no improper nesting.

Read Only Database: The Choose Database window may state, Database is present but not accepting commands instead of database not present. An Unhandled Exception: Read Only Table or Table [insert name here] is Read Only may also appear.

  1. Go to C:\mysql\data\. Right-click on the opendental folder and select Properties.
  2. Find the box that says Read-only and click on it until it is completely blank.
  3. Click OK.
  4. When given the choice, apply changes to this folder, subfolders, and files.
  5. Run Open Dental.
  6. If unsuccessful, restart the computer.
  7. Retry the above steps as needed.
  8. Contact Open Dental support if issues persist.

As a last resort, try to install Open Dental and MySQL on a different computer.

When using RAID on initial installation or migration: get a MySQL error 1067 or error 87

This problem can occur when the MySQL program files are on a GPT partitioned drive. Add 'innodb_flush_method=normal' to the my.ini file, then start the MySQL service