Digital Ocean - Terminal

• Create a .txt file
• start "" ssh root@IPAddress => Type this in that file
• Rename .txt to .bat
• Open it to directly Login to your Droplet => If you get error then it can be solved in "C:\Users\userName.ssh'

    const express = require("express");
    const app = express();
    const port = 3000;

    app.get("/", (req, res) => {
        res.send("Hello World!");
    });

    app.listen(port, () => {
        console.log(`Example app listening at http://localhost:${port}`);
    });

    server{
    server_name yourDomain www.yourDomain;

        location / {
            proxy_pass http://localhost:3000;
            proxy_http_version 1.1;
            proxy_set_header Upgrade $http_upgrade;
            proxy_set_header Connection 'upgrade';
            proxy_set_header Host $host;
            proxy_cache_bypass $http_upgrade;
        }
    }

• sudo apt update => Update apt commands
• sudo apt install apache2 -y => It is a Web Server
• sudo ufw app list => Gives list of Apps that want to pass Firewall
• sudo ufw app info "appName" => Gives description about that App
• sudo ufw allow in "appName" => Allow incoming traffic on required PORT for this App
• Now your IP Address will work

• sudo apt install mysql-server => Install MySQL
• sudo mysql => Opens MySQL terminal
• SELECT user, authentication_string, plugin, host from mysql.user; => Shows how ROOT is logging in
• ALTER user 'root'@'localhost' identified with mysql_native_password by 'yourPassword'; => Changes the authentication way for ROOT to given Password, Not Recommended
• FLUSH PRIVILEGES:
• exit => Close Terminal
• sudo mysql -p => Now you have to login using Password

• sudo apt install php libapache2-mod-php php-mysql => Install PHP and some other Modules
• sudo nano /etc/apache2/mods-enabled/dir.conf
• In text editor, Swap position of index.html and index.php as we want to run PHP before HTML
• ctrl + X > Y > enter => Save & Exit
• sudo service apache2 restart => Restart
• cd /var/www => All Websites are by default in this folder
• cd /html => Contains index.html file of Apache by default which is being served on your IP Address
• sudo nano index.php => Create this File and write the given code to serve this instead

      <?php
      phpinfo();
      ?>
  

• sudo service apache2 restart => Restart
• Now your IP Address will show PHP page instead of Apache page

• sudo apt install phpmyadmin php-mbstring php-gettext
• y then press enter > Select apache2 by clicking space then press enter > Select yes then press enter
• Enter Password
• sudo phpenmod mbstring => Enables Modules
• sudo service apache2 restart => Restart
• sudo mysql -p => Login
• Now in your IPAddress/phpmyadmin will show phpMyAdmin
• create user 'userName'@'localhost' identified by 'yourPassword'; => Create a new user to Login in phpMyAdmin instead of ROOT
• grant all privileges on *.* to 'userName'@'localhost' with grant option; => Give ROOT power to that user

• cd /var/www
• sudo mkdir fileName => Create this File
• ls -lart => List with some information
• sudo chown -R $USER:$USER fileName1 => Make current user owner of the file instead of ROOT
• ls -lart => List with some information
• cd fileName1/
• sudo nano index.html => Create this file and edit using Nano
• ctrl + X > Y > enter => Type some lines and Save & Exit
• cd /etc/apache2/sites-available/ => Available Sites by Default
• ls => 2 files will be there by default, 000-default.conf & default-ssl.conf
• sudo cp 000-default.conf fileName2.conf => Copy that in a new file
• sudo nano fileName2.conf => Open in nano

      ServerAdmin email@address
      ServerName domainName
      ServerAlias www.domainName
      DocumentRoot /var/www/fileName1
  

• ctrl + X > Y > enter
• sudo a2ensite fileName2.conf => Enable this Site
• sudo a2dissite 000-default.conf => Disable old site
• sudo service apache2 restart => Restart
• sudo apache2ctl configtest => Checks if configuration is right
• Syntax OK
• Go to your Domain provider > DNS Management
• Type A, Name @, Value IPAdress, TTL 600 seconds => Changes may take some time
• Now you can go to your Domain and Check! => Follow the same steps to host multiple website on the same VPS

    ServerName domainName
    ServerAdmin email@address
    WSGIScriptAlias / /var/www/flaskapp/flaskapp.wsgi
    <Directory /var/www/flaskapp/flaskapp/>
        Order allow,deny
        Allow from all
    </Directory>
    Alias /static /var/www/flaskapp/flaskapp/static
    <Directory /var/www/flaskapp/flaskapp/static>
        Order allow,deny
        Allow from all
    </Directory>
    DocumentRoot /var/www/flaskapp
    LogLevel warn

    #!/usr/bin/python
    activate_this = '/var/www/flaskapp/flaskapp/venv/bin/activate_this.py'
    exec(open(activate_this).read(), dict(__file__=activate_this))
    import sys
    import logging
    logging.basicConfig(stream=sys.stderr)
    sys.path.insert(0, "/var/www/flaskapp/")
    from flaskapp import app as application
    application.secret_key = 'Add-my-secret-1234-key!@$$%^&*(sdfsdf643535##$$'

    from flask import Flask
    app = Flask(__name__)
    @app.route('/')
    def hello_world():
        return "Hello, World!"