Enable special tables
Installing phpMyAdmin updates and merging configuration files
1. diff /current/phpmyadmin/config.sample.inc.php /new/phpmyadmin/config.sample.inc.php
2. Take note of new or changed entries in the latest configuration file; some may be commented out.
Example of diff:
diff /var/www/html/phpMyAdmin-X.1-english/config.sample.inc.php config.sample.inc.php 10c10 < * @package phpMyAdmin --- > * @package PhpMyAdmin 17c17 < $cfg['blowfish_secret'] = ''; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */ --- > $cfg['blowfish_secret'] = 'ABCDEFG'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */ 42a43 > // $cfg['Servers'][$i]['controlhost'] = ''; 54a56 > // $cfg['Servers'][$i]['table_uiprefs'] = 'pma_table_uiprefs'; 57a60,61 > // $cfg['Servers'][$i]['recent'] = 'pma_recent'; > // $cfg['Servers'][$i]['table_uiprefs'] = 'pma_table_uiprefs';
4. cd to the latest release directory which is named phpMyAdmin-LATEST_RELEASE_ID-english. This should have been created when you untarred the install file. Do an ll *inc* to see the files you will be working with (should only be one right now).
5. cp config.sample.inc.php config.sample.inc.LATEST_RELEASE_ID.php
6. From the current working version phpMyAdmin directory, cp -p config.sample.inc.php to the latest release directory but name the file with the appropriate version number.
7. do a diff on the latest version and current working version of config.sample.inc.php. note any differences.
8. cp -p the current working version of config.inc.php into the latest directory.
9. make a copy of the file you just copied in and rename it to the latest version
10. merge in any differences noted in step 7.
11. When finished merging the changes, cp -p the file to config.inc.php
12. cd to the webserver root directory and point phpmy to latest phpMyAdmin release with a symbolic link:
ln -s phpMyAdmin-LATEST_RELEASE_ID-english phpmy
13. Login to the phpMyAdmin webpage as root and verify everything is working properly. If there are problems, check the documentation that is provided at the bottom of the main login page. Some scripts are also found in the installation “examples” directory that can be run (usually as user root, on a particular database).
Some old notes
< // NOTES FOR SETTING UP RELATIONAL TABLES: < // http://www.psoft.net/HSdocumentation/sysadmin/phpmyadmin_linked_tables.html < // create control user and password < // then go into phpmyadmin and edit their privileges for the mysql/user and mysql/db < // tables as directed below < // < // Adding new users < // http://dev.mysql.com/doc/refman/4.1/en/adding-users.html < // < // When importing a database, you may need to edit /etc/php.ini to allow large files < // to be uploaded into the web server. Then restart httpd.