Differences

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

--- installing_phpmyadmin_tips [2015/11/08 13:27] – 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|Create a control user for "localhost" access]]
-  * Set password for control user
-  * [[https://wiki.phpmyadmin.net/pma/control_user#MySQL_version_4.0.2_or_newer|Grant usage rights to control user]]
-  * The following code was current as of 8 Nov 2015:
-<code>
-GRANT USAGE ON mysql.* TO 'pma'@'localhost' IDENTIFIED BY 'pmapass';
-GRANT SELECT (
-    Host, User, Select_priv, Insert_priv, Update_priv, Delete_priv,
-    Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv,
-    File_priv, Grant_priv, References_priv, Index_priv, Alter_priv,
-    Show_db_priv, Super_priv, Create_tmp_table_priv, Lock_tables_priv,
-    Execute_priv, Repl_slave_priv, Repl_client_priv
-    ) ON mysql.user TO 'pma'@'localhost';
-GRANT SELECT ON mysql.db TO 'pma'@'localhost';
-GRANT SELECT ON mysql.host TO 'pma'@'localhost';
-GRANT SELECT (Host, Db, User, Table_name, Table_priv, Column_priv)
-    ON mysql.tables_priv TO 'pma'@'localhost';
-</code>
 __Installing phpMyAdmin updates and merging configuration files__ \\