Page 1 of 1

Editing WordPress Database

Posted: Thu Oct 06, 2016 12:21 am
by themobilehomeless
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!

Re: Editing WordPress Database

Posted: Thu Oct 06, 2016 1:20 am
by robleyd
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.