How To Install phpMyAdmin On Windows 7

phpmyadmin

Step by step manual installation :

  1. Install phpMyAdmin.
Installation phpMyAdmin
  1. Extract the zip archive (example : phpMyAdmin-3.4.7.1-all-languages.zip) to “.DnDAMPP Apache2.2htdocs” directory under drive “C:” (example : “C:DnDAMPPApache2.2htdocs”). See the below image :
    clip_image002
  2. Rename the “phpMyAdmin-3.4.7.1-all-languages” directory to “phpmyadmin”.
    clip_image003clip_image004
  3. Now open “httpd.conf” file in “C:DnDAMPPApache2.2conf” directory
    • Find these lines :
      <IfModule dir_module>
         DirectoryIndex index.html
      </IfModule>
    • Add “index.php” after the “index.html“ and it looks like this :
      <IfModule dir_module>
         DirectoryIndex index.html index.html.var index.php
      </IfModule>
    • In the last line, add the following :
      <IfModule mod_alias.c>
         Alias /phpMyAdmin "C:/DnDAMPP/Apache2.2/htdocs/phpMyAdmin"
      </IfModule>
      <Directory "C:/DnDAMPP/Apache2.2/htdocs/phpMyAdmin">
         Options None
         AllowOverride None
         order deny,allow
         deny from all
         allow from 127.0.0.1
      </Directory>
  4. Restart your apache server.
  5. The next step open your favorite browser and type “ http://localhost/phpmyadmin ” in the address bar and press the button enter on the keyboard. If you will see the below page, then your phpMyAdmin works fine.

     

    clip_image006

     

  6. If you can access phpMyAdmin, type your username and password in dialog “Log in” and click the button “Go”. You should see a window that looks like this :

     

    clip_image008

     

  7. Please go to bottom page, you can see message which states the configuration has not been completed.

     

    clip_image010
Configure phpMyAdmin
  1. Edit phpMyAdmin’s default configuration “config.sample.inc.php“ file in “C:DnDAMPPApache2.2htdocsphpMyAdmin” directory, rename it to “config.inc.php”.
  2. Copy this code and replace your “config.inc.php” configuration.
    <?php
    /*
    * This is needed for cookie based authentication to encrypt password in
    * cookie
    */
    $cfg['blowfish_secret'] = 'dnd'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */
    
    /*
    * Servers configuration
    */
    $i = 0;
    $cfg['PmaAbsoluteUri_DisableWarning'] = FALSE;
    
    /*
    * First server
    */
    $i++;
    
    /* Authentication type */
    
    $cfg['Servers'][$i]['auth_type'] = 'cookie';
    
    /* Server parameters */
    $cfg['Servers'][$i]['host'] = 'localhost';
    $cfg['Servers'][$i]['connect_type'] = 'tcp';
    $cfg['Servers'][$i]['compress'] = false;
    
    /* Authentication type and info */
    $cfg['Servers'][$i]['auth_type'] = 'http';
    $cfg['Servers'][$i]['auth_type'] = 'config';
    $cfg['Servers'][$i]['user'] = 'root';
    $cfg['Servers'][$i]['password'] = '[Your Password]';
    $cfg['Servers'][$i]['auth_type'] = 'config';
    
    /* Select mysqli if your server has it */
    $cfg['Servers'][$i]['extension'] = 'mysql';
    $cfg['Servers'][$i]['AllowNoPassword'] = false;
    
    /*
    * phpMyAdmin configuration storage settings.
    */
    
    /* User used to manipulate with storage */
    $cfg['Servers'][$i]['auth_type'] = 'http';
    $cfg['Servers'][$i]['user'] = '';
    $cfg['Servers'][$i]['password'] = '';
    $cfg['Servers'][$i]['controluser'] = 'pma';
    $cfg['Servers'][$i]['controlpass'] = 'pmapass';
    
    /* Storage database and tables */
    $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
    $cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
    $cfg['Servers'][$i]['relation'] = 'pma_relation';
    $cfg['Servers'][$i]['table_info'] = 'pma_table_info';
    $cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';
    $cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';
    $cfg['Servers'][$i]['column_info'] = 'pma_column_info';
    $cfg['Servers'][$i]['history'] = 'pma_history';
    $cfg['Servers'][$i]['tracking'] = 'pma_tracking';
    $cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';
    $cfg['Servers'][$i]['userconfig'] = 'pma_userconfig';
    
    /* Contrib / Swekey authentication */
    // $cfg['Servers'][$i]['auth_swekey_config'] = '/etc/swekey-pma.conf';
    
    /*
    * End of servers configuration
    */
    
    /*
    * Directories for saving/loading files from server
    */
    $cfg['UploadDir'] = '';
    $cfg['SaveDir'] = '';
    
    ?>
    Note :
    • $cfg[‘Servers’][$i][‘password’] = ‘[Your Password]’;
    • [Your Password] à replace your password to access MySQL.
  3. Next step, Create MySQL’s phpMyAdmin controluser user ‘pma@localhost’ with password ‘pmapass’, with the proper permissions set.
    • Open MySQL Command Line Client Go to Start Menu à All Programs à MySQL à MySql Server 5.5 à MySQL 5.5 Command Line Client.
    • If you have seen window “MySQL 5.5 Command Line Client”, type your password in dialog “Enter password” and press the button enter on the keyboard.
    • And then Run this SQL code one by one :
      mysql> GRANT USAGE ON mysql.* TO 'pma'@'localhost' IDENTIFIED BY 'pmapass';
      mysql> 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';
      mysql> GRANT SELECT ON mysql.db TO 'pma'@'localhost';
      mysql> GRANT SELECT ON mysql.host TO 'pma'@'localhost';
      mysql> GRANT SELECT (Host, Db, User, Table_name, Table_priv, Column_priv) ON mysql.tables_priv TO 'pma'@'localhost';
    • Run phpMyAdmin’s sql script file ‘create_tables.sql’ and then grant permissions.
      mysql> source C:wwwphpMyAdminscriptscreate_tables.sql
      mysql> GRANT SELECT, INSERT, UPDATE, DELETE ON phpmyadmin.* TO 'pma'@'localhost';
      mysql> quit
  4. After completion of your configuration, please logout from phpmyadmin and login again.
* … Good Luck ! … *

By : DnD

Leave a Reply

Your email address will not be published. Required fields are marked *