Home » Networking » How to connect to Shoretel mySQL Configuration Database – Version 8

How to connect to Shoretel mySQL Configuration Database – Version 8

UPDATED!!! Here’s a quick guide for connecting to the Shoretel MySQL database if you are running version 10 or newer.

As of Shoretel version 8, the configuration database has been transitioned from MS Access to MySQL.  Here is how you can access MySQL and create a read-only user that can be used for SELECT queries in the database.

            Shoretel Configuration Database: shoreware
            Default Username: root
            Default Password: <check with your Shoretel partner>

Connect to mySQL

  1. Open a command prompt.
  2. CD to mySQL Path.
  3. Launch mySQL.

<driveletter>:\Program Files\Shoreline Communications\ShoreWare Server\MySQL\MySQL Server 5.0\bin>

                      mysql –user root –password shoreware

Add a read only mySQL user

Enter the following at the mysql> prompt

> grant select on shoreware.* to ‘username’@'%’ identified by ‘password’;

                     eg. > grant select on shoreware.* to ‘testuser’@'%’ identified by ‘n3wpassw0rd’;

 

Enjoy!