wordpress to database

Can phpMyAdmin, running in the background in WordPress, be configured to the point that it functions as an API portal to an external Access DB?
Member_2_7968517Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dave BaldwinFixer of ProblemsCommented:
Access DB?  No, phpMyAdmin is only for MySQL.
2
Jason C. LevineNo oneCommented:
phpMyAdmin is simply a tool to look at MySQL databases.  It doesn't run in the background, period.

MySQL is "running in the background" even though that's not an accurate technical description of how MySQL runs, it's good enough for discussion.

So Dave's right about your original question.  However, depending on your ISP and how they configure MySQL security, it may be possible for you to integrate the MySQL tables into your Access file using MyODBC as the conduit.

https://dev.mysql.com/downloads/connector/odbc/

The ISP has to allow remote connections to the MySQL database in order for this to work, so check with them to see if it is possible.  If it is, you simply create a linked table in Access using the ODBC option and create a data source using MyODBC to the MySQL instance and *boom* live access to your MySQL data via Access.
1

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.