Monday, January 24, 2011

How to Find Your WordPress Database

I was looking for the WordPress
database today. Looks like it is
in this file here in the topmost
folder for WordPress:

wp-config.php

Once you get into this file, you
can find the following information:

  • name of the database
  • username for the database
  • password for the database
  • host for the database

I'm far from being an expert on
WordPress. However, it seems to
me that the host will either be
a URL or an IP address.

I suspect that once you have the
username and password, you can
log into the database in some
manner or other. However, I
would imagine that access is
limited to logins coming from
certain IP addresses.

Once you are logged in, you can
access the database by name.

This is all speculation on my
part. I've not tried any of this
yet.

Here's where I've written about
connecting to and disconnecting
from a MySQL database:

MySQL --- Getting Started

Since WordPress stores its data
in a MySQL database, it seems
that you could in theory connect
to the database in order to back
it up.

Of course, this is pure theory.
In actual practice, hosting companies
probably have severe restrictions on such
things because they do not want to give
access to databases to the outside world.
That's my conjecture at this point.

Ed Abbott

No comments:

Post a Comment