Dump Data base into Excel

Nov 05, 2013 10:20 PM PST
Scott Feda
Hubbard Hall
Hello,

Is it possible to dump our MySQL database into excel so I can filter data?
I tried to connect to the database through ODBC and MYSQL connector from my local workstation but they always fail. Is it possible to use tools installed on the Shoretel server to accomplish this?

Thank you

Scott
Jan 09, 2014 01:50 AM PST
Damian Galindo
Global CTI Group
If you want to access the MySQL database from another computer, you will first need to add a user to the MySQL instance that has permission to connect remotely. To setup this user either download the MySQL workbench or use the CLI. Then you will be able to authenticate from a remote computer and have access to the database.

To reply to this post please Sign In