I wasn't sure to put this in Design or here, so you can move it if you want.
phpMyAdmin is a database handler in php. It is simply all the scripts you would normally make manually to view and edit your database. It can even translate from php to sql and sql to php! It is a must-have for anyone who uses mysql.
Now, on to the installation. Your server must be able to use SSH for this to work.
1. You need an SSH client. SSH is almost like DOS, except it is for the internet. I use a simple one called
PuTTy.
2. Open PuTTy and enter your domain name or IP address. If your database is on a separate server, do not enter it here. You can leave the port at 22. Now connect. If this is the first time, a message will come up. Press yes.
3. Enter your SSH username and password. Your password won't show up as you type it (not even *s), but once you are done press enter. You are now connected by SSH.
4. Now that you are connected, you have to put this in (sorry, but no copy and paste):
Code:
wget http://aleron.dl.sourceforge.net/sourceforge/phpmyadmin/phpMyAdmin-2.5.3-php.tar.gz
This will download phpmyadmin in to your home directory.
5. Now you have to 'unzip' phpMyAdmin. Put this in:
Code:
tar xvfz phpMyAdmin-2.5.3-php.tar.gz
6. Now, don't be freaked out by this (I know I was). People always break their knees when they see a lot of code. What you need to do is modify the config to your database's settings. First, put in this:
Code:
cd phpMyAdmin-2.5.3
then
Now the file will open. Press the insert key on your keyboard to modify the file. Look for each of these and change them accordingly:
Code:
$cfg['PmaAbsoluteUri'] = 'http://mysite.com/phpMyAdmin-2.5.3/';
The phpMyAdmin directory.
$cfg['Servers'][$i]['host'] = 'mydatabase.database.net';
Place your database host here (localhost is acceptable)
$cfg['Servers'][$i]['auth_type'] = 'config';
Make sure this option is set to config.
$cfg['Servers'][$i]['user'] = 'username';
Your mySQL username
$cfg['Servers'][$i]['password'] = 'password';
Your mySQL password
$cfg['Servers'][$i]['only_db'] = 'awesomedatabase';
Your database's name
Now press Esc, then type:
7. If you can, now protect the phpMyAdmin with a username and password (if your host has that option).
Now you simply go to the directory in your favorite browser *cough*firefox*cough* and you'll have it all good.
