Differences

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

--- installing_phpmyadmin_tips [2012/04/20 15:06] – 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 -p config.inc.CJ.WORKING_RELEASE_ID.currentYYYYMMDD.php from the current working phpmyadmin directory.
+. 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 the current working version of config.inc.php into the latest directory.
-. cp config.inc.CJ.WORKING_RELEASE_ID.currentYYYYMMDD.php config.inc.CJ.LATEST_RELEASE_ID.currentYYYYMMDD.php
+. make a copy of the file you just copied in and rename it to the latest version
-. Make the necessary edits to config.inc.CJ.LATEST_RELEASE_ID.currentYYYYMMDD.php so they contain the edits found in config.inc.CJ.WORKING_RELEASE_ID.currentYYYYMMDD.php
+. merge in any differences noted in step 7.
-. cp config.inc.CJ.LATEST_RELEASE_ID.currentYYYYMMDD.php config.inc.php
+. When finished merging the changes, cp -p the file to config.inc.php
-. Point to latest phpMyAdmin release with a symbolic link:
+. cd to the webserver root directory and point phpmy to latest phpMyAdmin release with a symbolic link:
 <code>
@@ Line 74: / Line 73: @@
 </code>
-. Access phpMyAdmin 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).
+. 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__