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.
- Check the Windows firewall to make sure incoming traffic on Port 3306 is allowed, as well as any possible firewall that is part of an antivirus program. You may need to turn the firewall off. See Firewall.
- If you still can't connect from a workstation, then it might be a networking issue such as not being in the same workgroup.
- If you did a non-standard installation and installed MySQL yourself separately, then it might be a security issue such as improper use of MySQL user name and password. See MySQL Security.
Operating System: Make sure you are using a supported operating system.
MySQL Service: MySQL needs to be running to be able to connect.
- 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.
- 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.
- 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.
- Open C:\mysql\data\opendental\. You should see about 200 files.
- If the opendental folder is missing, or if you do not see the expected files, then they have been moved. Move them back. You will have to stop the MySQL service to move files. Be very careful not to lose anything or make a mess. Never delete anything; instead, rename by tacking on "old" or some numbers representing the date. Remember that if you change the name of the opendental folder, it cannot have a special characters in the name.
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.
- Go toC:\mysql\data\. Right-click on the opendental folder and select Properties.
- Find the box that says Read-only and click on it until it is completely blank.
- Click OK.
- When given the choice, apply changes to this folder, subfolders, and files.
- Run Open Dental.
- If unsuccessful, restart your computer.
- You may need to retry the above steps.
- Contact Open Dental support if you still have issues.
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