Differences

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

--- installing_phpmyadmin_tips [2015/11/08 13:36] – juckins
+++ installing_phpmyadmin_tips [2022/01/24 14:08] (current) – juckins
@@ Line 1: / Line 1: @@
-__Installing mcrypt for php__
+==== Installing phpMyAdmin Tips ====
-  * Ensure php-mcrypt, libmcrypt, php-mbstring are installed and httpd service restarted
+  * Ensure php-mcrypt, libmcrypt, php-mbstring, php-pear-MDB2-Driver-mysqli.noarch are installed and httpd service restarted
   * Ensure mysql/mariadb installation has been secured
   * Download, unpack, install from http://www.phpmyadmin.net/home_page/index.php
@@ Line 8: / Line 8: @@
   * Login to web interface as user root
-Enable special tables / configure Control User
+Enable special tables
-  * [[http://wiki.phpmyadmin.net/pma/control_user|Create a control user for "localhost" access]]
+  * 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]]
-  * Set password for control user
+    * Instructions above are now missing
-  * [[https://wiki.phpmyadmin.net/pma/control_user#MySQL_version_4.0.2_or_newer|Grant usage rights to control user]]
+    * 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.
-  * The following code was current as of 8 Nov 2015:
+    * Repeat step above for user pma.
-<code>
+  * <del>Create control user/password as defined in config.inc.php and set access for "localhost"</del>
-GRANT USAGE ON mysql.* TO 'pma'@'localhost' IDENTIFIED BY 'pmapass';
+  * <del>As root, grant privileges to control user:</del>
-GRANT SELECT (
+  * <del>GRANT SELECT, INSERT, UPDATE, DELETE ON <pma_db>.* TO 'pma'@'localhost'  IDENTIFIED BY 'pmapass';</del>
-    Host, User, Select_priv, Insert_priv, Update_priv, Delete_priv,
+  * <del>pma_db defined in config.inc.php</del>
-    Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv,
+  * Follow instructions and run script in <PHPMYADMIN_ROOT>/sql/create_tables.sql
-    File_priv, Grant_priv, References_priv, Index_priv, Alter_priv,
+    * Can be done at the command line
-    Show_db_priv, Super_priv, Create_tmp_table_priv, Lock_tables_priv,
+      * cd to <PHPMYADMIN_ROOT>/examples/
-    Execute_priv, Repl_slave_priv, Repl_client_priv
+      * As root: mysql -uroot -p <./create_tables.sql
-    ) ON mysql.user TO 'pma'@'localhost';
+  * Logout, log back into phpMyAdmin to see new database and tables
-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>
-Finally, follow instructions and run script in <PHPMYADMIN_ROOT>/sql/create_tables.sql
 __Installing phpMyAdmin updates and merging configuration files__ \\