ARCHIVED: phpMyAdmin upgrade process

This content has been archived, and is no longer maintained by Indiana University. Information here may no longer be accurate, and links may no longer be available or reliable.

Note:

Due to the evolving coronavirus situation, the retirement of Webserve was delayed until April 16 to allow classes that reference sites on Webserve to continue with minimal disruption.

All remaining Webserve sites were disabled beginning April 16, along with login access to webserve.iu.edu. If you have websites that still need to be moved to IU Sitehosting, you should migrate immediately.

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:

Log into your account using an SSH client such as ARCHIVED: PuTTY.
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.
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.