Installing phpmyadmin on windows
October 11th, 2008- Download the latest version of phpMyAdmin from http://www.phpmyadmin.net/home_page/downloads.php.
- Extract the content to your desired installation location. (I will use D:\sites\phpmyadmin for this article).
- Edit httpd.conf (Apache) to setup a virtual host by adding
NameVirtualHost *:80 - Restart Apache.
- Navigate to phpmyadmin installation directory and copy the file config.sample.inc.php to config.inc.php and edit it as you desired (or download mine here).
- You need to enable a few extensions (edit php.ini) in order to use phpmyadmin. Here’s a few:
extension=php_mysql.dll
extension=php_mysqli.dll
extension=php_mcrypt.dll - Since you are using virtual host, you need to edit your hosts file (%SystemRoot%\system32\drivers\etc\hosts).
127.0.0.1 phpMyAdmin - Point your browser to http://phpMyAdmin/ .
- You should now be able to login.
- Navigate to Import tab.
- Click Choose File.
- On the popup box, navigate to D:\sites\phpmyadmin\scripts and select create_tables.sql. SQL commands should successfully execute.
- Now, navigate to SQL tab.
- Type: grant all on pmadb.* to ‘pma’@'localhost’ identified by ‘pmapass’.
- Click Go.
- You are all set to use phpMyAdmin now.
<VirtualHost *:80>
DocumentRoot “D:/sites/phpMyAdmin”
ServerName phpMyAdmin
<Directory “D:/sites/phpMyAdmin”>
AllowOverride None
Options None
Order allow,deny
Allow from all
</Directory>
</VirtualHost>
lines to the bottom of the file.