Warning: These steps revert MySQL to the default settings and remove any custom users, passwords, ports, or other security settings. If MySQL installation has been customized, we recommend calling Open Dental for assistance updating MySQL.
If the practice is running a newer version of Open Dental that has issues with older versions of MySQL, "Error 17" may appear few times per day, requiring restarting the MySQL service each time. Since the errors are coming from MySQL rather than Open Dental, the only way to get the bug fix is to upgrade MySQL.
It is required to at least be using MySQL 5.0 before upgrading to 5.5. If on an earlier version of MySQL, such as 4.1, then follow the instructions at MySQL 5.0 as an intermediate step.
After upgrading to MySQL 5.5, harmless errors may start to show up in the event logs that look like "performance_schema...has the wrong structure". Performance schema is not used by Open Dental so these errors can be ignored. The mysql_upgrade.exe tool can be run manually in a command prompt to stop the errors from showing up in the logs. That tool can be found in the bin folder of the MySQL install directory.