Avatar of Patricia Timm
Patricia Timm
 asked on

Accesses the workbench in mysql from a front end application

Working with a mysql backend database. I am not sure what they are using for the frontend. I am using the frontend for my job now. I have to run reports with a command driven front end menu. I would like to utilize the workbench in mysql to run queries to simplify the process. Is there a way for me to get into the workbench? I did not see anything on the menus that would allow me to access the backend? Thanks in advance
DatabasesMySQL ServerPower BI

Avatar of undefined
Last Comment
Patricia Timm

8/22/2022 - Mon
ste5an

Please rephrase your question. Describe what your need to do, especially what " have to run reports with a command driven front end menu" means.

The MySQL Workbench is a management and development tool. It is not designed for being part in a reporting solution.
Normally your reporting software does the connection handling to your (backend) database and the data retrieval.
Ryan Chong

Is there a way for me to get into the workbench? I did not see anything on the menus that would allow me to access the backend?
If you're connected to the db via workbench, then you already can access to the backend (DB), don't you?

and I agreed with ste5an on his explanation.

you would like a Reporting tool, such as Excel, Power BI, Tableau, Qlikview, etc for the reporting and dashboard presenting.
David Favor

What you seem to be describing is CRON.

Where you setup CRON jobs to run at some frequency, say every hour or every day, which run some SQL, then email (or other wise communicate the report) a notification list.

Normally for "backend access" (my guess is you mean the actual MariaDB/MySQL instance), easy way is to run your CRON job on the same machine as your database instance using the mysql command line tool or some scripting language like PERL or PHP.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
Patricia Timm

ASKER
Thanks and you are right. I am using a frontend -- I think they said JAZZ - I never heard of it. I am trying to access the backend from the front end. The front end is the menu driven for reports. I was not sure how to access the backend from the frontend. I know in access I had 2 databases set up one for a front end for my reports and one to hold the data on the backend. Maybe I need security access not sure. I thought maybe there might be an idea on if I can connect from the front end to the backend. I do not have workbench access but know it is a mysql database.
Thanks in advance
ASKER CERTIFIED SOLUTION
slightwv (䄆 Netminder)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Patricia Timm

ASKER
thanks