Solved

wordpress to database

Posted on 2016-07-20
2
54 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 82

Expert Comment

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

Accepted Solution

by:
Jason C. Levine earned 500 total points
Comment Utility
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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
How can I do this in Pyhton? 12 66
Not needed 13 53
Generating a set of random unique numbers 6 18
jQuery Canlendar click function 5 19
Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
Read about achieving the basic levels of HRIS security in the workplace.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
The viewer will learn how to dynamically set the form action using jQuery.

772 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now