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

Updated on February 26, 2015 by JR 120 comments

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...

See full post →

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

1 2 3 Next »

Alireza
28th February 2012, 2:16 am

I did all the instructions completely..even edited php.ini file in (/etc/php.ini)..but I see frequently html error 500
Reply
- JR
  28th February 2012, 9:18 am
  
  Hi Alireza,
  
  Do you use Nginx or Apache?
  Do you get error 500 all the time or does phpMyAdmin work occasionally?
  Reply
Kevin Cheathem
21st March 2012, 11:10 pm

Hey JR,

I received a 403 error when attempting to connect to phpmyadmin.
Reply
- JR
  22nd March 2012, 9:36 am
  
  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
Kevin Cheathem
22nd March 2012, 2:27 pm

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
  23rd March 2012, 9:10 am
  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
  - pouya
    18th September 2012, 2:17 pm
    
    after that service httpd restart
    Reply
Kevin Cheathem
23rd March 2012, 10:27 am

Hey JR,

Thanks a lot! That worked like a charm.
Reply
- JR
  23rd March 2012, 11:57 am
  
  You are very welcome! Nice to hear that it worked. :)
  Reply

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

Please advice. :)

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… :)

marker
5th June 2012, 6:26 pm

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
- JR
  6th June 2012, 7:30 pm
  
  Hi marker,
  
  Do you have network connection working normally? Could you just try again?
  Reply
indapublic
28th July 2012, 4:09 pm

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
indapublic
28th July 2012, 4:15 pm

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
  28th July 2012, 4:35 pm
  
  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
    29th July 2012, 7:15 pm
    Hi indapublic,
    
    Could you post output of following commands:
    
    yum list \*php\* yum --enablerepo=remi repolist
    Reply
    - indapublic
      30th July 2012, 3:25 am
      
      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
      - JR
        30th July 2012, 8:44 am
        
        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
        30th July 2012, 9:53 am
        
        Thank you very much. It works.
        Reply
        
        JR
        30th July 2012, 9:57 am
        
        You are welcome! :)
        Reply
ReynierPM
8th August 2012, 3:27 pm

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
- indapublic
  8th August 2012, 3:44 pm
  
  httpd.conf?
  Reply
ReynierPM
8th August 2012, 3:47 pm

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
  8th August 2012, 8:45 pm
  
  Hi ReynierPM,
  
  Could you post /etc/httpd/conf.d/phpMyAdmin.conf file content?
  Reply
indapublic
8th August 2012, 9:02 pm

I think, php is not installed corrrectly. Directoryindex section not contain php extension in httpd.conf
Reply
- JR
  8th August 2012, 9:46 pm
  
  I think that the problem might be phpMyAdmin virtual host and server name configuration.
  Reply
ReynierPM
8th August 2012, 10:23 pm

@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
- JR
  8th August 2012, 11:05 pm
  
  Thanks! Try to go http://localhost/phpMyAdmin (or http://localhost/phpmyadmin) with your browser, is it working then?
  Reply
ReynierPM
8th August 2012, 11:31 pm

This is not at localhost is on another PC and if I yes I can access
Reply
- JR
  9th August 2012, 12:16 am
  
  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
    20th August 2012, 12:55 am
    
    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
      20th August 2012, 11:08 am
      
      Is it working from localhost?
      Reply
antiwesley
14th August 2012, 1:26 pm

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
  15th August 2012, 10:51 pm
  
  Hi antiwesley,
  
  Could you post full content of /etc/httpd/conf.d/phpMyAdmin.conf file?
  Reply
  - antiwesley
    16th August 2012, 5:24 am
    
    # 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
    16th August 2012, 5:34 am
    
    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
      16th August 2012, 9:50 am
      
      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
        17th August 2012, 8:41 am
        
        VPS. So unless I can do it from an SSH shell.. then no.
        Reply
        
        JR
        17th August 2012, 9:14 pm
        
        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
        21st August 2012, 5:41 am
        
        [[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
        
        JR
        21st August 2012, 1:54 pm
        
        Sorry, this was my mistake, you need one extra slash (/), could you post again:
        
        curl -I http://localhost/phpmyadmin/
        Reply
        
        antiwesley
        22nd August 2012, 8:07 am
        
        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
        22nd August 2012, 9:41 am
        
        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] ...

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. :(

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


netstat -ntulp

tcp        0      0 0.0.0.0:80                  0.0.0.0:*                   LISTEN      5789/httpd

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.


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

Could you post output of following commands:


df -h

free -m

cat /etc/my.cnf

[[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

JR
23rd August 2012, 8:54 am
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
  24th August 2012, 12:34 am
  
  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
    24th August 2012, 2:15 pm
    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 Next »

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

Leave a Reply Cancel reply