Setup Lamp Server on GCP / Debian 10

 

1) We crated a new instance and that instance in available in thefualdelivery project

2) Now connecting SSH instance with the GCP account for file upload and download 

3) Now We are setting up Lamp server in another instance.

   

   sudo apt-get update

   sudo apt-get install apache2 php libapache2-mod-php   

   

4) Apache has been installed on GCP account and we can access this using external IP 

   Address of VM Instance:    

   

5) We can add a php info file in the /var/www/html/  file.  To create a new file this 

   command should USE:

   

   sudo sh -c 'echo "<?php phpinfo(); ?>" > /var/www/html/phpinfo.php'

   

   This command will create a php info file in html folder. and the content will be 

   <?php phpinfo(); ?>

   

6) Now we will Install MYSQL Using Meria DB

   

   sudo apt-get update

   sudo apt-get install mariadb-server php php-mysql

   

   After Installing Maria Db . We'll check meria db status using this command 

   

   sudo systemctl status mariadb

   sudo systemctl start mariadb

   We can also use mysql client connect to database server 

   

   sudo mysql 

   

7) Now We'll configure Meria DB using this command  

sudo mysql_secure_installation

8) We'll use phpmyadmin for database access 

     

9) After Installation, we can complete the configuration using remove ; 

   in   php.ini  ;extension=mysqli

10) Now we can connect our filezilla to GCP connection Following these commands 

  

    We'll download putty gen and using this command we can 

after some 

You can also watch this video to connect Filezilla with GCP account here is the link 

https://www.youtube.com/watch?v=o_OQEydt3MI

11) Now we can configure apache2.conf file by adding the following line 

   

   Include /etc/phpmyadmin/apache.conf

   

   After this we'll restart the Apache :

   using this command: 

   

   sudo systemctl restart apache2

   

12) And Now we'll test phpmyadmin using this line

  http://[Your_External_Ip_Address]/phpmyadmin   

  

After that we can setup our DNS for user 

We'll add another Tutorail for DNS   

Tutorial Link 

https://cloud.google.com/community/tutorials/setting-up-lamp

   

Reconfigure Lamp server : 

1. sudo dpkg-reconfigure phpmyadmin
2. 
   
3. https://askubuntu.com/questions/118772/how-to-change-root-password-for-mysql-and-phpmyadmin