installing_phpmyadmin_tips
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionLast revisionBoth sides next revision | ||
installing_phpmyadmin_tips [2012/04/20 15:16] – juckins | installing_phpmyadmin_tips [2017/08/31 16:43] – juckins | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | __Installing mcrypt for php__ | + | ==== Installing phpMyAdmin Tips ==== |
- | 1. Download, unpack, install from http:// | + | * Ensure php-mcrypt, libmcrypt, php-mbstring, |
- | 2. Create symbolic link to phpmy \\ | + | * Ensure mysql/ |
- | 3. cd to phpmy and load up config.inc.php | + | * Download, unpack, install from http:// |
- | 4. login to web interface | + | |
- | 5. Make sure to set mysql server | + | |
- | 6. Load mcrypt extension with the following (or higher): | + | * Login to web interface |
- | | + | |
- | | + | |
- | 7. Remember that you might need 64-bit versions of the RPMs, such as: \\ | + | Enable special tables |
- | | + | |
- | | + | |
- | 8. RPMs can be found at: \\ | + | * Run SQL as shown in the section "MySQL version 4.0.2 or newer" on [[http://wiki.phpmyadmin.net/ |
- | [[http://rpm.pbone.net|rpm.pbone.net]] \\ | + | * Instructions above are now missing |
- | [[http:// | + | * Login to the older server' |
+ | * Repeat step above for user pma. | ||
- | __Installing mbstring__ \\ | + | * < |
- | \\ | + | * < |
- | Ensure that php-mbstring RPM is installed.\\ | + | * < |
- | Restart httpd server. | + | * < |
- | + | * Follow instructions and run script in < | |
- | __Enabling Linked Tables in phpMyAdmin__ \\ | + | * Can be done at the command line |
- | \\ | + | * cd to < |
- | [[http://www.psoft.net/HSdocumentation/sysadmin/phpmyadmin_linked_tables.html]] | + | * As root: mysql -uroot -p <./ |
- | + | * Logout, log back into phpMyAdmin to see new database and tables | |
- | Special Tables | + | |
- | + | ||
- | [[http://wiki.phpmyadmin.net/ | + | |
- | ]] | + | |
__Installing phpMyAdmin updates and merging configuration files__ \\ | __Installing phpMyAdmin updates and merging configuration files__ \\ | ||
Line 60: | Line 53: | ||
4. cd to the latest release directory which is named phpMyAdmin-LATEST_RELEASE_ID-english. | 4. cd to the latest release directory which is named phpMyAdmin-LATEST_RELEASE_ID-english. | ||
- | 5. cp config.sample.inc.php config.inc.CJ.LATEST_RELEASE_ID.currentYYYYMMDD.php | + | 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. | ||
- | 6. cp -p config.inc.CJ.WORKING_RELEASE_ID.currentYYYYMMDD.php from the current working phpmyadmin directory to the current | + | 8. cp -p the current working version of config.inc.php |
- | 7. diff config.inc.CJ.WORKING_RELEASE_ID.currentYYYYMMDD.php config.inc.CJ.LATEST_RELEASE_ID.currentYYYYMMDD.php > diff.txt | + | 9. make a copy of the file you just copied in and rename it to the latest version |
- | 8. vi diff.txt and look for any changes that need to be merged from the current configuration file into the new configuration file. | + | 10. merge in any differences noted in step 7. |
- | 9. When finished merging the changes, cp -p config.inc.CJ.LATEST_RELEASE_ID.currentYYYYMMDD.php | + | 11. When finished merging the changes, cp -p the file to config.inc.php |
- | 9. cd to the webserver root directory and point phpmy to latest phpMyAdmin release with a symbolic link: | + | 12. cd to the webserver root directory and point phpmy to latest phpMyAdmin release with a symbolic link: |
< | < | ||
Line 76: | Line 73: | ||
</ | </ | ||
- | 10. Login to the phpMyAdmin webpage as root and verify everything is working properly. | + | 13. Login to the phpMyAdmin webpage as root and verify everything is working properly. |
__Some old notes__ | __Some old notes__ |
installing_phpmyadmin_tips.txt · Last modified: 2022/01/24 14:08 by juckins