Install phpMyAdmin 3.5.7 on Fedora 18/17, CentOS/RHEL 6.3/5.9

Updated by on Mar 2, 2013 in CentOS, Featured, Fedora, Linux, Most Popular, Programs, Red Hat (RHEL), Servers, SQL | 92 comments

This is guide, howto install phpMyAdmin 3.5.7 with Nginx or Apache on Fedora 18/17/16/15/14, CentOS 6.3/6.2/6.1/6/5.9 and Red Hat (RHEL) 6.3/6.2/6.1/6/5.9 servers. phpMyAdmin needs web server with PHP and MySQL database. This guide uses Apache web server with PHP 5.4 or Nginx web server with PHP 5.4 (PHP-FPM) and Mysql 5.5 database server. You can also use your already installed versions of web server, PHP and MySQL.

If you want to install phpMyAdmin with Apache then use a – [Apache] sections and if you want install phpMyAdmin with Nginx then use b – [Nginx] sections.

1. Install Needed Web and Database Servers

[Apache]

1.1a Install the whole LAMP environment with following guide

LAMP (Linux/Apache/MySQL/PHP) on Fedora, CentOS/Red Hat (RHEL)

[Nginx]

1.1b Install the whole LEMP environment with following guide

LEMP (Linux/Nginx/MySQL/PHP) on Fedora, CentOS/Red Hat (RHEL)

OR

[Apache]

1.2a Install just MySQL and Apache with PHP using following guides

  1. Install MySQL 5.5 on Fedora, CentOS, Red Hat (RHEL)
  2. Install Apache (httpd) and PHP 5.4 on Fedora, CentOS, Red Hat (RHEL)

[Nginx]

1.2b Install just MySQL and Nginx with PHP (PHP-FPM) using following guides

  1. Install MySQL 5.5 on Fedora, CentOS, Red Hat (RHEL)
  2. Install Nginx and PHP 5.4 (PHP-FPM) on Fedora, CentOS, Red Hat (RHEL)

2. Install phpMyAdmin 3.5.7 on Fedora 18/17/16/15/14, CentOS/Red Hat (RHEL) 6.3/6.2/6.1/6/5.9

2.1 Change root user

su -
## OR ##
sudo -i

2.2 Install Remi repository

Fedora

## Remi Dependency on Fedora
rpm -Uvh http://download1.rpmfusion.org/free/fedora/rpmfusion-free-release-stable.noarch.rpm 
rpm -Uvh http://download1.rpmfusion.org/nonfree/fedora/rpmfusion-nonfree-release-stable.noarch.rpm
 
## Fedora 18 ##
rpm -Uvh http://rpms.famillecollet.com/remi-release-18.rpm
 
## Fedora 17 ##
rpm -Uvh http://rpms.famillecollet.com/remi-release-17.rpm
 
## Fedora 16 ##
rpm -Uvh http://rpms.famillecollet.com/remi-release-16.rpm
 
## Fedora 15 ##
rpm -Uvh http://rpms.famillecollet.com/remi-release-15.rpm
 
## Fedora 14 ##
rpm -Uvh http://rpms.famillecollet.com/remi-release-14.rpm
 
## Fedora 13 ##
rpm -Uvh http://rpms.famillecollet.com/remi-release-13.rpm

CentOS and Red Hat (RHEL)

## Remi Dependency on CentOS 6 and Red Hat (RHEL) 6 ##
rpm -Uvh http://download.fedoraproject.org/pub/epel/6/i386/epel-release-6-8.noarch.rpm
 
## CentOS 6 and Red Hat (RHEL) 6 ##
rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm
 
 
## Remi Dependency on CentOS 5 and Red Hat (RHEL) 5 ##
rpm -Uvh http://dl.fedoraproject.org/pub/epel/5/i386/epel-release-5-4.noarch.rpm
 
## CentOS 5 and Red Hat (RHEL) 5 ## 
rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-5.rpm

Note: You can also use original Fedora phpMyAdmin builds or EPEL packages.

2.3 Install phpMyAdmin

yum --enablerepo=remi install phpmyadmin

If you have PHP 5.4 on CentOS/Red Hat (RHEL) then install phpMyAdmin with following command:

yum --enablerepo=remi,remi-test install phpmyadmin

3. Setup phpMyAdmin with Apache or Nginx

[Apache]

3.1a Check phpMyAdmin Apache Virtual Host

When you install phpMyAdmin you got working Apache Virtual Host automatically, but if you want change it, then check /etc/httpd/conf.d/phpMyAdmin.conf file and modify it.

[Nginx]

3.1b Create phpMyAdmin Nginx Virtual Host and Other Setups

Create /etc/nginx/sites-available/phpMyAdmin file with following content:

server {
       listen   80;
       server_name pma;
       access_log /var/log/nginx/phpmyadmin/access.log;
       error_log /var/log/nginx/phpmyadmin/error.log;
       root /usr/share/phpMyAdmin;
 
       location / {
           index  index.php;
       }
 
       ## Images and static content is treated different
       location ~* ^.+.(jpg|jpeg|gif|css|png|js|ico|xml)$ {
           access_log        off;
           expires           360d;
       }
 
       location ~ /\.ht {
           deny  all;
       }
 
       location ~ /(libraries|setup/frames|setup/libs) {
           deny all;
           return 404;
       }
 
       location ~ \.php$ {
           include /etc/nginx/fastcgi_params;
           fastcgi_pass 127.0.0.1:9000;
           fastcgi_index index.php;
           fastcgi_param SCRIPT_FILENAME /usr/share/phpMyAdmin$fastcgi_script_name;
       }
}

This is Nginx phpMyAdmin virtual host configuration which works pretty much like original phpMyAdmin Apache configuration. I use here server_name pma you could freely change this real host name or some other.

Set pma pointing to localhost, add following to /etc/hosts file:

127.0.0.1  pma

Create needed directory and enable Nginx virtual host:

mkdir -p /var/log/nginx/phpmyadmin
 
cd /etc/nginx/sites-enabled
ln -s /etc/nginx/sites-available/phpMyAdmin

[Apache]

3.2a Restart Apache Web Server

/etc/init.d/httpd restart

[Nginx]

3.2b Restart Nginx Web Server

/etc/init.d/nginx restart

4. Use phpMyAdmin

[Apache]

4.1a Open phpMyAdmin with Apache Setup

Open browser and Goto following address http://localhost/phpmyadmin.

[Nginx]

4.1b Open phpMyAdmin with Nginx Setup

Open browser and Goto following address http://pma/.

4.2 phpMyAdmin Login Screen

Login with your MySQL username and password.

[Apache]

4.3a phpMyAdmin 3.4.10 Running on CentOS 6.2 with Apache

[Nginx]

4.3b phpMyAdmin 3.4.10 Running on CentOS 6.2 with Nginx

Follow If Not True Then False Updates!

92 Comments

  1. Alireza / February 28, 2012

    I did all the instructions completely..even edited php.ini file in (/etc/php.ini)..but I see frequently html error 500

    Reply
    • JR / February 28, 2012

      Hi Alireza,

      Do you use Nginx or Apache?
      Do you get error 500 all the time or does phpMyAdmin work occasionally?

      Reply
  2. Kevin Cheathem / March 21, 2012

    Hey JR,

    I received a 403 error when attempting to connect to phpmyadmin.

    Reply
    • JR / March 22, 2012

      Hi Kevin and nice to see you here,

      Could you please tell more about your setup:
      - OS
      - Web server
      - Configs what you have
      - Do you try to use it locally or remote

      Reply
  3. Kevin Cheathem / March 22, 2012

    Hey JR,

    I have CentOS 6.2 with Apache and MySql. I use Webmin as my control panel. I set up everything according to you tutorials for WordPress. MySql is working fine, I just know that phpMyAdmin simplifies the process so I wanted to add it. I usually do everything through Webmin, using SSH when I have to. Also, there are other sites on the server running on different IP.

    Reply
    • JR / March 23, 2012

      Hi again Kevin,

      Thank you for this information.

      Open /etc/httpd/conf.d/phpMyAdmin.conf file and check following:

      <Directory /usr/share/phpMyAdmin/>
   order deny,allow
   deny from all
   allow from 127.0.0.1
   allow from ::1
</Directory>

      Add your external ips here.

      OR

      change it to:

      <Directory /usr/share/phpMyAdmin/>
   order deny,allow
   allow from all
</Directory>

      Then restart your web server and try again.

      Please let me know do you get it working?

      Reply
      • pouya / September 18, 2012

        after that service httpd restart

        Reply
  4. Kevin Cheathem / March 23, 2012

    Hey JR,

    Thanks a lot! That worked like a charm.

    Reply
    • JR / March 23, 2012

      You are very welcome! Nice to hear that it worked. :)

      Reply
  5. woody / March 28, 2012

    Hi, JR..
    The phpmyadmin in nginx..
    Can I set it to http://localhost/phpmyadmin rather than http://pma/ ?

    Please advice. :)

    Reply
    • JR / March 30, 2012

      Hi woody,

      You can try following config on your /etc/nginx/conf.d/default.conf:

      location /phpMyAdmin {
  root /usr/share/;
  index index.php index.html index.htm;
  location ~ ^/phpMyAdmin/(.+\.php)$ {
    try_files $uri =404;
    root /usr/share/;
    fastcgi_pass 127.0.0.1:9000;
    fastcgi_index index.php;
    fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
    include /etc/nginx/fastcgi_params;
  }
  location ~* ^/phpMyAdmin/(.+\.(jpg|jpeg|gif|css|png|js|ico|html|xml|txt))$ {
    root /usr/share/;
  }
}
 
location /phpmyadmin {
  rewrite ^/* /phpMyAdmin last;
}

      Restart nginx and then http://localhost/phpmyadmin should work… :)

      Reply
  6. marker / June 5, 2012

    Hi ,

    I have just installed CentOS 5.8 Final release.
    Completely new to linux i am trying to install a LAMP , Encounter this error

    Can someone tell me what is this and how to solve it ? thanks…

    [root@localhost /]# rpm -Uvh http://dl.fedoraproject.org/pub/epel/5/i386/epel-release-5-4.noarch.rpm
    Retrieving http://dl.fedoraproject.org/pub/epel/5/i386/epel-release-5-4.noarch.rpm
    error: skipping http://dl.fedoraproject.org/pub/epel/5/i386/epel-release-5-4.noarch.rpm – transfer failed – Unknown or unexpected error
    [root@localhost /]#

    Reply
    • JR / June 6, 2012

      Hi marker,

      Do you have network connection working normally? Could you just try again?

      Reply
  7. indapublic / July 28, 2012

    Hello. Thanks for you articles, it’s very usefull for me.

    But I have trouble with phpmyadmin. After install on this manual i have phpMyAdmin – 2.11.11.3. What’s wrong, I don’t know

    Reply
  8. indapublic / July 28, 2012

    yum –enablerepo=remi install phpmyadmin
    =============
    –> Running transaction check
    —> Package phpmyadmin.noarch 0:2.11.11.3-2.el6.rf will be installed
    –> Finished Dependency Resolution

    Reply
    • indapublic / July 28, 2012

      I found reason: other repository. I fixed it and trying

      yum --enablerepo=remi install phpmyadmin

      and receive:

      Error: Package: php-mcrypt-5.3.15-1.el6.remi.x86_64 (remi)
      Requires: php-common(x86-64) = 5.3.15-1.el6.remi
      Installed: php-common-5.4.5-1.el6.remi.x86_64 (@remi-test)
      php-common(x86-64) = 5.4.5-1.el6.remi
      Available: php-common-5.3.3-3.el6_2.8.x86_64 (base)
      php-common(x86-64) = 5.3.3-3.el6_2.8
      Available: php-common-5.3.3-14.el6_3.x86_64 (updates)
      php-common(x86-64) = 5.3.3-14.el6_3
      Available: php-common-5.3.14-1.el6.remi.x86_64 (remi)
      php-common(x86-64) = 5.3.14-1.el6.remi
      Available: php-common-5.3.15-1.el6.remi.x86_64 (remi)
      php-common(x86-64) = 5.3.15-1.el6.remi
      You could try using --skip-broken to work around the problem
      You could try running: rpm -Va --nofiles --nodigest

      Reply
      • JR / July 29, 2012

        Hi indapublic,

        Could you post output of following commands:

        yum list \*php\*
 
yum --enablerepo=remi repolist
        Reply
        • indapublic / July 30, 2012

          Thanks for reply.

          [indapublic@myserver ~]$ yum list \*php\*
          Loaded plugins: fastestmirror
          Determining fastest mirrors
          epel/metalink | 13 kB 00:00
          * Webmin: download.webmin.com
          * base: mirror.yandex.ru
          * epel: mirror.yandex.ru
          * extras: mirror.yandex.ru
          * updates: mirror.yandex.ru
          Webmin | 951 B 00:00
          Webmin/primary | 15 kB 00:00
          Webmin 118/118
          base | 3.7 kB 00:00
          base/primary_db | 4.5 MB 00:01
          epel | 4.0 kB 00:00
          epel/primary_db | 4.6 MB 00:02
          extras | 3.0 kB 00:00
          extras/primary_db | 6.3 kB 00:00
          updates | 3.5 kB 00:00
          updates/primary_db | 1.2 MB 00:00
          Installed Packages
          php.x86_64 5.4.5-1.el6.remi @remi-test
          php-cli.x86_64 5.4.5-1.el6.remi @remi-test
          php-common.x86_64 5.4.5-1.el6.remi @remi-test
          php-gd.x86_64 5.4.5-1.el6.remi @remi-test
          php-mbstring.x86_64 5.4.5-1.el6.remi @remi-test
          php-mysql.x86_64 5.4.5-1.el6.remi @remi-test
          php-pdo.x86_64 5.4.5-1.el6.remi @remi-test
          php-xml.x86_64 5.4.5-1.el6.remi @remi-test
          Available Packages
          cups-php.x86_64 1:1.4.2-48.el6 base
          eclipse-phpeclipse.noarch 1.2.1-6.el6 epel
          graphviz-php.x86_64 2.26.0-7.el6 base
          nntpgrab-php.x86_64 0.7.2-1.el6 epel
          php-IDNA_Convert.noarch 0.7.0-1.el6 epel
          php-Kohana.noarch 2.4-1.rc2.el6 epel
          php-PHPMailer.noarch 5.2.1-2.el6 epel
          php-Smarty.noarch 2.6.26-1.el6 epel
          php-ZendFramework.noarch 1.11.12-1.el6 epel
          php-ZendFramework-Auth-Adapter-Ldap.noarch 1.11.12-1.el6 epel
          php-ZendFramework-Cache-Backend-Apc.noarch 1.11.12-1.el6 epel
          php-ZendFramework-Cache-Backend-Memcached.noarch 1.11.12-1.el6 epel
          php-ZendFramework-Captcha.noarch 1.11.12-1.el6 epel
          php-ZendFramework-Db-Adapter-Firebird.noarch 1.11.12-1.el6 epel
          php-ZendFramework-Db-Adapter-Mysqli.noarch 1.11.12-1.el6 epel
          php-ZendFramework-Dojo.noarch 1.11.12-1.el6 epel
          php-ZendFramework-Feed.noarch 1.11.12-1.el6 epel
          php-ZendFramework-Gdata.noarch 1.11.12-1.el6 epel
          php-ZendFramework-Ldap.noarch 1.11.12-1.el6 epel
          php-ZendFramework-Pdf.noarch 1.11.12-1.el6 epel
          php-ZendFramework-Search-Lucene.noarch 1.11.12-1.el6 epel
          php-ZendFramework-Services.noarch 1.11.12-1.el6 epel
          php-ZendFramework-Soap.noarch 1.11.12-1.el6 epel
          php-ZendFramework-demos.noarch 1.11.12-1.el6 epel
          php-ZendFramework-extras.noarch 1.11.12-1.el6 epel
          php-adodb.noarch 4.95-1.a.el6 epel
          php-bartlett-PHP-CompatInfo.noarch 2.5.0-1.el6.1 epel
          php-bartlett-PHP-Reflect.noarch 1.3.0-1.el6 epel
          php-bcmath.x86_64 5.3.3-14.el6_3 updates
          php-channel-bartlett.noarch 1.3-1.el6 epel
          php-channel-deepend.noarch 1.3-2.el6 epel
          php-channel-digitalsandwich.noarch 1.3-2.el6 epel
          php-channel-doctrine.noarch 1.3-1.el6.1 epel
          php-channel-ezc.noarch 1-2.el6 epel
          php-channel-horde.noarch 1.0-1.el6 epel
          php-channel-htmlpurifier.noarch 1.0-2.el6 epel
          php-channel-pdepend.noarch 1.3-4.el6 epel
          php-channel-pearplex.noarch 1.3-2.el6 epel
          php-channel-phing.noarch 1.3-1.el6 epel
          php-channel-phpdoc.noarch 1.3-3.el6 epel
          php-channel-phpmd.noarch 1.3-3.el6 epel
          php-channel-phpqatools.noarch 1.3-3.el6 epel
          php-channel-phpunit.noarch 1.3-3.el6 epel
          php-channel-swift.noarch 1.3-2.el6 epel
          php-channel-symfony.noarch 1.3-1.el6 epel
          php-channel-symfony2.noarch 1.0-3.el6 epel
          php-channel-twig.noarch 1.0-3.el6 epel
          php-dba.x86_64 5.3.3-14.el6_3 updates
          php-deepend-Mockery.noarch 0.7.2-1.el6 epel
          php-devel.x86_64 5.3.3-14.el6_3 updates
          php-digitalsandwich-Phake.noarch 1.0.2-1.el6 epel
          php-doctrine-Doctrine.noarch 1.2.4-1.el6 epel
          php-domxml-php4-php5.noarch 1.21.2-1.el6 epel
          php-eaccelerator.x86_64 1:0.9.6.1-1.el6 epel
          php-email-address-validation.noarch 0-0.3.20090910svn.el6 epel
          php-embedded.x86_64 5.3.3-14.el6_3 updates
          php-enchant.x86_64 5.3.3-14.el6_3 updates
          php-ezc-Archive.noarch 1.4.1-2.el6 epel
          php-ezc-Authentication.noarch 1.3.1-1.el6 epel
          php-ezc-AuthenticationDatabaseTiein.noarch 1.1-1.el6 epel
          php-ezc-Base.noarch 1.8-1.el6 epel
          php-ezc-Cache.noarch 1.5-1.el6 epel
          php-ezc-Configuration.noarch 1.3.5-1.el6 epel
          php-ezc-ConsoleTools.noarch 1.6.1-1.el6 epel
          php-ezc-Database.noarch 1.4.7-1.el6 epel
          php-ezc-DatabaseSchema.noarch 1.4.4-1.el6 epel
          php-ezc-EventLog.noarch 1.4-2.el6 epel
          php-ezc-EventLogDatabaseTiein.noarch 1.0.2-1.el6 epel
          php-ezc-Feed.noarch 1.3-1.el6 epel
          php-ezc-File.noarch 1.2-3.el6 epel
          php-ezc-Graph.noarch 1.5-1.el6 epel
          php-ezc-Mail.noarch 1.7.1-1.el6 epel
          php-ezc-PersistentObject.noarch 1.7.1-1.el6 epel
          php-ezc-PersistentObjectDatabaseSchemaTiein.noarch 1.3-1.el6 epel
          php-ezc-SystemInformation.noarch 1.0.8-1.el6 epel
          php-ezc-Template.noarch 1.4.2-1.el6 epel
          php-ezc-Webdav.noarch 1.1.4-1.el6 epel
          php-facedetect.x86_64 1.0.0-6.el6 epel
          php-feedcreator.noarch 1.7.2-4.el6 epel
          php-fpdf.noarch 1.6-4.el6 epel
          php-fpdf-doc.noarch 1.6-4.el6 epel
          php-geshi.noarch 1.0.8.8-1.el6 epel
          php-htmLawed.noarch 1.1.12-1.el6 epel
          php-idn.x86_64 1.2c-1.el6 epel
          php-imap.x86_64 5.3.3-14.el6_3 updates
          php-interbase.x86_64 5.3.3-1.el6 epel
          php-intl.x86_64 5.3.3-14.el6_3 updates
          php-layers-menu.noarch 3.2.0-0.2.rc.el6 epel
          php-ldap.x86_64 5.3.3-14.el6_3 updates
          php-libdmtx.x86_64 0.7.2-3.el6 epel
          php-libpuzzle.x86_64 0.11-7.el6 epel
          php-magickwand.x86_64 1.0.9-1.el6 epel
          php-magpierss.noarch 0.72-6.el6 epel
          php-mapi.x86_64 7.0.8-1.el6 epel
          php-mcrypt.x86_64 5.3.3-1.el6 epel
          php-mssql.x86_64 5.3.3-1.el6 epel
          php-odbc.x86_64 5.3.3-14.el6_3 updates
          php-pdepend-PHP-Depend.noarch 1.0.7-1.el6 epel
          php-pear.noarch 1:1.9.4-4.el6 base
          php-pear-Auth-RADIUS.noarch 1.0.7-1.el6 epel
          php-pear-Auth-SASL.noarch 1.0.4-1.el6 epel
          php-pear-Benchmark.noarch 1.2.7-4.el6 epel
          php-pear-CAS.noarch 1.3.0-2.el6 epel
          php-pear-Cache.noarch 1.5.6-1.el6 epel
          php-pear-Cache-Lite.noarch 1.7.12-1.el6 epel
          php-pear-CodeGen.noarch 1.0.7-3.el6 epel
          php-pear-CodeGen-PECL.noarch 1.1.3-3.el6 epel
          php-pear-Console-Color.noarch 1.0.3-1.el6 epel
          php-pear-Console-CommandLine.noarch 1.1.3-3.el6 epel
          php-pear-Console-Getargs.noarch 1.3.5-1.el6 epel
          php-pear-Console-ProgressBar.noarch 0.5.2-0.6.beta.el6 epel
          php-pear-Console-Table.noarch 1.1.4-1.el6.2 epel
          php-pear-Crypt-Blowfish.noarch 1.1.0-0.4.rc2.el6 epel
          php-pear-Crypt-CHAP.noarch 1.5.0-1.el6 epel
          php-pear-DB.noarch 1.7.13-3.el6 epel
          php-pear-DB-DataObject.noarch 1.8.12-2.el6 epel
          php-pear-DB-DataObject-FormBuilder.noarch 1.0.0-2.el6 epel
          php-pear-DB-QueryTool.noarch 1.1.2-4.el6 epel
          php-pear-Date.noarch 1.4.7-5.el6 epel
          php-pear-Date-Holidays.noarch 0.21.4-2.el6 epel
          php-pear-Date-Holidays-USA.noarch 0.1.1-4.el6 epel
          php-pear-Event-Dispatcher.noarch 1.1.0-2.el6 epel
          php-pear-File.noarch 1.4.0-1.el6 epel
          php-pear-File-CSV.noarch 1.0.0-2.el6 epel
          php-pear-File-Find.noarch 1.3.1-1.el6 epel
          php-pear-File-Passwd.noarch 1.1.7-2.el6 epel
          php-pear-File-SMBPasswd.noarch 1.0.3-2.el6 epel
          php-pear-File-Util.noarch 1.0.0-2.el6 epel
          php-pear-HTML-Common.noarch 1.2.5-3.el6 epel
          php-pear-HTML-QuickForm.noarch 3.2.12-1.el6 epel
          php-pear-HTML-QuickForm-ElementGrid.noarch 0.1.1-5.el6 epel
          php-pear-HTML-QuickForm-advmultiselect.noarch 1.5.1-3.el6 epel
          php-pear-HTML-Table.noarch 1.8.3-1.el6 epel
          php-pear-HTML_Javascript.noarch 1.1.1-4.el6 epel
          php-pear-HTML_Template_PHPLIB.noarch 1.4.0-2.el6 epel
          php-pear-HTTP.noarch 1.4.1-5.el6 epel
          php-pear-HTTP-Client.noarch 1.2.1-4.el6 epel
          php-pear-HTTP-OAuth.noarch 0.2.2-1.el6 epel
          php-pear-HTTP-Request.noarch 1.4.4-2.el6 epel
          php-pear-HTTP-Request2.noarch 0.5.2-2.el6 epel
          php-pear-HTTP-Upload.noarch 0.9.1-5.el6 epel
          php-pear-Image-Canvas.noarch 0.3.3-1.el6 epel
          php-pear-Image-Color.noarch 1.0.4-1.el6 epel
          php-pear-Image-Graph.noarch 0.8.0-1.el6 epel
          php-pear-Image-GraphViz.noarch 1.3.0-1.el6 epel
          php-pear-Log.noarch 1.12.7-1.el6 epel
          php-pear-MDB2.noarch 2.5.0-0.3.b3.el6 epel
          php-pear-MDB2-Driver-mysql.noarch 1.5.0-0.1.b3.el6 epel
          php-pear-MDB2-Driver-mysqli.noarch 1.5.0-0.1.b3.el6 epel
          php-pear-MDB2-Driver-pgsql.noarch 1.5.0-0.1.b3.el6 epel
          php-pear-MDB2-Schema.noarch 0.8.5-1.el6 epel
          php-pear-Mail.noarch 1.2.0-1.el6 epel
          php-pear-Mail-Mime.noarch 1.8.4-1.el6 epel
          php-pear-Mail-mimeDecode.noarch 1.5.5-1.el6 epel
          php-pear-Math-Stats.noarch 0.9.1-1.el6 epel
          php-pear-Net-Curl.noarch 1.2.5-4.el6 epel
          php-pear-Net-DIME.noarch 1.0.2-1.el6 epel
          php-pear-Net-FTP.noarch 1.3.7-4.el6 epel
          php-pear-Net-IDNA2.noarch 0.1.1-3.el6 epel
          php-pear-Net-POP3.noarch 1.3.8-1.el6 epel
          php-pear-Net-Ping.noarch 2.4.5-2.el6 epel
          php-pear-Net-SMTP.noarch 1.6.1-1.el6 epel
          php-pear-Net-Sieve.noarch 1.3.2-1.el6 epel
          php-pear-Net-Socket.noarch 1.0.10-1.el6 epel
          php-pear-Net-Traceroute.noarch 0.21.3-1.el6 epel
          php-pear-Net-URL.noarch 1.0.15-4.el6 epel
          php-pear-Net-URL-Mapper.noarch 0.9.1-1.el6 epel
          php-pear-Net-URL2.noarch 0.3.1-2.el6 epel
          php-pear-Net-UserAgent-Detect.noarch 2.5.2-1.el6 epel
          php-pear-Numbers-Roman.noarch 1.0.2-5.el6 epel
          php-pear-Numbers-Words.noarch 0.16.2-1.el6 epel
          php-pear-OLE.noarch 1.0.0-0.4.rc1.el6 epel
          php-pear-PHP-CodeSniffer.noarch 1.3.4-1.el6 epel
          php-pear-PHP-Compat.noarch 1.5.0-5.el6 epel
          php-pear-PHP-CompatInfo.noarch 1.9.0-3.el6 epel
          php-pear-Pager.noarch 2.4.8-2.el6 epel
          php-pear-Payment-Process.noarch 0.6.6-5.el6 epel
          php-pear-PhpDocumentor.noarch 1.4.4-1.el6 epel
          php-pear-SOAP.noarch 0.12.0-4.el6 epel
          php-pear-Services-Twitter.noarch 0.6.1-1.el6 epel
          php-pear-Services-Weather.noarch 1.4.5-2.el6 epel
          php-pear-Structures-DataGrid.noarch 0.9.0-6.el6 epel
          php-pear-Structures-DataGrid-DataSource-Array.noarch 0.1.4-4.el6 epel
          php-pear-Structures-DataGrid-DataSource-DataObject.noarch 0.2.1-4.el6 epel
          php-pear-Structures-DataGrid-DataSource-MDB2.noarch 0.1.11-4.el6 epel
          php-pear-Structures-DataGrid-DataSource-RSS.noarch 0.1.1-4.el6 epel
          php-pear-Structures-DataGrid-Renderer-Pager.noarch 0.1.3-4.el6 epel
          php-pear-Structures-DataGrid-Renderer-Smarty.noarch 0.1.5-1.el6 epel
          php-pear-Text-Diff.noarch 1.1.0-2.el6 epel
          php-pear-Validate.noarch 0.8.3-1.el6 epel
          php-pear-Validate-Finance-CreditCard.noarch 0.5.3-4.el6 epel
          php-pear-Var-Dump.noarch 1.0.3-5.el6 epel
          php-pear-XML-Beautifier.noarch 1.2.2-1.el6 epel
          php-pear-XML-Parser.noarch 1.3.4-1.el6 epel
          php-pear-XML-RPC2.noarch 1.0.6-1.el6 epel
          php-pear-XML-RSS.noarch 1.0.1-1.el6 epel
          php-pear-XML-Serializer.noarch 0.20.2-1.el6 epel
          php-pear-phing.noarch 2.4.12-1.el6 epel
          php-pecl-amqp.x86_64 1.0.1-3.el6 epel
          php-pecl-apc.x86_64 3.1.9-2.el6 base
          php-pecl-apc-devel.x86_64 3.1.9-2.el6 base
          php-pecl-geoip.x86_64 1.0.7-4.el6 epel
          php-pecl-gmagick.x86_64 1.1.0-0.2.RC2.el6 epel
          php-pecl-igbinary.i686 1.1.1-3.el6 epel
          php-pecl-igbinary.x86_64 1.1.1-3.el6 epel
          php-pecl-igbinary-devel.i686 1.1.1-3.el6 epel
          php-pecl-igbinary-devel.x86_64 1.1.1-3.el6 epel
          php-pecl-imagick.x86_64 2.2.2-4.el6 epel
          php-pecl-lzf.x86_64 1.5.2-5.el6 epel
          php-pecl-mailparse.x86_64 2.1.5-2.el6 epel
          php-pecl-memcache.x86_64 3.0.5-4.el6 base
          php-pecl-memcached.x86_64 1.0.0-1.el6 epel
          php-pecl-mongo.x86_64 1.2.10-1.el6 epel
          php-pecl-ncurses.x86_64 1.0.1-1.el6 epel
          php-pecl-parsekit.x86_64 1.2-5.CVS20090309.el6 epel
          php-pecl-radius.x86_64 1.2.5-10.el6 epel
          php-pecl-rrd.x86_64 1.0.3-1.el6 epel
          php-pecl-runkit.x86_64 0.9-12.CVS20090215.el6 epel
          php-pecl-solr.x86_64 0.9.11-1.el6 epel
          php-pecl-sphinx.x86_64 1.0.0-2.el6 epel
          php-pecl-ssh2.x86_64 0.11.0-7.el6 epel
          php-pecl-xdebug.x86_64 2.1.4-1.el6 epel
          php-pecl-xhprof.x86_64 0.9.2-5.el6 epel
          php-pgsql.x86_64 5.3.3-14.el6_3 updates
          php-php-gettext.noarch 1.0.11-3.el6 epel
          php-phpmd-PHP-PMD.noarch 1.3.3-1.el6 epel
          php-phpunit-DbUnit.noarch 1.1.2-1.el6 epel
          php-phpunit-File-Iterator.noarch 1.3.1-1.el6 epel
          php-phpunit-PHP-CodeBrowser.noarch 1.0.2-1.el6 epel
          php-phpunit-PHP-CodeCoverage.noarch 1.1.2-1.el6 epel
          php-phpunit-PHP-Invoker.noarch 1.1.0-1.el6 epel
          php-phpunit-PHP-Timer.noarch 1.0.2-2.el6 epel
          php-phpunit-PHP-TokenStream.noarch 1.1.3-1.el6 epel
          php-phpunit-PHPUnit.noarch 3.6.11-1.el6 epel
          php-phpunit-PHPUnit-MockObject.noarch 1.1.1-1.el6 epel
          php-phpunit-PHPUnit-Selenium.noarch 1.2.7-1.el6 epel
          php-phpunit-PHPUnit-SkeletonGenerator.noarch 1.1.0-1.el6 epel
          php-phpunit-Text-Template.noarch 1.1.1-1.el6 epel
          php-phpunit-phpcpd.noarch 1.3.5-1.el6 epel
          php-phpunit-phpdcd.noarch 0.9.3-1.el6 epel
          php-phpunit-phploc.noarch 1.6.2-1.el6 epel
          php-process.x86_64 5.3.3-14.el6_3 updates
          php-pspell.x86_64 5.3.3-14.el6_3 updates
          php-recode.x86_64 5.3.3-14.el6_3 updates
          php-redland.x86_64 1.0.7.1-1.el6 epel
          php-shout.x86_64 0.9.2-6.el6 epel
          php-simplepie.noarch 1.1.3-4.el6 epel
          php-snmp.x86_64 5.3.3-14.el6_3 updates
          php-soap.x86_64 5.3.3-14.el6_3 updates
          php-suhosin.x86_64 0.9.29-2.el6 epel
          php-swift-Swift.noarch 4.1.7-1.el6 epel
          php-symfony-YAML.noarch 1.0.6-1.el6 epel
          php-symfony-symfony.noarch 1.4.18-1.el6 epel
          php-symfony2-BrowserKit.noarch 2.0.15-2.el6 epel
          php-symfony2-ClassLoader.noarch 2.0.15-2.el6 epel
          php-symfony2-Config.noarch 2.0.15-1.el6 epel
          php-symfony2-Console.noarch 2.0.15-1.el6 epel
          php-symfony2-CssSelector.noarch 2.0.15-1.el6 epel
          php-symfony2-DependencyInjection.noarch 2.0.15-3.el6 epel
          php-symfony2-DomCrawler.noarch 2.0.15-2.el6 epel
          php-symfony2-EventDispatcher.noarch 2.0.15-1.el6 epel
          php-symfony2-Finder.noarch 2.0.15-1.el6 epel
          php-symfony2-Form.noarch 2.0.15-4.el6 epel
          php-symfony2-HttpFoundation.noarch 2.0.15-2.el6 epel
          php-symfony2-HttpKernel.noarch 2.0.15-3.el6 epel
          php-symfony2-Locale.noarch 2.0.15-3.el6 epel
          php-symfony2-Process.noarch 2.0.15-1.el6 epel
          php-symfony2-Routing.noarch 2.0.15-3.el6 epel
          php-symfony2-Security.noarch 2.0.15-3.el6 epel
          php-symfony2-Serializer.noarch 2.0.15-1.el6 epel
          php-symfony2-Templating.noarch 2.0.15-1.el6 epel
          php-symfony2-Translation.noarch 2.0.15-4.el6 epel
          php-symfony2-Validator.noarch 2.0.15-4.el6 epel
          php-symfony2-Yaml.noarch 2.0.15-1.el6 epel
          php-tidy.x86_64 5.3.3-14.el6_3 updates
          php-twig-Twig.noarch 1.8.2-1.el6 epel
          php-voms-admin.noarch 0.6-1.el6 epel
          php-xapian.x86_64 1.2.7-1.el6 epel
          php-xmlrpc.x86_64 5.3.3-14.el6_3 updates
          php-zipstream.noarch 0.2.2-1.el6 epel
          php-zmq.x86_64 0.6.0-4.20120613git516bd6f.el6 epel
          php-zts.x86_64 5.3.3-14.el6_3 updates
          phpMyAdmin.noarch 3.5.1-1.el6 epel
          phpPgAdmin.noarch 5.0.4-1.el6 epel
          phpldapadmin.noarch 1.2.2-1.el6 epel
          phpwapmail.noarch 0.9.4-1.el6 epel
          rrdtool-php.x86_64 1.3.8-6.el6 base
          uuid-php.x86_64 1.6.1-10.el6 base
          [indapublic@myserver ~]$ yum --enablerepo=remi repolist
          Loaded plugins: fastestmirror
          Loading mirror speeds from cached hostfile
          * Webmin: download.webmin.com
          * base: mirror.yandex.ru
          * epel: mirror.yandex.ru
          * extras: mirror.yandex.ru
          * remi: rpms.famillecollet.com
          * updates: mirror.yandex.ru
          remi | 2.9 kB 00:00
          remi/primary_db | 273 kB 00:04
          repo id repo name status
          Webmin Webmin Distribution Neutral 118
          base CentOS-6 - Base 6 346
          *epel Extra Packages for Enterprise Linux 6 - x86_64 7 634
          extras CentOS-6 - Extras 4
          remi Les RPM de remi pour Enterprise Linux 6 - x86_64 539
          updates CentOS-6 - Updates 256
          repolist: 14 897
          [indapublic@myserver ~]$

          Reply
          • JR / July 30, 2012

            Hi again indapublic,

            Try to install it with following command:

            yum --enablerepo=remi,remi-test install phpmyadmin

            You got this error, because you have PHP 5.4 installed from remi-test repo. I updated this guide too.

            Reply
            • indapublic / July 30, 2012

              Thank you very much. It works.

              Reply
              • JR / July 30, 2012

                You are welcome! :)

                Reply
  9. ReynierPM / August 8, 2012

    Hi, I’m having problems after installing phpMyAdmin following the steps here because every time I call pma.devserver or phpMyAdmin.devserver I go to Apache Root Directory instead of /usr/share/phpMyAdmin. I check the phpMyAdmin.conf file and seems to be good and also I change from Deny from All to Allow from All to give access to my PC. I’m using Apache Virtual Host feature under CentOS 6.3 with Apache 2.2.15, any advice?

    Reply
  10. ReynierPM / August 8, 2012

    Hi Indapublic, what you mean with httpd.conf? If is the configuration file you can download from here https://docs.google.com/open?id=0BwyEmER2hZQ7blB6MFZOTHdpV2c

    Reply
    • JR / August 8, 2012

      Hi ReynierPM,

      Could you post /etc/httpd/conf.d/phpMyAdmin.conf file content?

      Reply
  11. indapublic / August 8, 2012

    I think, php is not installed corrrectly. Directoryindex section not contain php extension in httpd.conf

    Reply
    • JR / August 8, 2012

      I think that the problem might be phpMyAdmin virtual host and server name configuration.

      Reply
  12. ReynierPM / August 8, 2012

    @indapublic PHP is working fine because I access to many WP installations without problems. @JR: Here is the phpMyAdmin.conf file http://pastebin.com/y9rtBb8F

    Reply
  13. ReynierPM / August 8, 2012

    This is not at localhost is on another PC and if I yes I can access

    Reply
    • JR / August 9, 2012

      Okay, then try http://devserver/phpMyAdmin (or http://devserver/phpmyadmin). So use address which point to your another PC and add phpmyadmin path.

      Reply
      • ReynierPM / August 20, 2012

        Didn’t work at all. I create a new VM using CentOS 6.3 with clean installation just install Apache, PHP, MySQL and then phpMyAdmin and default conf file for VH doesn’t work and can’t find the cause. Maybe Virtual Host is the problem?

        Reply
        • JR / August 20, 2012

          Is it working from localhost?

          Reply
  14. antiwesley / August 14, 2012

    403. :(

    Centos 5.8
    Apache/2.2.3

    nano /etc/httpd/conf.d/phpMyAdmin.conf:

    # Apache 2.4
    Require local

    # Apache 2.2
    Order Deny,Allow
    Deny from All
    Allow from 127.0.0.1
    Allow from 190.xxx.xxx.xxx
    Allow from ::1

    Thanks. EVerything has been very helpful so far.

    Reply
    • JR / August 15, 2012

      Hi antiwesley,

      Could you post full content of /etc/httpd/conf.d/phpMyAdmin.conf file?

      Reply
      • antiwesley / August 16, 2012

        # phpMyAdmin - Web based MySQL browser written in php
        #
        # Allows only localhost by default
        #
        # But allowing phpMyAdmin to anyone other than localhost should be considered
        # dangerous unless properly secured by SSL

        Alias /phpMyAdmin /usr/share/phpMyAdmin
        Alias /phpmyadmin /usr/share/phpMyAdmin

        # Apache 2.4
        Require local

        # Apache 2.2
        Order Deny,Allow
        Deny from All
        Allow from 127.0.0.1
        Allow from 190.xxx.xx.xxx
        Allow from ::1

        # Apache 2.4
        Require local

        # Apache 2.2
        Order Deny,Allow
        Deny from All
        Allow from 190.xxx.xx.xxx
        Allow from 127.0.0.1
        Allow from ::1

        # These directories do not require access over HTTP - taken from the original
        # phpMyAdmin upstream tarball
        #

        Order Deny,Allow
        Deny from All
        Allow from None

        Order Deny,Allow
        Deny from All
        Allow from None

        Order Deny,Allow
        Deny from All
        Allow from None

        # This configuration prevents mod_security at phpMyAdmin directories from
        # filtering SQL etc. This may break your mod_security implementation.
        #
        #
        #
        # SecRuleInheritance Off
        #
        #

        This is what came pre-installed with my LAP… (had to install mySQL myself)

        Reply
      • antiwesley / August 16, 2012

        Hrm. The Code tag doesn’t like the tags inside it.

        # phpMyAdmin - Web based MySQL browser written in php
        #
        # Allows only localhost by default
        #
        # But allowing phpMyAdmin to anyone other than localhost should be considered
        # dangerous unless properly secured by SSL

        Alias /phpMyAdmin /usr/share/phpMyAdmin
        Alias /phpmyadmin /usr/share/phpMyAdmin

        (Directory /usr/share/phpMyAdmin/)

        (IfModule mod_authz_core.c)
        # Apache 2.4
        Require local
        (/IfModule)
        (IfModule !mod_authz_core.c)
        # Apache 2.2
        Order Deny,Allow
        Deny from All
        Allow from 127.0.0.1
        Allow from 190.xxx.xx.xxx
        Allow from ::1
        (/IfModule)
        (/Directory)

        (Directory /usr/share/phpMyAdmin/setup/)
        (IfModule mod_authz_core.c)
        # Apache 2.4
        Require local
        (/IfModule)
        (IfModule !mod_authz_core.c)
        # Apache 2.2
        Order Deny,Allow
        Deny from All
        Allow from 190.xxx.xx.xxx
        Allow from 127.0.0.1
        Allow from ::1
        (/IfModule)
        (/Directory)

        # These directories do not require access over HTTP - taken from the original
        # phpMyAdmin upstream tarball
        #
        (Directory /usr/share/phpMyAdmin/libraries/)
        Order Deny,Allow
        Deny from All
        Allow from None
        (/Directory)

        (Directory /usr/share/phpMyAdmin/setup/lib/)
        Order Deny,Allow
        Deny from All
        Allow from None
        (/Directory)

        (Directory /usr/share/phpMyAdmin/setup/frames/)
        Order Deny,Allow
        Deny from All
        Allow from None
        (/Directory)

        # This configuration prevents mod_security at phpMyAdmin directories from
        # filtering SQL etc. This may break your mod_security implementation.
        #
        #(IfModule mod_security.c)
        # (Directory /usr/share/phpMyAdmin/)
        # SecRuleInheritance Off
        # (/Directory)
        #(/IfModule)

        —-
        replace () with

        Reply
        • JR / August 16, 2012

          Oh, I see. Actually <pre lang=”bash”>Code here</pre> syntax should work better, but I got your config thanks. :)

          Did you try to access phpMyAdmin from localhost?

          Reply
          • antiwesley / August 17, 2012

            VPS. So unless I can do it from an SSH shell.. then no.

            Reply
            • JR / August 17, 2012

              You can check it from SSH shell, if you have curl or lynx installed:

              curl -I http://localhost/phpmyadmin
 
lynx -head -mime_header http://localhost/phpmyadmin
              Reply
              • antiwesley / August 21, 2012 
                [root@server1 /]# curl -I http://localhost/phpmyadmin
HTTP/1.1 301 Moved Permanently
Date: Tue, 21 Aug 2012 02:37:47 GMT
Server: Apache/2.2.3 (CentOS)
Location: http://localhost/phpmyadmin/
Connection: close
Content-Type: text/html; charset=iso-8859-1
                Reply
                • JR / August 21, 2012

                  Sorry, this was my mistake, you need one extra slash (/), could you post again:

                  curl -I http://localhost/phpmyadmin/
                  Reply
                  • antiwesley / August 22, 2012 
                    HTTP/1.1 200 OK
Date: Wed, 22 Aug 2012 05:03:05 GMT
Server: Apache/2.2.3 (CentOS)
X-Powered-By: PHP/5.4.6
Set-Cookie: phpMyAdmin=e3653o786l641kksu3ucelka4ijkdle8; path=/phpmyadmin/; HttpOnly
Expires: Thu, 19 Nov 1981 08:52:00 GMT
Cache-Control: private, max-age=10800, pre-check=10800
Last-Modified: Sun, 12 Aug 2012 13:45:56 GMT
Set-Cookie: pma_lang=en; expires=Fri, 21-Sep-2012 05:03:11 GMT; path=/phpmyadmin/; httponly
Set-Cookie: pma_collation_connection=utf8_general_ci; expires=Fri, 21-Sep-2012 05:03:11 GMT; path=/phpmyadmin/;
 httponly
Set-Cookie: pma_mcrypt_iv=fHSjSK%2BerYY%3D; expires=Fri, 21-Sep-2012 05:03:12 GMT; path=/phpmyadmin/; httponly
Set-Cookie: phpMyAdmin=3c68lvc1dcc2i2jol14ik7ga8bfa03gb; path=/phpmyadmin/; HttpOnly
Connection: close
Content-Type: text/html; charset=utf-8
                    Reply
                    • JR / August 22, 2012

                      Good, it works! :)

                      Now you have to add your ip or subnet to config file:

                      ...
Allow from 127.0.0.1
Allow from [your ip or subnet here]
...
  15. antiwesley / August 22, 2012

    Both IP’s were already in /etc/httpd/conf.d/phpMyAdmin.conf.

    I just checked to see if mysql was running and it’s not, nor will it let me restart the service. :(

    Reply
    • JR / August 22, 2012

      Good. Do you have port 80 open on your server?

      netstat -ntulp
      Reply
      • antiwesley / August 22, 2012 
        tcp        0      0 0.0.0.0:80                  0.0.0.0:*                   LISTEN      5789/httpd
        Reply
        • JR / August 22, 2012

          Okay, looks good.

          Do you get some error when you try to start mysql?

          For more information you could check /var/log/mysqld.log log file.

          Reply
          • antiwesley / August 22, 2012 
            120822 10:56:40 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
120822 10:56:40 [Note] Plugin 'FEDERATED' is disabled.
120822 10:56:40 InnoDB: The InnoDB memory heap is disabled
120822 10:56:40 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
120822 10:56:40 InnoDB: Compressed tables use zlib 1.2.3
120822 10:56:40 InnoDB: Using Linux native AIO
120822 10:56:40 InnoDB: Initializing buffer pool, size = 128.0M
120822 10:56:40 InnoDB: Completed initialization of buffer pool
InnoDB: Error: pthread_create returned 11
120822 10:56:40 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
            Reply
            • JR / August 22, 2012

              Could you post output of following commands:

              df -h
 
free -m
 
cat /etc/my.cnf
              Reply
              • antiwesley / August 22, 2012 
                [root@server1 /]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/simfs             10G  694M  9.4G   7% /
[root@server1 /]#
[root@server1 /]# free -m
             total       used       free     shared    buffers     cached
Mem:           256         63        192          0          0          0
-/+ buffers/cache:         63        192
Swap:            0          0          0
[root@server1 /]#
[root@server1 /]# cat /etc/my.cnf
[mysqld]
# Settings user and group are ignored when systemd is used (fedora >= 15).
# If you need to run mysqld under different user or group,
# customize your systemd unit file for mysqld according to the
# instructions in http://fedoraproject.org/wiki/Systemd
user=mysql

datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

# Semisynchronous Replication
# http://dev.mysql.com/doc/refman/5.5/en/replication-semisync.html
# uncomment next line on MASTER
;plugin-load=rpl_semi_sync_master=semisync_master.so
# uncomment next line on SLAVE
;plugin-load=rpl_semi_sync_slave=semisync_slave.so

# Others options for Semisynchronous Replication
;rpl_semi_sync_master_enabled=1
;rpl_semi_sync_master_timeout=10
;rpl_semi_sync_slave_enabled=1

# http://dev.mysql.com/doc/refman/5.5/en/performance-schema.html
;performance_schema

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
                Reply
                • JR / August 23, 2012

                  Your error InnoDB: Error: pthread_create returned 11 sounds like a memory problem, do you need InnoDB?

                  If not, then you could add following to your /etc/my.cnf:

                  skip-innodb

                  And try to start mysqld.

                  Reply
                  • antiwesley / August 24, 2012

                    Yes, it was a memory issue, and thanks to some Google-Fu, I was able to fix that.
                    httpd and mysql are running, but they are both using up a lot of the memory to begin with.
                    Both /phpmyadmin and /phpMyAdmin are 403′ing in my webbrowser, and still giving the okay in the terminal.

                    Reply
                    • JR / August 24, 2012

                      Okay, sounds good. :)

                      To correct that 403 error I recommend you to test first what happens if allow all traffic temporarily, change config to:

                      <Directory /usr/share/phpMyAdmin/>
   <IfModule mod_authz_core.c>
     # Apache 2.4
     Require local
   </IfModule>
   <IfModule !mod_authz_core.c>
     # Apache 2.2
     Order Allow,Deny
     Allow from All
   </IfModule>
</Directory>

                      Restart httpd and try to access phpMyAdmin, is it working then or do you still get 403 error?

  16. antiwesley / August 25, 2012

    It’s working now. The only problem I have to work out is that I forgot the user/pass combination I had set up and Google-Fu isn’t helping. Lots of solutions, but nothing works yet.

    But thank you again for the help on this. It was a bit of a pain, and I’ll be upping the memory ASAP on the server so it’ll work a bit better.

    Reply
  17. pouya / September 18, 2012

    yum –enablerepo=remi install phpmyadmin will fetch v 2.11 from rpmforg which is realy old insted type:

    yum –enablerepo=remi install phpMyAdmin

    which install 3.5.2.2 from epel

    Reply
    • JR / September 18, 2012

      Hi pouya,

      Yes, this depends what repositories you have installed, but if you want install it from remi repository, then you need to disable other not needed repos and install it from remi repo.

      Reply
      • pouya / September 19, 2012

        hi JR

        In both statements we declare remi as our repo. i’m confused why we shouldn’t type

        yum –enablerepo=epel install phpMyAdmin

        if it’s possible please elaborate more

        thanks i bookmarked your site and always check it for useful and uptodate tutorials

        Reply
        • pouya / September 19, 2012

          remi repo only contains 2.11 not 3.5.2

          Reply
          • JR / September 19, 2012

            Hi pouya,

            I said that you have to disable epel & rpmforge and enable remi:

            yum --disablerepo=epel,rpmforge --enablerepo=remi install phpMyAdmin

            Could you also post output of following commands:

            uname -a
 
lsb_release -a
 
yum repolist
 
yum --disablerepo=* --enablerepo=remi list phpMyAdmin

            My output from remi repo is following:

            yum --disablerepo=* --enablerepo=remi list phpMyAdmin
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * remi: fr2.rpmfind.net
Installed Packages
phpMyAdmin.noarch                    3.5.2.2-1.el6.remi                    @remi

            So I see currently only phpMyAdmin 3.5.2.2 on remi repository.

            Reply
  18. Ctu / September 19, 2012

    I’ve install nginx, php, mysql and phpmyadmin following this site’s essays. I can access http://pma/ now, while http://localhost/phpmyadmin/ is denied (404). What should I check?

    Reply
  19. Mosfet / October 26, 2012

    JR As I was saying I’ back :). Sorry to bother you but I’m a linux noob.

    Followed your instructions wit success.
    My issue is that since this is a VPS I don’t have aces to localhost. therefore I must access phpmyadmin from web.

    How Do I do that. I’ve tried putting local host /phpmyadmin in the virtual host config with no success.
    Also tried putting it in default config without results.

    Thanks !

    Reply
    • JR / October 26, 2012

      Hi again Mosfet :)

      This is exactly reason why I run this site, try to help other users, so feel free to ask. :D

      First a couple of questions…so you are using nginx setup, right? Do you have some domain pointing to this server and you have control to subdomains?

      Reply
      • Mosfet / October 26, 2012

        At this moment I have 2 domains pointing to the server. In test both work fine.
        But when I’m trying to access phpmyadmin all I get is an empty page.

        Tried the /phpmyadmin method posted in the comments and changing the “pma” in examples with my actual domain expecting to load phpmysql when accessing domain.tld to get phpmyadmin.

        Reply
        • JR / October 26, 2012

          Ok, then if possible create subdomain which point to your server too:
          pma.domain.tld

          Then create virtual host file, like:

          server {
       listen   80;
       server_name pma.domain.tld;       access_log /var/log/nginx/phpmyadmin/access.log;
       error_log /var/log/nginx/phpmyadmin/error.log;
       root /usr/share/phpMyAdmin;
 
       location / {
           index  index.php;
       }
 
       ## Images and static content is treated different
       location ~* ^.+.(jpg|jpeg|gif|css|png|js|ico|xml)$ {
           access_log        off;
           expires           360d;
       }
 
       location ~ /\.ht {
           deny  all;
       }
 
       location ~ /(libraries|setup/frames|setup/libs) {
           deny all;
           return 404;
       }
 
       location ~ \.php$ {
           include /etc/nginx/fastcgi_params;
           fastcgi_pass 127.0.0.1:9000;
           fastcgi_index index.php;
           fastcgi_param SCRIPT_FILENAME /usr/share/phpMyAdmin$fastcgi_script_name;
       }
}

          Restart Nginx and try to access http://pma.domain.tld

          Reply
          • Mosfet / October 26, 2012

            Hi, in order to make this more easy I’ve registered a .tk tld.

            I’ve created virtual host file for that domain and tested with a hello world php example. The test and domain is http://www.phpmyadmintestdomain.tk and as you can see the “hello world ” is working just fine.

            After this :
            – I’ve created and pointed the subdomain myadmin.phpmyadmintestdomain.tk to the VPS server.
            – Made a virtual-host file ( /etc/nginx/sites-available/myadmin.phpmyadmintestdomain.tk ) and a link to thesame file in /etc/nginx/sites-enabled.
            – restart nginx ( service nginx restart )

            Without any results. Also you can access the domain and subdomain.

            THANKS !

            Reply
            • Mosfet / October 26, 2012

              This is the content of /var/log/nginx/phpmyadmin/error.log


              2012/10/27 02:15:50 [error] 22242#0: *3 recv() failed (104: Connection reset by peer) while reading response header from upstream, client: xxx.xxx.xxx.xxx (MY IP), server : myadmin.phpmyadmintestdomain.tk, request: "GET / HTTP/1.1", upstream: "fastcgi ://127.0.0.1:9000", host: "myadmin.phpmyadmintestdomain.tk"
              2012/10/27 02:15:53 [error] 22242#0: *3 recv() failed (104: Connection reset by peer) while reading response header from upstream, client: xxx.xxx.xxx.xxx (MY IP), server : myadmin.phpmyadmintestdomain.tk, request: "GET / HTTP/1.1", upstream: "fastcgi ://127.0.0.1:9000", host: "myadmin.phpmyadmintestdomain.tk"
              2012/10/27 02:15:57 [error] 22242#0: *3 recv() failed (104: Connection reset by peer) while reading response header from upstream, client: xxx.xxx.xxx.xxx (MY IP), server : myadmin.phpmyadmintestdomain.tk, request: "GET / HTTP/1.1", upstream: "fastcgi ://127.0.0.1:9000", host: "myadmin.phpmyadmintestdomain.tk"
              2012/10/27 02:17:56 [error] 22242#0: *8 recv() failed (104: Connection reset by peer) while reading response header from upstream, client: xxx.xxx.xxx.xxx (MY IP), server : myadmin.phpmyadmintestdomain.tk, request: "GET / HTTP/1.1", upstream: "fastcgi ://127.0.0.1:9000", host: "myadmin.phpmyadmintestdomain.tk"
              2012/10/27 02:18:09 [error] 22242#0: *8 recv() failed (104: Connection reset by peer) while reading response header from upstream, client: xxx.xxx.xxx.xxx (MY IP), server : myadmin.phpmyadmintestdomain.tk, request: "GET / HTTP/1.1", upstream: "fastcgi ://127.0.0.1:9000", host: "myadmin.phpmyadmintestdomain.tk"
              2012/10/27 02:18:20 [error] 22269#0: *1 recv() failed (104: Connection reset by peer) while reading response header from upstream, client: xxx.xxx.xxx.xxx (MY IP), server : myadmin.phpmyadmintestdomain.tk, request: "GET / HTTP/1.1", upstream: "fastcgi ://127.0.0.1:9000", host: "myadmin.phpmyadmintestdomain.tk"

              Reply
          • Mosfet / October 26, 2012

            Right after submitting this message I’ve reloaded the subdomain and got this message

            phpMyAdmin – Error

            Cannot start session without errors, please check errors given in your PHP and/or webserver log file and configure your PHP installation properly.

            Reply
          • Mosfet / October 27, 2012

            On further investigation I found that PHP-FPM crashes.

            PHP-FPM error.log :
            WARNING: [pool www] child 910 exited on signal 11 (SIGSEGV) after 1027.210867 seconds from start

            Reply
  20. Mosfet / October 29, 2012

    Virtualhost: http://pastebin.com/FcWn0csJ
    php-fpm pool conf : http://pastebin.com/hkkqrhNj

    Hope I got the right files.

    Reply
    • JR / October 29, 2012

      Thanks, looks right files…could you post output of following command here:

      ls -la /var/lib/php
      Reply
  21. Mosfet / October 29, 2012

    ls -la /var/lib/php
    total 12
    drwxr-xr-x 3 root root 4096 Oct 26 05:22 .
    drwxr-xr-x 20 root root 4096 Oct 26 05:34 ..
    drwxrwx— 2 root apache 4096 Oct 18 13:08 session

    Reply
    • JR / October 29, 2012

      Okay, problem is your php session path permissions you run php-fpm as nginx:nginx (user:group) and it can’t access session storage, because it have root:apache permissions. You have two option to fix this.

      1. Change following lines on php-fpm pool conf:
      From

      ; RPM: apache Choosed to be able to access some dir as httpd
user = nginx
; RPM: Keep a group allowed to write in log dir.
group = nginx

      To:

      ; RPM: apache Choosed to be able to access some dir as httpd
user = apache
; RPM: Keep a group allowed to write in log dir.
group = apache

      Restart PHP-FPM.

      2. Change /var/lib/php/session user and group to nginx

      chown -R root:nginx /var/lib/php/session

      Or

      chown -R nginx:nginx /var/lib/php/session

      Then try again access phpMyAdmin.

      Reply
  22. Mosfet / October 31, 2012

    It works !

    Thanks for all your help and time !

    Reply
    • JR / November 1, 2012

      Excellent! :) You are welcome!

      Reply
  23. Mosfet / October 31, 2012

    It finally works ! and by that I mean submitting messages to your blog (I’ve been trying for 3 days)

    Reply
    • JR / November 1, 2012

      Really, did you got any error messages?

      Reply
  24. Peter / November 2, 2012

    Works 4 me. CENTOS 6.3

    Thank you !!!

    Reply
  25. Micahel / November 6, 2012

    Hi,
    Great tutorial, but I am having a strange issue I can not find anywhere.
    running CentOS 6.3
    Apache 2.2.15
    php 5.4.8
    MySQL 5.5.28

    when I go to http://mysite.com/phpmyadmin I get this on the screen.
    phpMyAdmin –

    I installed phpMyAdmin with Yum, following your tutorial.

    When I put phpMyAdmin in one of my websites public_html directories it works fine. I would rather have it in the /usr/shared/phpMyAdmin directory though.
    I installed SquirrelMail in the /usr/shared/squirrelmail directory, and it works as it is suppose to. I have tried a few different versions of phpMyAdmin and get the same thing.

    Doing the command curl -I http://localhost/phpmyadmin from the ssh I get this.
    [root@server ~]# curl -I http://localhost/phpmyadmin
    HTTP/1.1 301 Moved Permanently
    Date: Tue, 06 Nov 2012 14:18:31 GMT
    Server: Apache/2.2.15
    Location: http://localhost/phpmyadmin/
    Connection: close
    Content-Type: text/html; charset=iso-8859-1
    [root@server ~]#

    Any suggestions?

    Thanks,

    Reply
    • JR / November 6, 2012

      Hi Micahel,

      What you get when you try:

      curl -I http://localhost/phpmyadmin/

      Note trailing slash.

      Reply
      • Michael / November 7, 2012

        Hi,
        Okay, this is what I get.

        [root@server ~]# curl -I http://localhost/phpmyadmin/
        HTTP/1.1 200 OK
        Date: Wed, 07 Nov 2012 07:08:04 GMT
        Server: Apache/2.2.15
        X-Powered-By: PHP/5.4.8
        Set-Cookie: phpMyAdmin=r4e2ha0okkfj38m3hrv0aruaiqhmq64s; path=/phpmyadmin/; HttpOnly
        Expires: Thu, 19 Nov 1981 08:52:00 GMT
        Cache-Control: private, max-age=10800, pre-check=10800
        Last-Modified: Mon, 08 Oct 2012 15:21:21 GMT
        Set-Cookie: pma_lang=en; expires=Fri, 07-Dec-2012 07:08:04 GMT; path=/phpmyadmin/; httponly
        Set-Cookie: pma_collation_connection=utf8_general_ci; expires=Fri, 07-Dec-2012 07:08:04 GMT; path=/phpmyadmin/; httponly
        Set-Cookie: pma_mcrypt_iv=VFpjxiI5%2FHM%3D; expires=Fri, 07-Dec-2012 07:08:04 GMT; path=/phpmyadmin/; httponly
        Set-Cookie: phpMyAdmin=4rt305508u7kfvkrusubabpk0oar0k00; path=/phpmyadmin/; HttpOnly
        Connection: close
        Content-Type: text/html; charset=utf-8

        Reply
        • JR / November 7, 2012

          Okay, looks like it’s working normally from localhost, so could you post output of following command:

          cat /etc/httpd/conf.d/phpMyAdmin.conf
          Reply
          • Michael / November 7, 2012

            Hi, thanks, here is my phpMyAdmin.conf file.
            I can change it to allow all so you can see exactly what it is, or is not doing.

            # phpMyAdmin – Web based MySQL browser written in php
            #
            # Allows only localhost by default
            #
            # But allowing phpMyAdmin to anyone other than localhost should be considered
            # dangerous unless properly secured by SSL

            Alias /phpMyAdmin /usr/share/phpMyAdmin
            Alias /phpmyadmin /usr/share/phpMyAdmin

            # Apache 2.4
            Require local

            # Apache 2.2
            Order Deny,Allow
            Deny from All
            Allow from 127.0.0.1
            Allow from 72.8.251.26
            Allow from ::1

            # Apache 2.4
            Require local

            # Apache 2.2
            Order Deny,Allow
            Deny from All
            Allow from 127.0.0.1
            Allow from ::1

            # These directories do not require access over HTTP – taken from the original
            # phpMyAdmin upstream tarball
            #

            Order Deny,Allow
            Deny from All
            Allow from None

            Order Deny,Allow
            Deny from All
            Allow from None

            Order Deny,Allow
            Deny from All
            Allow from None

            # This configuration prevents mod_security at phpMyAdmin directories from
            # filtering SQL etc. This may break your mod_security implementation.
            #
            #
            #
            # SecRuleInheritance Off
            #
            #

            Reply
            • JR / November 8, 2012

              Hi Michael,

              Thanks! It should work if your external ip is that 72.8…and you have reloaded/restarted httpd after this change. Could you also check your httpd access and error logs, and check if you have something suspicious there?

              Reply
              • Michael / November 8, 2012

                Thanks for the help. I went to access it so it could be the most recent in the logs and it worked. No clue why it started working all of a sudden. I have not done anything to the server sense the last time I tried it and it did not work.

                Thanks again.

                Reply
                • JR / November 9, 2012

                  You are very welcome!

                  Nice to hear that you got it working. Hard to say what the problem was, because your configuration is right, maybe it was due the browser cache…

                  Reply
  26. Jeff / January 23, 2013

    This worked seamlessly. Had one issue with allowing external IP’s and it was answered in the comments. Much appreciated.

    Reply

Leave a Comment

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>