[Klug-general] Finding facebook signon entries in a wordpress mysql database?

[Dan Attwood]

imho the best gui for mysql is 'mysql workbench'.

very easy to use and very powerful. You probably won't be able to connect
to your server with port 3306 but workbench lets you set up a ssh tunnel.

as for search the database you can just use grep on a dump of the database
if you know roughly what you're looking for.


On 10 April 2014 18:16, Sharon Kimble <boudiccas at talktalk.net> wrote:

> I have two wordpress sites in a multi-site setup, and both serviced with
> the same mysql database, on an off-site server. I want to examine this
> database to find where the Facebook sign-on details are and delete them to
> reset the wordpress Facebook sign-on. This is because one site is directed
> to
> my new Facebook account which is good, but the second site is directed to
> my
> old Facebook account which is closed and is not good.
>
> The second site was originally setup as 'test.tgmeds.org.uk' whilst it was
> being built, and then converted to 'tgmeds.org.uk' when it went live.
> Whilst
> it was still a 'test' site I signed up for Facebook and connected the two
> which then worked okay.
>
> I want to examine a mysql backup database for a Wordpress Jetpack plugin
> specifically looking for where the Facebook signing on and passwords
> entries
> are. I've just tried looking at an old copy of the database which was 39mb
> in
> emacs, but the current one is 86mb and is obviously too big to open it with
> emacs. So I'm also looking for a GUI to help me manoeuvre round the
> database,
> but using 'phpadmin' is not able to be installed.
>
> Once I've been able to find the entry on a database backup, then I will be
> able to deal with it in the live database, or that's my plan anyway. I also
> have a wordpress plugin available to me, 'Custom Field Bulk Editor' which
> will allow me to interact with the database, although I do have direct
> entry
> to the database available to me.
>
> Thanks
> Sharon.
> --
> A taste of linux = http://www.sharons.org.uk
> my git repo = https://bitbucket.org/boudiccas/dots
> TGmeds = http://www.tgmeds.org.uk
> Debian testing, Fluxbox 1.3.5, emacs 24.3.1
>
> _______________________________________________
> Kent mailing list
> Kent at mailman.lug.org.uk
> https://mailman.lug.org.uk/mailman/listinfo/kent
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.lug.org.uk/pipermail/kent/attachments/20140410/4f4f4e4f/attachment.html>