phpMyAdmin upgrade process

Note:
As of March 22, 2018, phpMyAdmin is no longer supported. Instead, use MySQL Workbench. As a result of the PHP upgrade to 7.1, you may be unable to access phpMyAdmin. For a temporary fix, use your .htaccess file to force your site to load using PHP 5.6. This fix will work only until PHP 5.6 is removed from Webserve on December 17, 2018.

Below are instructions for upgrading to the current version of phpMyAdmin (3.3.3) on Webserve from an older existing version. The upgrade process will:

  • Rename the existing phpmyadmin directory to old_phpmyadmin before creating a new directory with the upgraded version. This allows you to revert to the previous version if you experience any issues after the upgrade.
  • Copy the existing .htaccess file used to restrict access to the phpMyAdmin application into the directory with the upgraded version so that authentication to the application will remain unchanged
  • Copy the first three connection blocks in the config.inc.php4 file to the new config.inc.php file; if you have more than three connections currently set up in config.inc.php4, you will need to copy those over manually.
  • Create a new phpMyAdmin directory (named phpMyAdmin-3.3.3-all-languages) with the upgraded version of the application
  • Create a symbolic link for this new directory (named phpmyadmin) so that the URL used to access the application will remain unchanged; this will also permit UITS to perform future upgrades easily.

To updgrade the version of phpMyAdmin:

  1. Log into your account using an SSH client such as PuTTY.
  2. Move into the directory where your phpmyadmin directory is located. For example, if you have a phpmyadmin directory inside your wwws directory you would move into the wwws directory by typing cd wwws.
  3. To install the most recent version of phpMyAdmin available on Webserve, type install_phpmyadmin.

The above command, when run in a directory with no phpmyadmin directory, will result in a completely new installation of phpMyAdmin. For new installations, the config.inc.php file will be blank, and a new .htaccess file will be installed. This will restrict access to the account name only. Blocks that have been commented out begin with //. To use these blocks, after you have added the connection information, remove the // at the start of each line in order to establish a connection.

This is document bfpc in the Knowledge Base.
Last modified on 2018-04-16 07:56:16.

Contact us

For help or to comment, email the UITS Support Center.