Pages

Wednesday, November 21, 2012

Installing phpmyadmin in ubuntu

  1. Open your terminal and type the command:
    sudo apt-get install phpmyadmin
  2. It will ask for your password, type your ubuntu password and press enter key, it will ask for confirmation. Type
    y
    and press enter key
  3. During the installation you will be prompted for a web server configuration. Select
    Apache
    and press Enter
  4. Now you will be prompted for phpmyadmin configuration, select
    no
  5. In terminal run the command:
    sudo cp /etc/phpmyadmin/apache.conf /etc/apache2/conf.d
  6. Restart your apache server:
    sudo /etc/init.d/apache2 restart
  7. Open your browser and type
    http://localhost/phpmyadmin/
  8. Enter root for username and leave password field empty and click on Go
  9. You will get the following error:
    Login without a password is forbidden by configuration (see AllowNoPassword)
    when trying to login to your passwordless account; 
  10. To enable AllowNoPassword, uncomment or add the following line in /etc/phpmyadmin/config.inc.php :
    $cfg['Servers'][$i]['AllowNoPassword'] = TRUE;
  11. To make this file editable in ubuntu, type in the terminal:
    cd /etc/phpmyadmin
    then press enter
  12. Then type
    gksu nautilus
  13. Make necessary changes and save the file. Now type
    http://localhost/phpmyadmin/
    in the browser and enter only the username as root and click on Go.

No comments: