Home User Manual Discussion Forum Search

Choose Database  

The settings on the Choose Database window allow your workstation to locate and connect to the MySQL database. If you install Open Dental on multiple computers, this window shows the first time you run Open Dental on each workstation. It can also be accessed at any time via the Main Menu, File, Choose Database.



  • Server: The name of the computer where the MySQL server and database are located. If running on a single computer only, the computer name may be 'localhost'.
  • DataBase: The database to connect to. Usually this is 'opendental'.
  • User: Default user is 'root'. See MySQL Security to set users and passwords. 
  • Password: The user password (if you have set MySQL users and passwords).
  • Do not show this window on startup (this computer only): Check this box to hide this window on subsequent startups of Open Dental on this workstation.

Information is saved when the window is closed, then used the next time Open Dental starts up.

Connect to Middle Tier instead: See Middle Tier. Instead of connecting directly to the database, you have the option to connect to a Middle Tier which handles all of the database interactions. The advantages include better security and speed for multiple offices. Using the middle tier makes it impossible for the user to connect directly to the database. The user will never have access to the MySQL username and password used to access the database. It also prevents injection attacks when writing queries.

For Advanced Users
The settings on this window are stored in the FreeDentalConfig.xml file in the installation directory. This data is not stored in the database because you have not yet established a database connection.

Multiple Databases: Most users will have only one database. However, in Open Dental you have the option of running many databases on the same computer. For example, you could make Backups of your database within its original folder. To access historical snapshots of the data, simple access each database. You can also switch between your regular database and a backup that you take home on your laptop for read-only purposes. If you run a dental billing company, each doctor client can retain a separate database (each office must also have a separate Open Dental license).

To switch between databases, use the Database dropdown on the Choose Database window.

Troubleshooting
Problem: Connection to the MySQL server has been lost.

Solution: This message pops up when the workstation cannot connect to the MySQL server. Open Dental will attempt to reconnect until connection is successful or the user aborts (Exit Program).

 

Open Dental Software 1-503-363-5432