Solved

wordpress to database

Posted on 2016-07-20
2
68 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 83

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 500 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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Suggested Solutions

CCModeler offers a way to enter basic information like entities, attributes and relationships and export them as yEd or erviz diagram. It also can import existing Access or SQL Server tables with relationships.
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
The purpose of this video is to demonstrate how to prevent comment spam on a WordPress Website. This will be demonstrated using a Windows 8 PC. Plugin Akismet will be used. Go to your WordPress login page. This will look like the following: myw…
The purpose of this video is to demonstrate how to set up the permalinks on a WordPress Website. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php : Go t…

777 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