phpMyAdmin & Nginx to Maintain Databases: VPS BIBLE

Got a Question? Want to Comment?

This site has no comments system. We've got a better system!

Please use the link at the top of the post and goto this topic's forum thread:-

• to help build community
• for a superior knowledge base
• to keep info in one place, not diluted between forum & comments.

For those posts ported from Guvnr.com (pre-Feb/2010), archive comments remain.

Handy info from these comments is in the process of being ported to the forum and attributed to the original author.

If you think this idea sucks, let me know.

Thank you.

• Use phpMyAdmin & Nginx to Maintain Databases - VPS CARE #5 - GUVNR | Green Web hosting July 14th, 2009 at 2:05 pm

  [...] original post here: Use phpMyAdmin & Nginx to Maintain Databases – VPS CARE #5 – GUVNR Top 5 Green Web Hosting Companies, Click [...]

• Use phpMyAdmin & Nginx to Maintain Databases - VPS CARE #5 - GUVNR : evaluehost.com July 14th, 2009 at 2:18 pm

  [...] More here: Use phpMyAdmin & Nginx to Maintain Databases – VPS CARE #5 – GUVNR [...]

• Use phpMyAdmin & Nginx to Maintain Databases - VPS CARE #5 - GUVNR : tntwebhostings.com July 14th, 2009 at 2:44 pm

  [...] See the article here: Use phpMyAdmin & Nginx to Maintain Databases – VPS CARE #5 – GUVNR [...]

• Use phpMyAdmin & Nginx to Maintain Databases - VPS CARE #5 - GUVNR : hostingwebsitereviews.com July 14th, 2009 at 3:45 pm

  [...] Continued here: Use phpMyAdmin & Nginx to Maintain Databases – VPS CARE #5 – GUVNR [...]

• Use phpMyAdmin & Nginx to Maintain Databases - VPS CARE #5 - GUVNR : websiteshostingreviews.com July 14th, 2009 at 4:08 pm

  [...] More here: Use phpMyAdmin & Nginx to Maintain Databases – VPS CARE #5 – GUVNR [...]

• Mattew September 22nd, 2009 at 6:54 pm

  Hi Guvnr,
  thank you for this usful article. Everythig works, but I can’t get phpmyadmin work in SSL mode. Maybe you have any suggestions?

• Mattew September 22nd, 2009 at 7:28 pm

  I did it!
  here is my config /usr/local/nginx/sites-available/phpmyadmin
  server {

  listen 443;
  server_name phpmyadmin.domain.com;
  access_log /home/public_html/domain.com/log/phpmyadmin.access.log;
  error_log /home/public_html/domain.com/log/phpmyadmin.error.log;
  ssl on;
  ssl_certificate /usr/local/nginx/conf/server.crt;
  ssl_certificate_key /usr/local/nginx/conf/server.key;

  location / {
  root /usr/share/phpmyadmin;
  index index.php;
  }

  # pass the PHP scripts to FastCGI server listening on 127.0.0.1:9000
  #
  location ~ \.php$
  {
  fastcgi_param HTTPS on;
  fastcgi_pass 127.0.0.1:9000;
  fastcgi_index index.php;
  include /usr/local/nginx/conf/fastcgi_params;
  fastcgi_param SCRIPT_FILENAME /usr/share/phpmyadmin$fastcgi_script_name;
  }

  *Note that there must be generated certificates:
  Generate Certificates

  To generate dummy certficates you can do this steps:

  $ cd /usr/local/nginx/conf
  $ openssl genrsa -des3 -out server.key 1024
  $ openssl req -new -key server.key -out server.csr
  $ cp server.key server.key.org
  $ openssl rsa -in server.key.org -out server.key
  $ openssl x509 -req -days 365 -in server.csr -signkey server.key -out server.crt

  More info – http://wiki.nginx.org/NginxHttpSslModule

• the_guv September 23rd, 2009 at 10:20 am

  @Mattew .. big cheers m8 .. that is gonna be mighty handy for some folks out there. Good of you to come back and post that.

• Joey September 27th, 2009 at 7:25 am

  do you know how to have phpmyadmin listen on 127.0.0.1:80 and then use ssh to access it. I heard that otherwise it is a security risk if somebody tries to brute force the password?

• the_guv October 6th, 2009 at 6:49 am

  @Joey .. hmmn .. never tried it, but what a good idea. then again, doesn’t that defeat teh object of having it in the first place?! all it is is a GUI for what you’d do with ssh anyhow, er, no? one thing i do do is to strap PMA onto a pretty irrelevant, parked, site on the vps, rather than in an obvious place like http://www.hackmyPMAplease.guvnr.com. Change the name too .. you can call it whatever you like, alpha-numerically .. so effectively that gives you a second password. (problem is, for the life of me, i can’t remember what mine’s called ..)

• Alborz December 9th, 2009 at 7:51 am

  I faced a problem, phpmyadmin gave me ‘blowfish_secret’ error.
  To solve this error:

  Go here:
  /var/lib/phpmyadmin/blowfish_secret.inc.php

  Copy the line:
  $cfg['blowfish_secret'] = ‘your hash here’;

  Paste that line at the end of:
  /etc/phpmyadmin/config.inc.php

• Install/Upgrade WORDPRESS with SUBVERSION: VPS BIBLE - vpsBible February 10th, 2010 at 4:59 pm

  [...] If you’d prefer to relocate select data, there’s always phpMyAdmin. [...]

• the_guv March 5th, 2010 at 6:13 am

  Tx to a cracking plugin to sync the bbPress forum to WP comments .. comments are open now.

  Post here and your comment is automatically posted in the relevant forum. Post there and vice-versa.

  Comments below here have been imported from Guvnr. Bit of a timeline gap so apologies for that.

  (Big cheers to Bobrik for wordpress-bbpress-syncronization.)

• the_guv March 5th, 2010 at 6:15 am

  test!

• the_guv March 5th, 2010 at 6:48 am

  test from bbPress