Differences

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

--- installing_phpmyadmin_tips [2015/11/08 12:23] – 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
-  * Follow instructions and run script in <phpmyadmin_folder>/sql/create_tables.sql
-  * [[http://wiki.phpmyadmin.net/pma/control_user]]
 __Installing phpMyAdmin updates and merging configuration files__ \\