How to connect to Shoretel mySQL Configuration Database – Version 8
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
- Open a command prompt.
- CD to mySQL Path.
- 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’;