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?

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.

_________________
Paid support
How to ask for help
1. Give details of your problem
2. Post any errors
3. Post relevant logs.
4. Don't hide details i.e. your domain, it just makes things harder
5. Be polite or you'll be eaten by a grue

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 <username> -D <database name> -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! =)

_________________
I arise in the morning torn between a desire to improve the world and a desire to enjoy the world. This makes it hard to plan the day.
E. B. White