Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Install PhpMyAdmin on Ubuntu

  1. #1
    Join Date
    Sep 2003
    Posts
    3,040

    Default Install PhpMyAdmin on Ubuntu

    Download and extract PhpMyAdmin

    Code:
    cd ~/www
    wget http://downloads.sourceforge.net/project/phpmyadmin/phpMyAdmin/4.2.11/phpMyAdmin-4.2.11-english.tar.gz
    tar zxvf phpMyAdmin-4.2.11-english.tar.gz
    mv phpMyAdmin-4.2.11-english phpmyadmin
    cd phpmyadmin
    cp config.sample.inc.php config.inc.php
    Create Apache Configuration file.

    Code:
    sudo subl /etc/apache2/sites-available/phpmyadmin.conf
    Add following code and save.

    Code:
    Alias /phpmyadmin "/home/USERNAME/www/phpmyadmin"
    
    <Directory "/home/USERNAME/www/phpmyadmin">
        AllowOverride All
        Require all granted
        Options FollowSymlinks
        Order allow,deny
        Allow from all
    </Directory>
    Now run

    Code:
    sudo a2ensite phpmyadmin
    sudo service apache2 restart
    Become PHP Expert in 30 days
    FreeMarriage.com - Free Online Matrimonial
    FlashWebHost.com - Professional Web Hosting, Designing.

  2. #2
    Join Date
    Sep 2003
    Posts
    3,040

    Default

    Replace USERNAME with your own username.
    Become PHP Expert in 30 days
    FreeMarriage.com - Free Online Matrimonial
    FlashWebHost.com - Professional Web Hosting, Designing.

  3. #3
    Join Date
    Nov 2009
    Posts
    76,596

    Default

    All commands except the last one worked fine for me .The last command gives me followimg message



  4. #4
    Join Date
    Sep 2003
    Posts
    3,040

    Default

    last command, it is just warning. Not an error. So that is fine.

    Now to access phpMyAdmin, go to URL.

    http://localhost/phpmyadmin
    Become PHP Expert in 30 days
    FreeMarriage.com - Free Online Matrimonial
    FlashWebHost.com - Professional Web Hosting, Designing.

  5. #5
    Join Date
    Nov 2009
    Posts
    76,596

    Default

    When I access that url, getting error. Please see the attached screenshot.


  6. #6
    Join Date
    Sep 2003
    Posts
    3,040

    Default

    Install MySQL extension for PHP.

    Code:
    sudo apt-get install php5-mysql
    Restart Apache.
    Become PHP Expert in 30 days
    FreeMarriage.com - Free Online Matrimonial
    FlashWebHost.com - Professional Web Hosting, Designing.

  7. #7
    Join Date
    Nov 2009
    Posts
    76,596

    Default

    I got error message "mysqli extension is missing. Please check your PHP configuration."

    Then installed MySQL extension for PHP using below command:

    Code:
    sudo apt-get install php5-mysql
    After that, edited /etc/php5/apache2/php.ini file and uncommented below line:

    mysqli.allow_local_infile = On

    and restarted apache server. This resolved the error and phpmyadmin started working.



  8. #8
    Join Date
    Sep 2003
    Posts
    3,040

    Default

    Good, now you can login to phpMyAdmin. User name root, password you used doing installation.

    See if login works.
    Become PHP Expert in 30 days
    FreeMarriage.com - Free Online Matrimonial
    FlashWebHost.com - Professional Web Hosting, Designing.

  9. #9
    Join Date
    Nov 2009
    Posts
    76,596

    Default

    Login Success.


  10. #10
    Join Date
    Sep 2003
    Posts
    3,040

    Default

    Looks good.
    Become PHP Expert in 30 days
    FreeMarriage.com - Free Online Matrimonial
    FlashWebHost.com - Professional Web Hosting, Designing.

Page 1 of 2 12 LastLast

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •