MySQL Troubleshooting

See MySQL.

Unable to Connect to MySQL Host.

You've installed Open Dental according to the directions and when you get to the Choose Database window and click OK, it says, "Unable to connect to any of the specified MySQL hosts". It's best to Contact Us at this point and let us troubleshoot the problem for you over a high-speed internet connection. If you'd rather try it yourself, here are some troubleshooting ideas:

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 you are using 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.
    • Click Start and right-click Computer.
    • Select Manage.
    • Double-click Services and Applications, then double-click Services.
    • Find MySQL in the alphabetical list.
  2. If the service won't start, an antivirus program or backup program may be interfering.
    • Temporarily disable your 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. See Trial Version or contact support.

Proper Installation: Correct installation is crucial to the success of MySQL.

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

Read Only Database: Are your database files set to read only? The Choose Database window may tell you, Database is present but not accepting commands instead of database not present. You may also see Unhandled Exception: Read Only Table or Table [insert name here] is Read Only.

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

When using RAID on initial installation or migration, you 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