Christopher Juckins

SysAdmin Tips, Tricks and other Software Tools

User Tools

Site Tools


installing_phpmyadmin_tips

This is an old revision of the document!


Installing mcrypt for php

1. Download, unpack, install from http://www.phpmyadmin.net/home_page/index.php
2. Create symbolic link to phpmy
3. cd to phpmy and load up config.inc.php
4. login to web interface 5. Make sure to set mysql server root password.
6. Load mcrypt extension with the following (or higher):

 libmcrypt-2.5.8-4.fc8.i386.rpm
 php-mcrypt-5.1.6-1.fc5.i386.rpm

7. Remember that you might need 64-bit versions of the RPMs, such as:

 libmcrypt-2.5.8-5.fc9.x86_64.rpm 
 php-mcrypt-5.1.6-4.el5.x86_64.rpm

8. RPMs can be found at:
rpm.pbone.net
www.rpmfind.net

Installing mbstring

Ensure that php-mbstring RPM is installed.
Restart httpd server.

Enabling Linked Tables in phpMyAdmin

http://www.psoft.net/HSdocumentation/sysadmin/phpmyadmin_linked_tables.html

Special Tables / Control User

http://wiki.phpmyadmin.net/pma/control_user

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.
installing_phpmyadmin_tips.1342992696.txt.gz · Last modified: 2012/07/22 17:31 by juckins