Trying to Locate Database...
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
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.
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
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).
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