[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

wordpress to database

Posted on 2016-07-20
2
Medium Priority
?
99 Views
Last Modified: 2016-07-20
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?
0
Comment
Question by:Member_2_7968517
2 Comments
 
LVL 84

Expert Comment

by:Dave Baldwin
ID: 41721688
Access DB?  No, phpMyAdmin is only for MySQL.
2
 
LVL 70

Accepted Solution

by:
Jason C. Levine earned 2000 total points
ID: 41721719
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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article, I’ll look at how you can use a backup to start a secondary instance for MongoDB.
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
The is a quite short video tutorial. In this video, I'm going to show you how to create self-host WordPress blog with free hosting service.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
Suggested Courses
Course of the Month20 days, 4 hours left to enroll

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question