Editing WordPress Database

dBase, Calc, CSV, MS ACCESS, MySQL, PostgrSQL, OTHER

Editing WordPress Database

Postby themobilehomeless » Thu Oct 06, 2016 12:21 am

Hi everyone. I have a website that runs on the WordPress platform and I make a lot of edits to the database daily. I despise suing PHPmyadmin, which is what my cPanel offers, and I'd much rather edit it locally. It's obviously a simple MySQL database, so exporting it and editing it in Base is fairly straightforward. However, is there a way to make a direct connection to my database through Base so I can just open it up and edit my database in real time without having to manually download/upload a SQL dump file? If it helps, this is my website: http://weddingdaysparklers.com/

I don't care if I need to change file permissions or server settings; even spending a few hours getting it configured will pay off after a few days. Any ideas or recommendations will be greatly appreciated. Thanks everyone!
Open Office Version 3.1
Windows 7 Professional
themobilehomeless
 
Posts: 1
Joined: Thu Oct 06, 2016 12:15 am

Re: Editing WordPress Database

Postby robleyd » Thu Oct 06, 2016 1:20 am

First thing you need to find out from your web host is whether they allow remote connections to mysql

If so, see the Help for Base and look at databases|connecting for the various possibilities available.
Cheers
David
Apache OpenOffice 4.2.0 Build 9820 alpha version - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 2515
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia


Return to External Data Sources

Who is online

Users browsing this forum: No registered users and 3 guests