Tips and tricks on developing web sites

Installing phpMyAdmin

For this example, we are going to install version 4.9.5 of phpMyAdmin to match our Web Hosting provider. Look here to see what phpmyAdmin versions are available. It looks like 4.9.7 can be downloaded, so that should be close enough I will download the English version named phpMyAdmin-4.9.7-english.zip. Right-click and extract all to Apache’s htdocs folder (C:\Apache24\htdocs in this example). Rename the new folder phpMyAdmin-4.9.7-english to phpMyAdmin.

Edit your apache httpd.conf file (C:\apache24\conf) and add this code to the end:

<IfModule alias_module>
    Alias /phpmyadmin "C:/Apache24/htdocs/phpMyAdmin/"
    <Directory "C:/Apache24/htdocs/phpMyAdmin">
        AllowOverride AuthConfig
        Require local
        ErrorDocument 403 /error/XAMPP_FORBIDDEN.html.var
    </Directory>
</IfModule>	

Locate your config.sample.inc.php file (C:\Apache24\htdocs\phpMyAdmin) and copy it to config.inc.php. Find the $cfg[‘blowfish_secret’] = line and enter a 32 character value. Remember this is a Development Server so we don’t need to get too uptight about it unless you are going to work outside of your Development Environment.

$cfg['blowfish_secret'] = '12345678901234567890123456789012';

Locate your php.ini file (C:\PHP\php.ini) and uncomment these lines (remove ;):

extension=mbstring
extension=mysqli

Open your Web Browser, and type in localhost/phpmyadmin. You should be able to login into phpMyAdmin as root using the password you provided when you installed MariaDB.

Some more configuration needs to be done and we need a database to do that. Click on the Import tab and select C:\Apache24\htdocs\phpMyAdmin\sql and select create_tables.sql and then Go. Now you have a phpmyadmin database in the left list. That’s it!