A. Sidiq Purnomo

Universitas Mercu Buana Yogyakarta

You are here: » How To Install phpMyAdmin On Windows 7

How To Install phpMyAdmin On Windows 7

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

Print Friendly, PDF & Email
Posted by 0 Responses
 

Free Email Newsletter

Stay Updates with this Blog. Get Free email newsletter updates..

And then confirm your email subcription

   

No Comment to “How To Install phpMyAdmin On Windows 7”

  1. No Comment yet. Be the first to comment...
Leave your comment here:

Secure * Time limit is exhausted. Please reload the CAPTCHA.

Nov
28
2011