Connecting to database via MySQL, no tables listed. trying to fix issue outlined in JRASERVER-40009

[joe_dinunzio]

Greetings, 

I inherited an already set up JIRA application that is currently running fine except for an issue editing workflows. I am experiencing the problems outlined in JRASERVER-40009. As you can probably tell this instance is very outdated and I am unable to upgrade so this issue must be fixed. 

The fix for this issue involves running various SQL statements in the database to isolate and remove duplicate workflows; but I am unable to access the database. 

We are using a MySQL database (14.4) for Linux. When I connect to the database via the command line and run 'show databases;' it does not list the jira databases. When I look in /var/lib/mysql I can see all the databases there. Since the application is working correctly this must be some kind of user error. our database is housed on a different instance than the primary jira application (both linux VM's). 

When I try to log into MySQL using the same username/password found in the dbconfig.xml config file it shows access denied, that user is not defined on the database machine. 

How can I log in and query the database to fix the known issues outlined in JRASERVER-40009? 

Thanks.