Trying to Locate Database...

Hello all,

I'm a lowly graphic designer who's taken over a Linode-hosted website for a client. The site in question is built with Wordpress and I need to access its database directly.

I am totally out of my league here and can't even find where the database is located. I'm familiar with phpmyadmin but it looks like I'll have to install it somehow (and LAMP too, I think?). Is this where I use StackScripts?

Also I'm nervous to install anything in case it disrupts the current site. Can someone walk me through?

4 Replies

My advise is download mysql workbench http://wb.mysql.com/ and use that, you install it on your client machine and can connect to the database on the linode using SSH.

If you have a running Wordpress install, then you already have LAMP installed.

Use google and find out what the command is to list all the installed app's on whatever distro you're using.

Something like

$ rpm -qa

or

$ dpkg –get-selections

That way you'll know what's already installed.

In the root directory of the Wordpress blog you should be able to find a file named "wp-config.php".

Inside that file you should be able to find the database connection info. For example:

define('DB_NAME', 'wordpress');

define('DB_USER', 'foo');

define('DB_PASSWORD', 'abc123');

Once you have the DB info you can access the database from the command line using:

mysql -u -D -p

Depending on your familiarity with SQL and what you need to do, this may be sufficient to backup/dump the DB or get/change the info you need.

If you would prefer a GUI, you can use mysql workbench as suggested by obs or install phpmyadmin (if not already installed).

My apologies for posting on here so late, but I wanted to thank you graciously for all of your helpful instructions! I, too, have been having many difficulties accessing our own blog databases. As you can tell, I'm not very tech savvy. . . . at all. =P

I'll be sure to look this over when I get home from work (I work late night shifts) and maybe I can figure this out on my own. It's really important because it just so happens to be our company blog. We've been thinking of going with business blogging software, but we're still not entirely sure. I'm not particularly familiar with coding, so please forgive me. I've only used simple wordpress blogs in the past. Thanks, folks! =)

Reply

Please enter an answer
Tips:

You can mention users to notify them: @username

You can use Markdown to format your question. For more examples see the Markdown Cheatsheet.

> I’m a blockquote.

I’m a blockquote.

[I'm a link] (https://www.google.com)

I'm a link

**I am bold** I am bold

*I am italicized* I am italicized

Community Code of Conduct