MySQL

See Advanced Topics.

The Open Dental database is MySQL which is a very robust and reliable database with extensive features and millions of installations worldwide.

MySQL versions:

General Overview

How to Determine if MySQL is Installed

MySQL should be installed on the server. There are two ways to ensure MySQL is installed:

  1. On the server, go to Services. See if the MySQL service is listed.
  2. On the server, go to Add or Remove programs. See if an existing installation of MySQL is listed.

How to Determine if MySQL is Running

The MySQL server will run as a service on one computer. To easily determine if MySQL is running, use the management console.

  1. Right click on My Computer and select Manage.
  2. Open Services and Applications
  3. Open Services. These are all the programs (services) that are running in the background without a user interface. MySQL would show as started.

How to Start/Stop the MySQL Service from Windows CMD

  1. Open CMD.
    • CMD may need to be run as administrator depending on Windows permissions settings. Right click the CMD icon, select Run as Administrator.
  2. To start the MySQL service, type net start mysql.
  3. To stop the MySQL service, type net stop mysql.

To access the data in your MySQL database, use the table viewer in User Query.