Credits & Source from: https://github.com/sendmail2krrish/eCommerce-site-using-Node-Express-js

1. Provision a Google Compute Engine (GCE)
   
2. SSH into the db-server. Switch as root user using sudo -s and below command to install MySQL Server. When prompted for password give a strong like P@ssW0rd2020
   apt update
   apt install mysql-server -y
   
3. Comment bind-address configuration using vi /etc/mysql/mysql.conf.d/mysqld.cnf and save the configuration using ESC followed :wq!
   
4. Restart MySQL Service using systemctl restart mysql
   mysql -u root
   mysql> CREATE USER 'new_user'@'%' IDENTIFIED BY 'new_password';
   mysql> GRANT ALL PRIVILEGES ON . TO 'new_user'@'%';
   mysql> FLUSH PRIVILEGES;
   mysql> GRANT ALL PRIVILEGES ON . TO 'new_user'@'%' WITH GRANT OPTION;
   mysql> ALTER USER 'new_user'@'%' IDENTIFIED BY 'new_password';
   Restart MySQL Service using systemctl restart mysql
   
5. Logging to mysql using mysql -h 127.0.0.1 -u new_user -p
   
6. Create a database named eCommerce using CREATE DATABASE eCommerce;
   
7. Exit mysql session
   
8. Change directory to home directory using cd ~ and run git clone https://github.com/learngcpwithmahesh/Dress4Win.git
   
9. Change directory to Dress4Win/sql
   
10. Create the table schema using mysql -h 127.0.0.1 -u root -p < ecommerce.sql
    

1. Provision a Google Compute Engine (GCE) with below startup script