Differences

This shows you the differences between two versions of the page.

--- installing_phpmyadmin_tips [2012/04/20 15:16] – juckins
+++ installing_phpmyadmin_tips [2022/01/24 14:08] (current) – juckins
@@ Line 1: / Line 1: @@
-__Installing mcrypt for php__
+==== Installing phpMyAdmin Tips ====
-. Download, unpack, install from http://www.phpmyadmin.net/home_page/index.php \\
+  * Ensure php-mcrypt, libmcrypt, php-mbstring, php-pear-MDB2-Driver-mysqli.noarch are installed and httpd service restarted
-. Create symbolic link to phpmy \\
+  * Ensure mysql/mariadb installation has been secured
-. cd to phpmy and load up config.inc.php \\
+  * Download, unpack, install from http://www.phpmyadmin.net/home_page/index.php
-. login to web interface
+  * Create symbolic link to phpmy
-. Make sure to set mysql server root password. \\
+  * cd to phpmy and set up config.inc.php
-. Load mcrypt extension with the following (or higher):
+  * Login to web interface as user root
-   libmcrypt-2.5.8-4.fc8.i386.rpm
-   php-mcrypt-5.1.6-1.fc5.i386.rpm
-. Remember that you might need 64-bit versions of the RPMs, such as: \\
+Enable special tables
-   libmcrypt-2.5.8-5.fc9.x86_64.rpm
-   php-mcrypt-5.1.6-4.el5.x86_64.rpm
-. RPMs can be found at: \\
+  * Run SQL as shown in the section "MySQL version 4.0.2 or newer" on [[http://wiki.phpmyadmin.net/pma/control_user|configure Control User]]
-[[http://rpm.pbone.net|rpm.pbone.net]] \\
+    * Instructions above are now missing
-[[http://www.rpmfind.net|www.rpmfind.net]]
+    * Login to the older server's phpmyadmin as root and go to User accounts.  Find the control user and export it.  Take that code and paste it into the SQL box on the server's phpmyadmin page.
+    * Repeat step above for user pma.
-__Installing mbstring__ \\
+  * <del>Create control user/password as defined in config.inc.php and set access for "localhost"</del>
-\\
+  * <del>As root, grant privileges to control user:</del>
-Ensure that php-mbstring RPM is installed.\\
+  * <del>GRANT SELECT, INSERT, UPDATE, DELETE ON <pma_db>.* TO 'pma'@'localhost'  IDENTIFIED BY 'pmapass';</del>
-Restart httpd server.
+  * <del>pma_db defined in config.inc.php</del>
+  * Follow instructions and run script in <PHPMYADMIN_ROOT>/sql/create_tables.sql
-__Enabling Linked Tables in phpMyAdmin__ \\
+    * Can be done at the command line
-\\
+      * cd to <PHPMYADMIN_ROOT>/examples/
-[[http://www.psoft.net/HSdocumentation/sysadmin/phpmyadmin_linked_tables.html]]
+      * As root: mysql -uroot -p <./create_tables.sql
+  * Logout, log back into phpMyAdmin to see new database and tables
-Special Tables / Control User
-[[http://wiki.phpmyadmin.net/pma/control_user
-]]
 __Installing phpMyAdmin updates and merging configuration files__ \\
@@ Line 60: / Line 53: @@
 . 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).
-. cp config.sample.inc.php config.inc.CJ.LATEST_RELEASE_ID.currentYYYYMMDD.php
+. cp config.sample.inc.php config.sample.inc.LATEST_RELEASE_ID.php
+. 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.
+. do a diff on the latest version and current working version of config.sample.inc.php.  note any differences.
-. cp -p config.inc.CJ.WORKING_RELEASE_ID.currentYYYYMMDD.php from the current working phpmyadmin directory to the current latest release directory.
+. cp -p the current working version of config.inc.php into the latest directory.
-. diff config.inc.CJ.WORKING_RELEASE_ID.currentYYYYMMDD.php config.inc.CJ.LATEST_RELEASE_ID.currentYYYYMMDD.php > diff.txt
+. make a copy of the file you just copied in and rename it to the latest version
-. vi diff.txt and look for any changes that need to be merged from the current configuration file into the new configuration file.
+. merge in any differences noted in step 7.
-. When finished merging the changes, cp -p config.inc.CJ.LATEST_RELEASE_ID.currentYYYYMMDD.php config.inc.php
+. When finished merging the changes, cp -p the file to config.inc.php
 . cd to the webserver root directory and point phpmy to latest phpMyAdmin release with a symbolic link:
 <code>
@@ Line 76: / Line 73: @@
 </code>
 . 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__