How to Setup Apache Web Server + MySQL (LAMP Stack) on Linux in Azure/AWS/GCP
To setup and install Apache Web Server + MySQL with the LAMP Stack on any of the cloud platforms, the recommended way is to use the available image on the cloud marketplace. It comes pre-configured with the full LAMP Stack – Apache Web Server, MySQL Server, PHP, PHPMyadmin and Let’s Encrypt. Check out the links below to deploy to your preferred cloud provider.
Apache Web Server + MySQL Server on Linux Cloud (LAMP Stack)
Setup Apache Web Server on Azure
Setup Apache Web Server on AWS
Setup Apache Web Server on GCP
Table of Contents
Apache Web Server Features
- Apache Modules – Mod_wsgi, Mod_Security
- PHP Language
- PHP Extensions – Apcu,Redis,Mongodb,Libsodium,Swoole
- KodExplorer (Web based file manager)
- Mysql Server
- Mysql Shell
- phpMyadmin
- Mysql Client
- LAMP stack
- Handling of static files
- Loadable dynamic modules
- Auto-indexing
- .htaccess
- Compatible with IPv6
- Supports HTTP/2
- FTP connections
- Gzip compression and decompression
- Bandwidth throttling
- Perl, PHP, Lua scripts
- Load balancing
- Session tracking
- URL rewriting
- Geolocation based on IP address
Getting Started with Apache Web Server on Linux
Once your Apache web server has been deployed, the following links explain how to connect to a Linux VM:
- How to connect to a Linux VM on Azure
- How to connect to a Linux VM on AWS
- How to connect to a Linux VM on GCP
Once connected and logged in, the following section explains how to start using Apache, MySQL and phpmyadmin.
Using Apache Web Server on Linux Ubuntu, CentOS and Debian
Check your Apache servers http://IPAddress and you should see the default Apache web page to confirm its working correctly.
The default directories used by Apache are as follows for some installations, check the following locations:
Web Root
/var/www/html/
Apache Configuration
/etc/apache2/
Or if the above don’t work, some installations have the following directories configured.
Web Root
/data/www/default
Apache Configuration
/usr/local/apache
Apache Documentation:
Using MySQL Server
Option 1
sudo mysql --user=root
Password is blank. If you get access is denied or wrong password error try option 2.
If the above doesn’t work, some installations can access MySQL with the following command:
Option 2
Once logged in via your ssh terminal, the first thing to do is to set a new password for the MySQL root user account by running the following commands. Replace the text ‘your_pass_here‘ with your new password.
mysql --user=root --password
Enter password: mysql1234
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'your_pass_here';
FLUSH PRIVILEGES;
If you receive an error related to your SQL syntax, depending on the version of MariaDB installed, try the following command to change your mysql root user password:
ALTER USER 'root'@'localhost' IDENTIFIED BY 'your_new_pass';
Using phpMyadmin to manage MySQL databases
To login to phpmyadmin, browse to the following URL on your web browser (use http) :
http://youserverip/phpmyadmin
You can login using your root account or you can create a new user account by running the following commands from your ssh terminal:
Create new Root User
sudo mysql
CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'some_very_complex_password';
GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';
FLUSH PRIVILEGES;
Change Root User Password
If you want to change the password of your root user, simply run the following command:
sudo passwd
Apache Web Server Firewall Ports
Default MySQL port is: TCP 3306
Apache HTTP : TCP 80
Apache TLS: TCP 443
The links below explain how to modify / create firewall rules depending on which cloud platform you are using.
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
Apache Server Support / Documentation
If you experience any issues on getting this Apache web server setup on any of the cloud platforms, please contact us and we will assist
For documentation, please refer to the following links:
Using MySQL:
https://dev.mysql.com/doc/mysql-getting-started/en/
Using phpMyadmin:
https://docs.phpmyadmin.net/en/latest/
Using Apache:
