2 Replies Latest reply on May 2, 2012 2:47 PM by cshanep

    Accessing the MYSQL database remotely for reporting and analytic functionality

    bpocooks

      I am trying to connect to the MYSQL DB remotely in STM v5. Used to be able to connect to it when it was Profiler v 4.x but with an upgrade by some staff I am having to setup the access again. I can create a user in the MYSQL DB but the "root" user does not have Grant privleges so I cannot add Select privileges to my user. If I query the privileges granted it gives *.* for the "root" user but looking at a query of the mysql.users table shows N for Grant privilege.

      Any help would be appreciated in getting this going again, otherwise would need an API to pull that data.

      Thanks

      BrianO