9:12 - Monday, 21 April 2014

Install Phpmyadmin, And What Is The Default Username And Password

#Topics: phpmyadmin default username password,phpmyadmin default username,phpmyadmin default username and password,whats the default username for phpmyadmin,what is the default phpmyadmin username

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?

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 -pcreate 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!