Solved

wordpress to database

Posted on 2016-07-20
2
83 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

[Webinar] Code, Load, and Grow

Managing multiple websites, servers, applications, and security on a daily basis? Join us for a webinar on May 25th to learn how to simplify administration and management of virtual hosts for IT admins, create a secure environment, and deploy code more effectively and frequently.

Question has a verified solution.

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

Since pre-biblical times, humans have sought ways to keep secrets, and share the secrets selectively.  This article explores the ways PHP can be used to hide and encrypt information.
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
The purpose of this video is to demonstrate how to Test the speed of a WordPress Website. Site Speed is an important metric of a site’s health. Slow site speed can result in viewers leaving your site quickly and not seeing your content. This…
The purpose of this video is to demonstrate how to integrate Mailchimp with WordPress, by placing a Mailchimp signup form on a WordPress Page or Post. This will be demonstrated using a Windows 8 PC. Mailchimp will be used. Log into your Mailchi…

738 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