Wednesday, June 23, 2021

Install MySQL on Ubuntu 18.04

 Install mysql database on the Ubuntu OS.

1. open terminal

 execute below command

sudo apt-get update
2. sudo apt-get install mysql-server

3.sudo systemctl status mysql - check status of mysql db

4.sudo mysql_secure_installation
It's asking for Root new password
5.For all the other asking questions  enter 'y'
 

 
6.Next enter mysql -u root -p
Then it's ask for password
After that It's giving below error message.
7.
 Then enter sudo mysql command


8. After that enter below sql query

SELECT user,authentication_string,plugin,host FROM mysql.user;

you can see output as follows


then I change Root password as follows.

 ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '257F257f';



9.then press below sql query.

FLUSH PRIVILEGES;

10. next see below sql query.

SELECT user,authentication_string,plugin,host FROM mysql.user;


Now output will be as follows.

You can see in this example output that the root MySQL user now authenticates using a password. Once you confirm this on your own server,
you can exit from mysql shell using exit command.
Next login to my sql you have to do following command
 
mysql -u root -p
 



Sunday, June 20, 2021

Elastic Search Database

 Elastic Search database is no-sql database.

Below are the comparison with Elastic Search Database items with Relation Database Item.


create index using below command line


If below http://localhost:9200/_cat/indices  on brower contains yellow one,you have to run below command

curl -XPUT 'http://localhost:9200/_settings' -H 'Content-Type: application/json' -d '
{
    "index" : {
        "number_of_replicas" : 0
    }
}'



Tuesday, June 15, 2021

setup nginx Server reverse proxy on Windows 10

 Nginx is famous server to do a reverse proxy.

 Here I am setting up how to setup Nginx

 

 

Sunday, December 27, 2020

How to create Turmeric powder at home

 Turmeric powder is one of healthy ingredient, use  at home kitchen in Sri Lanka.It has anti-inflammatory,antioxidant, and antimicrobial properties.


Today we talk about how to create Turmeric powder at home.

1.First we need to buy pure Turmeric from the market.Normally LKR 700 - 1200 per 1kg in Sri Lanka. you may refer below image.

 


2. Then we need wash them at least two or three water bucket.

 

3. Next We need to  Steam them 20mins from string hopper container.you may refer screenshot.Here on the top we put Turmeric and on the bottom we put water and boil the water 20 mins.


4. Next cut them into small pieces. you may refer screenshot.size of Turmeric as follows.





5.After that dry them from the sunlight ,nearly 3 days.until them become small pieces.


6.Finally blender them until it become powder. From pure Turmeric 1 kg you can create 100g -150g powder.








Tuesday, July 7, 2020

Cirrhosis - my mother suffered

My mother got Cirrhosis and passed away in 2019 August month.I am writing this article using my own experience with her life.

We identify her Cirrhosis illness in 2015.Then it attacked her liver a lot.After that we did not give her a single panadol.We given her fruit and vegetables only.

Before the Cirrhosis she has very low level Diabetic condition and she control it using metformin tablet.But After the Cirrhosis ,her Diabetic level increase and she had to inject Insulin.

During Cirrhosis, if she got a infection ,it will directly attack her brain.So she lost her memory.After that we quickly hospitalized her and with the doctor's proper medicine she recovered her memory.

But after 4 years time she forgot most of the things.Her memory power gradual lost.

the way above image says We stand her hand and check whether it fall down,if it fall down then that means she lost her memory.

Also My mother having another issue after she retired from school teaching ,she lost her hearing,due to killing her hearing nervous.

So it's bit difficult to communicate with her.


Monday, July 6, 2020

How to uninstall Application from Android phone


 Take your android phone and   please follow the below steps.

   1. Select the Settings app from your app drawer or home screen.
   2. Tap Apps & Notifications, then hit See all apps.
   3. Scroll down the list until you find the app you want to remove and tap it.
   4. Select Uninstall.

Monday, January 23, 2017

Brief Garden ,Beruwala ,Sri Lanka

The Brief Garden, house, which used to be the home of landscape architect Bevis Bawa, brother of renowned architect Geoffrey Bawa.

Bawa was educated at Royal College Colombo, but had to leave school at seventeen when his father died while in England. His mother sent him to be trained as a planter at his uncles estates in order to take up the management of the family estate in Aluthgama know as Brief Estate.

I went to this garden last weekend.There were few Tourists in the garden .But there is only one Sri Lankan family.due to unawareness of Lankan s. It has nice architectural views.Even at Lunch time,the garden was very cool climate.One of the best places i visited in sri lanka.