DEV Community: Dhanraj K

How to Setup a Python Virtual Environment

Dhanraj K — Mon, 29 Mar 2021 14:02:23 +0000

Virtual Environment is necessary when you have many projects with different requirements, You can use python2 or python3 without worrying about collision and keep then main python folder clean

Install python virtual environment

>> sudo apt-get install updates
>> sudo apt-get install python3-venv

Create project folder

>> mkdir project_folder_name
>> cd project_folder_name/

Initialize a virtual environment

>> python3 -m venv virtual_env_name

To activate virtual_env

>> source virtual_env_name/bin/activate

To deactivate virtual_env

>> deactivate

Create and Manage Cloud Resources

Dhanraj K — Sat, 10 Oct 2020 16:37:39 +0000

Virtual machines
Dividing a big server into multiple instance where each of them works exactly like a regular server. Each of this divided part is a Virtual machine.

What is a Compute engine?
A google Compute engine is a customizable VM, Google provide both pre-defined and custom-type compute engine.

Pre-defined machine-types are general(best for web, and small applications), Compute Optimized and Memory Optimized.

What is Ngnix?

Its a Http and reverse proxy server.

Creating a VM using Google Cloud Console

Open cloud Console.
Navigation menu > Compute Engine > VM Instances.
Name your VM, and also select Region, Zone, Series, Machine type, Boot-Disk and Firewall
Click on Create.

Creating a Vm using Command Line

Open Cloud terminal
Use gcloud command

gcloud compute instances create <vm_name> --machine-type <machine-type> --zone <your_Zone>

gcloud compute instances create gcelab2 --machine-type n1-standard-2 --zone us-central1-c

to Ssh into your instance

gcloud compute ssh gcelab2 --zone us-central1-c

What is Google Cloud ?

Dhanraj K — Sat, 10 Oct 2020 16:33:35 +0000

Google Cloud Platform provides computer resources (servers) which runs on a well optimized infrastructure.

It helps you in deploying applications(web, mobile app, Ml models, ...)

By using Cloud Solutions many top companies solve their business problems like hosting, managing traffic load, security and analytics.

To get started - Gcloud

Google Cloud provides 100+ products.

Few Best courses to get started with Cloud Computing -

Books -

Cloud Computing: Concepts, Technology & Architecture by Thomas Erl
Cloud Computing: From Beginning to End by Ray Rafaels
Cloudonomics: The Business Value of Cloud Computing by Joe Weinman

In upcoming posts I'll Blog my learning process with key points to remember from Google Qwiklabs Cloud Engineering Track

Cloud Engineering Track

Getting Started: Create and Manage Cloud Resources
Perform Foundational Infrastructure Tasks in Google Cloud
Setup and Configure a Cloud Environment in Google Cloud
Deploy and Manage Cloud Environments with Google Cloud
Build and Secure Networks in Google Cloud
Deploy to Kubernetes in Google Cloud

These are the Skill badges required to finish Cloud Engineering track, around 54hr of practice is required.

I'm a Complete beginner trying to learn cloud engineering,If you find anything wrong or improvements in my posts, let me know in the comments

thank you

Installing MySQL and MySQL Workbench on Linux

Dhanraj K — Wed, 23 Sep 2020 16:55:36 +0000

Simple Guideline on installing MySQL and Workbench on Ubuntu , Pop_OS or any Debian Linux.

Install MySQL

Update apt to ensure you get the latest packages and install mysql-server

$ sudo apt-get update
$ sudo apt-get install mysql-server

Next to setup and Configure MySQL

$ sudo mysql_secure_installation

Selecting Y ('yes') for all the setting is reasonabe.

To access MySQL

$ sudo mysql -u root -p

Install MySQL Workbench

Download the installer which is compatable for your system and Linux version .

click here to download

Just click on the deb file and install or use dpkg command to install

$ sudo dpkg -i path_to_deb_file

To Uninstall MySQL and MySQL Workbench

If u want to remove both this softwares completely from your system use the following commands

To remove MySQL

$ sudo apt-get remove --purge mysql-server mysql-client mysql-common -y
$ sudo apt-get autoremove -y
$ sudo apt-get autoclean

To remove MySQL Workbench

$ sudo apt-get remove mysql-workbench-community
or
$ sudo dpkg -r mysql-workbench-community
$ sudo dpkg --purge mysql-workbench-community

To Start, Stop, Restart or check Status of MySQL Service

$ sudo service mysql start 
$ sudo service mysql stop
$ sudo service mysql restart
$ sudo service mysql status

To Access MySQL without SUDO

When we try to access MySQL without sudo ERROR 1045 (28000): Access denied for user 'username'@'localhost' (using password: NO)

this error pops up

Follow this steps to overcome this error

$ sudo mysql  -u root -p
Enter password:
mysql> show databases;
mysql> use mysql
mysql> select user, host, plugin from mysql.user;
mysql> update user set plugin="mysql_native_password" where User="root";
mysql> flush privileges;
mysql> exit;
$ mysql -u root
mysql> SET GLOBAL validate_password.policy=LOW;
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'Enter_password';
mysql> exit
$ sudo service mysql restart

now we can access MySQL by using

$ mysql  -u root -p