Christopher Juckins

SysAdmin Tips, Tricks and other Software Tools

User Tools

Site Tools


installing_phpmyadmin_tips

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
installing_phpmyadmin_tips [2016/05/20 20:28] juckinsinstalling_phpmyadmin_tips [2022/01/24 14:08] (current) juckins
Line 1: Line 1:
 ==== Installing phpMyAdmin Tips ==== ==== 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   * Ensure mysql/mariadb installation has been secured
   * Download, unpack, install from http://www.phpmyadmin.net/home_page/index.php   * Download, unpack, install from http://www.phpmyadmin.net/home_page/index.php
Line 11: Line 11:
  
   * 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]]   * 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]]
 +    * Instructions above are now missing
 +    * 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.  
  
-  * Create control user/password as defined in config.inc.php and set access for "localhost" +  * <del>Create control user/password as defined in config.inc.php and set access for "localhost"</del> 
-  * As root, grant privileges to control user: +  * <del>As root, grant privileges to control user:</del> 
-  * GRANT SELECT, INSERT, UPDATE, DELETE ON <pma_db>.* TO 'pma'@'localhost'  IDENTIFIED BY 'pmapass'; +  * <del>GRANT SELECT, INSERT, UPDATE, DELETE ON <pma_db>.* TO 'pma'@'localhost'  IDENTIFIED BY 'pmapass';</del> 
-  * pma_db defined in config.inc.php+  * <del>pma_db defined in config.inc.php</del>
   * Follow instructions and run script in <PHPMYADMIN_ROOT>/sql/create_tables.sql   * Follow instructions and run script in <PHPMYADMIN_ROOT>/sql/create_tables.sql
 +    * Can be done at the command line
 +      * cd to <PHPMYADMIN_ROOT>/examples/
 +      * As root: mysql -uroot -p <./create_tables.sql
   * Logout, log back into phpMyAdmin to see new database and tables   * Logout, log back into phpMyAdmin to see new database and tables
  
installing_phpmyadmin_tips.1463790487.txt.gz · Last modified: 2016/05/20 20:28 by juckins