Install phpMyAdmin 4.3.10 on Fedora 21/20, CentOS/RHEL 6.6/5.11 - Comment Page: 1

This is guide, howto install phpMyAdmin 4.3.10 with Nginx or Apache on Fedora 21/20/19, CentOS 7/6.6/5.11 and Red Hat (RHEL) 7/6.6/5.11 servers. phpMyAdmin needs web server with PHP and MySQL database. This guide uses Apache web server with PHP 5.6 or Nginx web server with PHP 5.6 (PHP-FPM) and MySQL 5.6 database server or MariaDB 10/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...

120 comments on “Install phpMyAdmin 4.3.10 on Fedora 21/20, CentOS/RHEL 6.6/5.11 - Comment Page: 1

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

      Reply
      • Hi Alireza,

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

        Reply
    2. Hey JR,

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

      Reply
      • 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. 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
      • Hi again Kevin,

        Thank you for this information.

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

        
        
           order deny,allow
           deny from all
           allow from 127.0.0.1
           allow from ::1
        
        

        Add your external ips here.

        OR

        change it to:

        
        
           order deny,allow
           allow from all
        
        

        Then restart your web server and try again.

        Please let me know do you get it working?

        Reply
        • after that service httpd restart

          Reply
    4. Hey JR,

      Thanks a lot! That worked like a charm.

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

        Reply
      • 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
    5. 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…

      [[email protected] /]# 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
      [[email protected] /]#

      Reply
      • Hi marker,

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

        Reply
    6. 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
    7. 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
      • 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
        • Hi indapublic,

          Could you post output of following commands:

          
          yum list \*php\*
          
          yum --enablerepo=remi repolist
          
          Reply
          • Thanks for reply.

            [[email protected] ~]$ 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
            [[email protected] ~]$ 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
            [[email protected] ~]$

            Reply
            • 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
              • Thank you very much. It works.

                Reply
    8. 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
      • Hi ReynierPM,

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

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

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

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

      Reply
        • 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
          • Is it working from localhost?

            Reply
    11. 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
      • Hi antiwesley,

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

        Reply
        • # 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
        • 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
          • 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
            • VPS. So unless I can do it from an SSH shell.. then no.

              Reply
              • 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
                • [[email protected] /]# 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
                  • Sorry, this was my mistake, you need one extra slash (/), could you post again:

                    
                    curl -I http://localhost/phpmyadmin/
                    
                    Reply
                    • 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
                      • 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]
                        ...
                        
    12. 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
      • Good. Do you have port 80 open on your server?

        
        netstat -ntulp
        
        Reply
        • tcp        0      0 0.0.0.0:80                  0.0.0.0:*                   LISTEN      5789/httpd
          Reply
          • 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
            • 
              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
              • Could you post output of following commands:

                
                df -h
                
                free -m
                
                cat /etc/my.cnf
                
                Reply
                • [[email protected] /]# df -h
                  Filesystem            Size  Used Avail Use% Mounted on
                  /dev/simfs             10G  694M  9.4G   7% /
                  [[email protected] /]#
                  [[email protected] /]# free -m
                               total       used       free     shared    buffers     cached
                  Mem:           256         63        192          0          0          0
                  -/+ buffers/cache:         63        192
                  Swap:            0          0          0
                  [[email protected] /]#
                  [[email protected] /]# 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
                  • 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
                    • 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
                      • Okay, sounds good. :)

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

                        
                        
                           
                             # Apache 2.4
                             Require local
                           
                           
                             # Apache 2.2
                             Order Allow,Deny
                             Allow from All
                           
                        
                        

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

1 2 3

Leave a Reply to Isabella Cancel reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Close