How To Install phpMyAdmin On Windows 7
Step by step manual installation :
-
Install phpMyAdmin.
Installation phpMyAdmin
-
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 :
-
Rename the “phpMyAdmin-3.4.7.1-all-languages” directory to “phpmyadmin”.
-
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>
-
-
Restart your apache server.
-
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.
-
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 :
-
Please go to bottom page, you can see message which states the configuration has not been completed.
Configure phpMyAdmin
-
Edit phpMyAdmin’s default configuration “config.sample.inc.php“ file in “C:DnDAMPPApache2.2htdocsphpMyAdmin” directory, rename it to “config.inc.php”.
-
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.
-
-
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
-
-
After completion of your configuration, please logout from phpmyadmin and login again.
* … Good Luck ! … *
By : DnD
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”