If you want to have a more advanced database tool you might want to use PhpMyAdmin. 


Please note that at the time of writting this manual Apache was using version 2.4.46, PHP version 5.0.4. 

If they have changed their default versions, please let use know so we can change the manuals. Also you might want to change some of the settings like filenames are refering to other filenames. 

 

First you need to download and install Visual ++

https://support.microsoft.com/nl-nl/help/2977003/the-latest-supported-visual-c-downloads

Make sure you choose the right Windows version, this is either 32Bit or 64Bit. 

Reboot the machine after this install. 


Than we need to install NotePad ++

 https://notepad-plus-plus.org/downloads/ 


Now we need to install Apache

First download the zip package and unpack it in the root of C: in a folder called Apache24, this folder will be created while unpacking the files.  

https://www.apachelounge.com/download/

Make sure you choose the right Windows version, this is either 32Bit or 64Bit. 


Once that is stored in the C drive you need to install the service. You can do this via the commandprompt. 

Click on the Windows logo and search for cmd, open this as administrator.

 

Give below commands:

cd \  [enter]

cd Apache24  [enter]

cd bin  [enter]

httpd.exe -k install

 

It might happen that, after the command 'httpd.exe -k install' you get below error. That means it is missing the VCRUNTIME140.dll file. In this case you have the other architecture of the Visual C++. So if you have x86 downloaded and installed, try to use the x64 version. 


It should install Apache in seconds. Contact us in case you'll face any kind of error. 

If no errors are shown you can test the service. Go to http://localhost  and you should be able to see “It works!”. 
If the page is not loaded please restart the service via the CMD command line: httpd -k restart

Refresh the page and try again.





The First part is done now, so we can now start installing PHP and PhpMyAdmin. 

 

Let's start with downloading  PhpMyAdmin. 

https://www.phpmyadmin.net/downloads/

Do not take any beta versoins, just the latest normal version. 

 

After downloading the zip file you create a folder in: C:\Apache24\htdocs\ called 'phpmyadmin', than you copy all the files in the PhpMyAdmin zip file to this newly created folder. Make sure you copy the right files. It is in the main folder in the zip package, which could be a subfolder. 


Now we will install PHP, let´s start with creating a folder in C: called ´php´

Download PHP THREAD SAFE   (https://windows.php.net/download/) and unzip this in to the c:\php folder. Than we need to configure the settings. 

Configure PHP to run correctly on your system:

  1. In the C:\php folder, rename the file php.ini-development to php.ini.
  2. Edit the php.ini file in a text editor like Notepad ++
  3. Change the following settings in the file and save the file:
    1. Change memory_limit from 128M to 1024M (because Composer can use lots of memory!)
    2. Uncomment the line that reads ; extension_dir = "C:/php/ext" (found around Line 754) remove the ";-sign" so the line is just extension_dir = "C:/php/ext". If C:/php/ext is not there, just add it manually. 
    3. In the section where there are a bunch of extension= lines, uncomment the following lines (starting at line 909):
      1. extension=php_gd2.dll
      2. extension=php_curl.dll
      3. extension=php_mbstring.dll
      4. extension=php_openssl.dll
      5. extension=php_pdo_mysql.dll
      6. extension=php_pdo_sqlite.dll
      7. extension=php_sockets.dll (found a bit lower)
      8. extension=mysqli


If you cannot find lines as above ending with .dll starting with php_ just activate the lines as below:

extension=bz2

extension=curl

extension=mbstring

extension=openssl

extension=pdo_mysql

extension=mysqli

extension=sockets


Save the file.


Add C:\php to your Windows system path:

  1. Open the System Control Panel.
  2. Click 'Advanced System Settings'.
  3. Click the 'Environment Variables...' button.
  4. Click on the Path row under 'System variables', and click 'Edit...'
  5. Click 'New' and add the row C:\php.
  6. Click OK, then OK, then OK, and close out of the System Control Panel.

    Note: if you want to install it on a server version of Windows, e.g. 2012r2 or 2016 you might have a different options than shown above. Than you have to do it like shown below. 
    Add ;C:\php
     at the 'variable value'.

   7. Open PowerShell or another terminal emulator and type in php -v to verify PHP is working.

 

Now we can change the httpd.conf file found in C:\Apache24\conf\ You can use Notepad++ for this. Add below part all in the bottom of this file. 

 

# PHP7 module

LoadModule php7_module "c:/php/php7apache2_4.dll"

AddType application/x-httpd-php .php

PHPIniDir "C:/php"


If you're using PHP 8 you will need to add below instead of above: 

# PHP8 module

LoadModule php_module "C:/php/php8apache2_4.dll"

AddType application/x-httpd-php .php

PHPIniDir "C:/php"


You can see which PHP version is in use after you've given the command php -v in the powershell. 



Let's test if all is still working. In the command line go to the Apache24\bin folder and type httpd -t it should echo Syntax OK
If an error occours, please use the command: httpd -k restart in the command line and try again. 


 

Find the line with DirectoryIndex index.html and add index.php behind that (Line 285) 

Save the file and restart the service via the command prompt: httpd -k restart


Go to folder C:\apache24\htdocs\phpmyadmin\ and change the name of the file config.sample.inc.php in to config.inc.php (Remove sample. from it)

Open the file with Notepad++ and change below:


Line 18    Add a blowfish encryption: see https://phpsolved.com/phpmyadmin-blowfish-secret-generator/?g=5f031355d9026


Than below part should be added/changed. You might want to use different settings or connect via other options, but this is how it works for most customers. 


Change the next fields so it matches your settings

IP: the IP of the SQL server

User, in this example JohnDoe: the user for that SQL database

Password, in this example P@ssw0rd: the password linked to the user of the SQL database


$cfg['Servers'][$i]['host'] = 'IP';

$cfg['Servers'][$i]['compress'] = false;

$cfg['Servers'][$i]['AllowNoPassword'] = false;

$cfg['Servers'][$i]['user'] = 'JohnDoe';

$cfg['Servers'][$i]['password'] = 'P@ssw0rd';

 

Now you should be able to access http://localhost/phpmyadmin or http://127.0.0.1/phpmyadmin 

From here you can create your own query to export data from the database or . 



If you have any issue during the setup of the software, config files or anything else, please contact us via one of below options. 

 

          |   Email us   |   Submit a ticket   |   Give us a call    |

 

Our official support hours are 8:00 am to 16:30 pm, after those hours emailing us or submitting a ticket would be the best option.