Install phpmyadmin, and what is the default username and password

Question

What is the default username and password for PHPMyAdmin? Also, did I install this right if I extracted the zip file from the download, and then plopped the folder onto my PHP compatible web server? Or did I do something wrong?

Answer 1

Let's consider the default user and documentroot of apache: /var/www/htdocs user apache

What steps do i need to install phpmyadmin ?

1. Download the source file
2. Untar or Unzip the file tar -zxvf phpMyAdmin-3.3.7-english.tar.gz
3. To simplify changed the ugly directory name to phpmyadmin mv phpMyAdmin-3.3.7-english phpmyadmin
4. Change the owner recursively to all files within it chown -R apache.apache phpmyadmin
5. Move the folder to our DocumentRoot directory mv phpmyadmin /var/www/htdocs/

Congratulation you have completed the first stage!

---

What steps do i need to configure the installed phpmyadmin ?

1. Enter the phpmyadmin directory cd /var/www/htdocs/phpmyadmin
2. Rename the configuration file mv config.sample.inc.php config.inc.php
3. Open the configuration file on your preferable editor vi config.inc.php
4. Edit the line $cfg['blowfish_secret'] = ''; with some random password or w/e you want
5. Now you can login with your MySQL user or with your root MySQL user.

Congratulation you have completed the last stage!

---

BONUS STAGE: To create a database within your MySQL server:

mysql -uroot -p
create database DATABASE_NAME_HERE;
grant all privileges on DATABASE_NAME_HERE.* to 'USERNAME_YOU_WANT_TO_USE_HERE'@'%' identified by 'PASSWORD_FOR_THIS_USERNAME_HERE';
FLUSH PRIVILEGES;

Congratulation you have cleared it all!