Step 1
Make sure you have your Private Key and path handy. The Private Key is sometimes called the .pem file. If you have it already, go to Step 2. If you do not have it, in your Lightsail Dashboard:
1. Go to your Account page under the SSH Keys tab, click the Download link; or
2. Go to Manage Instance, under the Connect tab. In there you will see a link to download the Private Key from the Account page. Click there and download.

Keep your Private Key in a folder where you know the path.

STEP 2: Create SSH Tunnel (For Mac users)

Open the Terminal window on your Mac (Eg. “Finder -> Applications -> Utilities -> Terminal”). At the command prompt, type in this command and press enter:

ssh -N -L 8888:127.0.0.1:80 -i /path/key.pem bitnami@PublicIP

(Replace the path and .pem filename accordingly. Replace PublicIP with the Fixed IP address as provided by AWS Lightsail.)

Sometime you will see this message in your Terminal:

@@@@@@@@@@@@@@@@@@@@@@@@@@@@
WARNING: UNPROTECTED PRIVATE KEY FILE! 
@@@@@@@@@@@@@@@@@@@@@@@@@@@@

Permissions 0644 for ‘/path/key.pem’ are too open.
It is required that your private key files are NOT accessible by others.
This private key will be ignored.
Load key “/path/key.pem”: bad permissions
Permission denied (publickey).

If you see this message, type in the following command:

sudo chmod 600 /path/key.pem
(replace the path and .pem filename accordingly.)

In your browser, go to: http://127.0.0.1:8888/phpmyadmin/

If successful, you should be able to see phpMyAdmin login page. But you may be wondering…. what is the ID and password to login?

STEP 3:
For the user ID, try “root” or “bitnami”.

In order to get the password, go to manage instance in your AWS Lightsail dashboard under the Connect tab. Click on the “Connect using SSH” button and run the following command:

cat bitnami_application_password

And voila! Your password appears!

Somehow I’m still not getting the feel of those big awful navigation icons came into vogue post MS Office 97. Somewhere in the mid to late 1990s, Microsoft probably lost its plot and packed a whole lot of useless features into Office at the expense of simplicity and user friendliness.

When using Open Office Spreadsheet recently, I was trying to copy a data table from the Docs to Calc. After trying for more than half an hour, I became frustrated. From the traditional Copy and Paste, I tried all sorts of other Paste Special methods but without success.

I couldn’t believe that it was unable to perform such a seemingly simple task!

So after tearing my hair out for more than half an hour, the solution finally came.

So this is how it goes:

1. In Open Office Calc, highlight the cells you want to copy.
2. Control C to copy the range.
3. Shift + Control + V to Paste Special
4. Paste as Unformatted Text in Open Office Docs
5. Then Ctrl+A to select all the data
6. Go to Table – Convert -Text to Table
7. In “Separate text at”, set to “Tabs” and click OK

Voila! Really so simple!
I have been using this software for years. Personally it has 95% of what I will ever need in an office software suite. One of the top free products out there.
Download Open Office >>
Tip: Another free open source office suite is Libre Office. It is a bit more feature packed and powerful than Open Office but I find it slightly less user friendly. Like Open Office, a big plus is the good old fashion Drop Down menu. Download Libre Office >>

So why pay a dime for your Office Suite software?

OK this is the typical mask most people wear. It’s a surgical mask which has a “white” (lighter) side and “blue” (darker) side.

Apparently this is the most common version floating around…. The white side has the filter. If you are well and don’t want to breathe in germs/polluted air, wear the mask with the blue side inwards and white side outwards. If you are unwell and don’t want to spread your germs to others, wear the mask with the white side inwards and blue side outwards.

However a more recent version is that there is only one correct way to wear your mask, that is the blue side (the side with the downward folds) has to face outwards. Most surgical masks have 3 layers, the blue (outer) layer which serves to repel fluid. The middle layer is a barrier to germs while the inner layer absorbs moisture. Apparently the purpose of the blue layer is to prevent germs from sticking onto the mask. But if you wear the mask with the white side facing out, air moisture will stick on it and make it easier for germs to stick around.  More info >>

Searching around, I found that Hong Kong’s Centre for Health Protection has a good and detailed explanation in support of this. Download the document here >>

So what about N95 masks, do they help? Apparently not, according to Singapore’s Health Ministry which is advising the general public to wear normal surgical masks instead of N95. Normal surgical masks are more practical and helps block large particle droplets from entering your mouth and nose. However N95 masks are tight fitting and designed to filter small airborne particles. If worn properly, it makes breathing difficult. If not worn properly, you are not protected from the air particles anyway. More info >>

While doing this, I recalled a recent PHP Upgrade I did for a client from PHP version 5.4 to PHP version 7.1. It seemed to have worked well for his WordPress website so I thought I’d do the same for this website. After that I ran Optimize Website in cPanel (look for it under the Software section in cPanel).

The result in Google PageSpeed Insights has been astonishing. Checking it just now, I scored 98 points for both Desktop and Mobile View! If you find that hard to believe, so do I. In all my years doing website development, I’ve never ever come close to this score.

So hopefully these screenshots will convince you:

Now we all know that Google PageSpeed Score is not perfect. And it’s not the be-all-end-all in website speed testing. However just making these small tweaks make all the difference. Of course, you first need to have done some basic things like optimizing your images, signing up with a good web host in a good server, avoiding slider animation and CDN content delivery if possible.

Recently out of curiosity I decided to install Adobe Flash Player. Around 2-3 weeks later I noticed a popup asking me to update Adobe Flash Player. I closed the pop-up but a couple of hours later it popped up again. The popup became more frequent (less than one hour apart). So I went to System Preferences and removed Adobe Flash Player. But this is not the end of the story. The annoying pop up continued even after the software was removed.

After some searching around, I found a simple solution. Go to Applications – Utilities. You will see a file called Adobe Flash Player Install Manager. Just delete it and the annoying pop-up should stop.

Note that Adobe will no longer update or distribute Flash Player effective end 2020.

Are you an adventurous person? Are you in love with sweet mother nature? You love camping, jungle trekking or any outdoor activities but afraid that you don’t have the extra tools needed? Now you don’t have to worry anymore. These hi-tech gadget will help you get through all those problems.

Eton Scorpion

Now this device is not just an ordinary gadget. It is a flashlight and also a weather AM/FM radio. It could also charge your smartphones, just plug in your smartphone with this device and your phone will charge. Most exciting part is, this flashlight doesn’t even need a single battery. It either use solar energy or your hand crank. Now talk about green devices right?

Sawyer Squeeze Water Filter System

This is a must have item for you to have while you discover mother nature. Know this fact, deep in the jungle, clear water doesn’t mean it is safe to drink. This device can filter the water and remove any possibilities for you to get sick, a good item.

PowerMonkey Extreme

Yes, whether you’re in the jungle exploring, you can’t still live without your smartphones or tablets. Furthermore, the battery usage would be the main problem. introducing PowerMonkey Extreme, a 9000mah solar-charging power bank for your device. This gadget can charge your device up to more than 7 times. Now this is what we would call, a “Hope”.

Victorinox Expidition Kit

A awiss army knife is a normal item that people bring when they do outdoor activities but this gadget is not a normal swiss army knife. This multi-tool kit has 41 functions including LED light, thermometer, built-in digital watch and lots more.

Sony Digital Recording Binoculars

Its good to capture every good memory when you’re in the jungle. Its even better if u could capture pictures even if you’re far away. Now you can do that with this hi-tech gadget, no matter how far you are, this gadget will capture all your memory.

Source: HongKiat

Have you ever seen in some movies, like Iron Man, where Tony Stark (starring Robert Downey Jr) interacts with his super smart computer using only hands and gesture motion. Or in some of the television series like CSI: Miami, where these investigators use their hand motion to interact with the computers. Want to have those feeling of excitement?

https://www.youtube.com/watch?feature=player_embedded&v=3b4w749Tud8

This tiny interesting device is called Leap Motion. This device will make you experience something you never felt before. Its introduction video is enough to show you what this device could possibly do.

Just plug in this device to your PC using USB cable and prepare to be amazed. For now, leap Motion is compatible with Microsoft Windows 8 and Apple Max OS X. With the size of your broadband, you can almost do anything with this device without even touch your keyboard or mouse.

Feel like trying this device and have fun with it? Yes, you can!

You can just browse to its website and pre-order the development kit. The kit comes with the device and the USB cable.

Now to think of this, since there is a lot of technology changes, are humans now become lazier than ever?

Source: Leap Motion

Video games nowadays have become more and more advance. Lots of advanced technology have been used in order to fulfill the users’ satisfaction. Joysticks, game controllers also plays the important parts in bringing the game to life.

Now attention you hardcore gamers, prepare to be amazed!

This is Oculus Rift. It is a Virtual Reality gaming device that will make you feel that you are really in the game and blow your mind.

Oculus Rift was invented by Oculus VR, a company based in Irvine, California. This device was created by virtual reality enthusiast and hardware geek, also a founder of the company,  Palmer Luckey.

This is the reaction of people who have tested the device. this incredible device is not just impressing the eye, but could also influence the users’ body movement since they are “in the game”.

For starters, Doom 3 BFG version is the first Oculus-ready game and many more games will come soon. To get this development kit, you can just go to their website and order one.

Prepare to be amazed and experience the awesomeness.

Source: Oculus VR

Everybody knows Google, the most famous search engine on the internet. You can search anything on Google. When your friend ask you something that you didn’t know the answer, you would easily say, lets Google it. Google also is the developer for Android OS, the operating system for smartphones. The latest invention by Google is the Google Glass, the unique glasses that can almost do whatever you want. But is there anything else that Google has created beside all these inventions?

Meet Google Driverless Car, the car that can drive itself automatically without any control from the driver. Now this is far more better and logic rather than flying car fantasy.

Google Driverless Car was invented before the introduction of Google Glass but somehow they didn’t really introduce much of this driverless car. Driverless car is good when you take a long distance driving, you don’t need to stop anywhere to have some rest, just key in the destination and your car will drive itself.

How Google Driverless Car works?

Well, the combination of software and hardware have made it capable of driving on its own instead of driven by a driver manually. the laser on top of the car detects the surroundings, other cars, roads for better driving.

The GPS technology in this car is really important in making the car move automatically to the exact location.

All the cameras, lasers scanner, radars that installed in this driverless car have their very own functions. Combine all together, this car can move and drive as if it is being manually driven by human.

Although this car has been tested for years and collecting data more than 250 00 miles, there is still no hint from Google that they want to introduce this invention to the market.

Source: Slashgear