Skip to main content

Posts

Showing posts from September, 2023

Resellerclub sgroup.in DNS and IP

 ns1.bh-72.webhostbox.net ns2.bh-72.webhostbox.net 209.99.17.71 209.99.17.72 ns1.bh-72.webhostbox.net ns2.bh-72.webhostbox.net sath181657.earth.orderbox-dns.com sath181657.mars.orderbox-dns.com sath181657.mercury.orderbox-dns.com sath181657.venus.orderbox-dns.com   162.251.82.251, 162.251.82.122, 162.251.82.250, 162.251.82.123    162.251.82.120, 162.251.82.121, 162.251.82.249, 162.251.82.248    162.251.82.247, 162.251.82.246, 162.251.82.119, 162.251.82.118    162.251.82.124, 162.251.82.252, 162.251.82.253, 162.251.82.125 

Training to work to Create the following tables in MySQL

 -- Create the following tables in MySQL -- Products -- primary key -- name -- category -- sell by date -- sold or not -- moment of sale -- quantity -- weight Kg create table products(id int primary key auto_increment, name varchar(40), category enum('Baked Goods', 'Fruit and Veg', 'Dairy'),  sell_by date, sold bool, moment_of_sale timestamp, quantity int, weight numeric(6,3)); select * from products; insert into products(name, category, sell_by, sold, moment_of_sale, quantity, weight) values  ("Sack of Potatoes", "Fruit and Veg", "2016-10-14", true, "2015-11-01 10:23:45", 30, 10); -- --------------------------------------- -- Personnel -- primary key -- given name -- family name -- gender -- telephone number -- marital status -- age -- salary -- position -- date started -- --------------------------------------- create table personnel(id int primary key auto_increment, given_name varchar(50), family_name varchar(50), gend...

Planning your personal means

  Have an emergency fund save 3 to 6 months of family expenses and then plan large expenses Living below your means with increased income expenses should not increase with increased income saveing being increased. Never be dependent on one source of income , if you dependent on one source of income you are only one step away from poverty depending on one source is risky and can stop your growth, instead of living paycheque to paycheque, create extra sources. If a family to get rich, remember that there is no your money there is only our money

AWS hosting a website with S3 and route53

 Please check the following details through this links below Text https://docs.aws.amazon.com/AmazonS3/latest/userguide/website-hosting-custom-domain-walkthrough.html Vedio https://www.youtube.com/watch?v=cMJ7cPk3tlc some tips from here: medium.com/@yashpatel007/how-to-connect-your-amazon-ec2-instance-with-a-domain-name-80ad8959078 Change the resource eg:sriraha-00707 replacement with your bucket name or domain name in S3 {     "Version" : "2012-10-17" ,     "Statement" : [         {             "Sid" : "AllowPublicAccesstoObjects" ,             "Effect" : "Allow" ,             "Principal" : "*" ,             "Action" : "s3:GetObject" ,             "Resource" : "arn:aws:s3:::sriraha-0707/*"         }     ] }

MySQL command and command line [using MySQL workbench with MySQL server]

  MySQL Install MySQL with mySQL Workbench Open Command Prompt >cd C:\Program Files\MySQL\MySQL Server 8.0\bin >mysql -u root -p <or> mysql -u root -p<password> mysql> quit >mysqld [inside the C:\Program Files\MySQL\MySQL Server 8.0\bin] >mysqladmin -u root -p shutdown --------------------------- mySQL workbench create a new connection /In qurey type[tab]/ create database <name of the database> [press>control+enter for result] show databases use <database name> create table users (username text) [creating a table with a <name> as users and inside the braket username and "text" is the type of the username] show tables desc users insert into users (username) values("Babu") [interting a <Babu> "string inside a "users" database within "username" table]  select * from users drop table users [To delete the users in the "users" table ] show tables create table users (id int...

AWS - ARN codes

  Static public for S3 in ARN ----------------------------------------------------------------- {     "Version": "2012-10-17",     "Statement": [         {             "Sid": "AllowPublicAccesstoObjects",             "Effect": "Allow",             "Principal": "*",             "Action": "s3:GetObject",             "Resource": "arn:aws:s3:::sriraha-0707/*"         }     ] }

AWS S3 useful command line commands

 ************************ cd C:\Program Files\Amazon\AWSCLIV2\ Enter at the command line to access the AWS in windows (if there is an error in a different folders) "C:\Program Files\Amazon\AWSCLIV2"\aws configure set default.region ap-south-1 <ap-south-01> is the S3 space on the AWS  ************************* # list all buckets >aws s3 ls #aws cli commands # make a bucket >aws s3 mb s3://intro-aws-768 ------------------------------------ Create a folder on S3 in AWS through the command line >aws s3 mb s3://intro-aws-768 >aws s3 ls ******************************************* # upload a file to the s3 bucket >aws s3 cp k:/aws/SathbabuKeyPair.pem s3://intro-aws-768 >aws s3 cp k:/aws/SathbabuKeyPair.pem s3://sriraha-hosting01 >aws s3 ls s3://intro-aws-768 ------------------------- # delete object aws s3 rm s3://intro-aws-768/SathbabuKeyPair.pem -------------------------- # delete all objects in a bucket aws s3 rm s3://sriraha-hosting01 --recursive -----...

Inspirations & Motivations

 

Indian Currency notes almost all

Indian Currency notes used in India in many time to time through over Reserve Banks of India or Government of India