How to Setup WAMP Server 2016 2019 in Azure/AWS/GCP

The best way to setup or install WAMP Server on any of the cloud platforms (Azure, AWS, GCP) is to use our marketplace image.  The image comes pre loaded with WAMP Server on Windows with Apache, PHP, MySQL, MariaDB, phpMyadmin and Mysql Workbench. The perfect solution to host your web applications in the cloud.

Setup WAMPServer on AWS

 

 

Coming soon…

Setup WAMPServer on GCP

 

 

Coming soon….

Getting started with WAMP

 

Once you’ve deployed WAMP Server to your cloud environment you’re ready to start using it. The below sections explain how to use and login to your new WAMP Server and making any configuration changes.

 

WAMP Login Username and Password

 

The default login for both PhpMyadmin, MariaDB, Mysql are:

 

User: root
Pass: blank (no password is set)

 

Its highly recommended to change the password once you login

 

MySQL and MariaDB

 

Depending on the versions of the complete Wampserver installers, either MySQL or MariaDB is the default database manager.


If MySQL is the default manager, it uses port 3306, in which case MariaDB will use port 3307.
If MariaDB is the default manager, it will use port 3306, in which case MySQL will use port 3308.

 

You may find that MariaDB is the default database manager and if you want to use MySQL, Simply right-click Wampmanager Icon -> Wamp Settings -> Allow MySQL to check

WAMP Allow MySQL

 

To find out what ports MariaDB or MySQL are using – right click on WAMP icon tray > Tools and as shown in the screenshot you can see the ‘Default DBMS’ is MariaDB and the ports used by MariaDB are 3306 and MySQL using port 3308.

WAMP Server default database

PhpMyAdmin


PhpMyAdmin is configured to use either MySQL or MariaDB.
When calling PhpMyAdmin, there will be a choice of server: MySQL or MariaDB, the default server being the first in the list.

phpmyadmin login for WAMP

If you receive an error message about versions, you can ignore this message and proceed. It refers to connecting to MariaDB.

 

Connection to the database by MariaDB or MySQL


In order for your connections to a database server to be made with MariaDB or MySQL, you must specify the port if it is not the default port 3306. Indeed, without specifying the port, it will be the default port that will be used, so 3306.


Connection scripts use, for example:


$mysqli = new mysqli(‘127.0.0.0.1′,’user’,’password’,’database’);


or, in procedural terms:


$mysqli = mysqli_connect(‘127.0.0.0.1′,’user’,’password’,’database’);

 

To connect with a manager that does not use port 3306, you must specify the port number:


$mysqli = new mysqli(‘127.0.0.0.1′,’user’,’password’,’database’,’3307′);


or, in procedural terms:


$mysqli = mysqli_connect(‘127.0.0.0.1′,’user’,’password’,’database’,’3307′);

 

To check the connections to the MySQL or MariaDB database manager, use the script


wamp\www\testmysql.php by’http://localhost/testmysql.php’


by first modifying the script according to your settings.

 

Replace MySQL with MariaDB and vice versa


Important note : It is imperative to save your databases in SQL files by exporting them before disabling MySQL.


This is the only sustainable way to transfer your databases between MySQL and MariaDB.


– There is a tool to reverse the default DBMS with a single click if both are enabled (MySQL AND MariaDB):
– If MySQL is the default DBMS
Right-click Wampmanager icon -> Tools -> Invert DBMS by default MySQL <-> MariaDB


or


– If MariaDB is the default DBMS
Right-click Wampmanager icon -> Tools -> Invert DBMS by default MariaDB <-> MySQL

change WAMPServer default database server


Of course, you still have to import your previously backed up databases.

 

Create or add a VirtualHost



With Wampserver 3, you can create a VirtualHost with few clicks.


For ease of explanation, here are some names:


– sitefolder : folder in which you want to host the local site
– sitename : name that will be called the local site (http://sitename/)

First, choose where we want to host your local site, it can be a folder in Wampserver as c:/wamp/www/sitefolder/ but this is not mandatory; this host folder can be anywhere on the hard drive, avoiding the paths comportants spaces; for simplicity of explanation we choose c:\sitefolder\.


We need the folder to host the site exists before creating the VirtualHost, we must create it whith File Explorer, launched as administrator(See bottom of page *) :
– Move in the disk tree to where we want to create the folder “sitefolder
– Right-Click, New -> Folder
– Then type the folder name

– Lauch Wampserver, wait for icon W gren
– Wampmanager Icon -> localhost

create virtualhost on WAMP server


We arrive on the home page Wampserver, without Your VirtualHosts menu in the lower right (This is normal, just after installing Wampserver)
– Click Add Virtual Host in your Tools menu at the bottom left

wampserver virtual hosts


Arriving there, everything is ready in order to create his first VirtualHost
– In the form
— For « Name of the Virtual Host No space – No underscore(_) », we type:
sitename


— For « Complete absolute path of the VirtualHost folder Examples: C:/wamp/www/projet/ or E:/www/site1/ », we type:
c:\sitefolder\


And validates the form by the button:
– Start the creation of the VirtualHost
As stated: It can take some time.

After this “time” it is stated that unfortunately certain operations required for the recognition by Windows and and Apache of this new VirtualHost can not be performed automatically by the browser, so, as shown:


– Right-Click Wampmanager Icon -> Tools -> Restart DNS
Wait until the icon turns green.

restart WAMP dns service

 

Click on Back to home
You now have Your VirtualHost Your menu, at right with such items:
– localhost
– sitename

 

Likewise, you also have this submenu Your VirtualHosts with Wampmanager icon.

Now everything is ready to set up your local site in the folder c:\sitefolder\ indicating, if required during the installation, that the URL is (http://sitename/) (Without parentheses).

*To launch an application, via its shortcut, as administrator :
– Right-click on the shortcut, Properties
– Shortcut tab
– Advanced button
– Select Run as Administrator
– OK, Apply, OK

 

Disable MariaDB or MySQL


You are not required to keep using both MySQL and MariaDB managers, you can keep only the one that suits you and you can even completely disable both database managers by:


Right-click Wampmanager Icon -> Wamp Settings -> Allow MariaDB to uncheck
Right-click Wampmanager Icon -> Wamp Settings -> Allow MySQL to uncheck

WAMP disable MySQL or MariaDB

 

WAMP Firewall Ports

 

The apache webserver uses the following ports:

 

TCP/80 – (http traffic)

TCP/443 – (https traffic)

 

Mysql and MariaDB use the following ports depending how they are configured on WAMP:

TCP/3306

TCP/3308

 

To setup AWS firewall rules refer to – AWS Security Groups

To setup Azure firewall rules refer to – Azure Network Security Groups

To setup Google GCP firewall rules refer to – Creating GCP Firewalls

 

Support

 

If you have any questions about this WAMPServer deployment or are experiencing any issues with your deployment leave your comments below and i will answer them for you within 24 hours.

 

If you would like to hire us to setup your WAMP server environment for you, get in touch and we can get you up and running 

 

WAMP Support can also be found on their forum: http://forum.wampserver.com/

Andrew Fitzgerald

Cloud Solution Architect. Helping customers transform their business to the cloud. 20 years experience working in complex infrastructure environments and a Microsoft Certified Solutions Expert on everything Cloud

No Comments

Post a Comment

Comment
Name
Email
Website