How to Enable 2-Step Verification In Dropbox Account

Dropbox is the most popular cloud storage service for personal and professional use. Hacking accounts with phishing websites, keyloggers and other spy softwares is soaring. To counter these activities 2 Step verification is implemented by many major websites like Google, Yahoo and Facebook. In 2 step verification a user has to enter his password and then a security code which is sent to your phone automatically. So even if someone knows your password , your account will still be inaccessible due the security code.
It is still in testing and hasn’t been rolled out for all users but I will give you a special link using which you can easily enable it. I won’t recommend this additional security for everyone because if you don’t store something too important in your account then why every-time wait for the sms in your phone to sign in. If you sign into your account multiple times a day then it will also be annoying. You can also read my earlier post to increase the security of facebook.

Steps to Enable 2-step verification In Dropbox Account

• To enable 2 step verification, open this link and sign into your account.
• Now go to Settings and and click on the Security option.
• Scroll down the page till you see the 2 step verification option and enable it.
• This is a security feature so it will prompt you to enter password. Now you will have two options to add the extra security layer
  • Code by text message
  • Code by mobile app
• Select code by text message option and enter your phone number. Shortly you will receive the verification pin via sms

• Enter the pin to verify your phone number and activate 2 step verification
• You will also get a backup code which can be used to bypass sms verification code which will come in handy in case of mobile theft or out of network conditions.

How To Completely Block Facebook On Computer

If you are following our blog regularly then you may already know that you can block any website on your computer by editing Hosts file.The major advantage of this trick is that you don’t need any addtional software to block websites but it has its own Flaw.Host file cannot block website access through Proxy or VPN network.Lately I have been trying to figure out  perfect solution that is free and can completely block facebook even via proxy or VPN.
FB Limiter is a windows application that can completely restrict access to facebook and Youtube on your computer.It is available in both free and paid versions.The Free version allows only complete blocking of youtube and facebook whereas in paid version you will have the ablity to block or unblock these sites for specific interval of time.

Features Of FB Limiter

• Block facebook and youtube access on your computer to anyone who uses it (Normal Lock)
• Limit facebook and youtube access to specific times during the week (e.g. Allow your kids to use facebook only one hour a day) (Time Lock - Pro version)
• Block facebook and youtube access to yourself for specific time duration. In cases when you are too much distracted and want to be sure you will not get a chance to use facebook or youtube. (Total Lock - Pro version)
• Control access to facebook on daily basis. (e.g. You could limit usage of facebook to just one hour daily) (Duration Lock - Pro version)

How To use Fb Limiter?

Grab your free copy of FB limiter by clicking here.Install and run the software on your computer.You will need to register for a free account to unlock the software.Once registered you will be greeted by a friendly user Interface (see screenshot below)

Now you can block these website on a single click of mouse.
Another great feature of this softwae is that it is password protected.Even if somebody know that you are blocking websites using FB limiter still they won’t be able to unblock them as the software will ask for a password before it can be used.
This software is compatible with windows xp service pack 2 and later.So test out this software and share you experience via comments.

How To Save Gmail Attachments Directly to Google Drive Source

Google is adapting quite well with latest technologies and Google Drive is another product in their already well equipped arsenal of Products.If you aren’t aware about Google Drive, its a cloud computing service launched by Google few days back to compete with Dropbox and SkyDrive.I already wrote a detailed review of Google drive and if you are not sure whether which service you should opt for then you must read detailed comparison of Dropbox, SkyDrive and Google Drive.

Since it is a product from Google we can expect it to be integrated with other services from the search engine giant.As of now you can directly open and save Google Docs files in you Google Drive account but what about email attachments? They shouldn’t be ignored Right? There is no official update regarding the time-frame in which Gmail and Google Drive will be integrated but a chrome developer has made an extension that will fulfill this purpose.

Gmail Attachments To Drive is a Google chrome extension developed by Josh Sullivan and is available for download in Chrome app store.
Here are Steps Save Gmail Attachments Directly ti Google Drive

Download and install Gmail Attachments To Drive addon for chrome.
Now open Login into your Gmail account and open any mail with document (pdf,docx etc) attachment.Now you will notice Save to Drive just below your attachment.Click on it and your file will automatically get stored in Google Drive.
However the extension only supports documents like pdf, docx, rtf etc and it cannot save videos and compressed files like .rar or .zip files directly to Google drive.For these type of documents you have to perform the task manually.

How To Change WordPress Admin Password From SQL Database Source

Rarely you will face such a situation when you will need to change your wordpress password from SQL database because if you ever forget your password you can use the Forgot Password feature using which your new password will be emailed into your inbox. However if your website gets hacked or due to any reason you lose access to both your email and wordpress than such a sitution can be handled by changing the password from SQL.

If you are a non-programmer even then you can’t go wrong with this process as it is too simple but make sure that you don’t change anything other than mentioned in the steps below.

Open Hosting Account.
Select PhpMyAdmin from your hosting. In Screenshot Below I have Shown PhpMyAdmin in Cpanel Hosting

How to reset WordPress Admin Password from SQL

Now Select your WordPress database from the dropdown menu in Left Sidebar. After you select the appropriate database the page will automatically reload and your tables will be visible.
Now look at the top navigation bar and click on the SQL tab.
In the Text area type the following code

UPDATE `wp_users` SET `user_pass` = MD5( "new_password_here" ) WHERE `wp_users`.`user_login` = "admin_username";

Here you will replace new_password_here with your new password you want to set and admin_username with new administrator username.

Code for How to reset WordPress Admin Password from SQL

Now click on the Go Button and your Username and password will get changed.

Login into your wordpress account with new username and password.This method works on self hosted wordpress.

How to create A Quick LAN Connection Between Two Computers In Windows

First go and buy the straight patch Ethernet LAN cable(make sure that ‘patch’ or ‘crossover’ is written on the cord) and connect them to both computers.

In Windows XP: Go to Network Connections Control Panel, right-click Local Area Network connection and select Properties. Now select Internet Protocol(TCP/IP) and click Properties.

In Windows Vista: Go to Network and Sharing Center, select Manage Network Connections, right-click Local Area Network connection and select Properties. Now select Internet Protocol Version 4(TCP/IPv4) and click Properties.

Now once you are inside the TCP/IP properties of your computer, click Use the following IP and enter 192.168.0.1 as IP address and 255.255.255.0 as subnet mask. Leave the other details blank and click OK.

Internet Protocol IP Properties

Now go to TCP/IP properties of the second computer and enter the same details except the IP address, which should be 192.168.0.2 and click OK.

Internet Protocol IP Properties 2

Now the networks are ready, you might need to restart both computers in some cases. If you are looking to share the Internet Connection between two computers, go to Local Area Network properties again and click on Sharing tab. Here you can select the enable internet connection sharing.

local area connection internet sharing

To share files and folders between the two computers, go to the properties of that file/folder and select Sharing tab. Click Share to being sharing it on the network.

sharing properties

Let me know if this works for you. Enjoy!

Recovery of External HDD after worm attack

Recovery of External HDD after worm attack
I have a Seagate 500 GB External Hard disk which I share between office & home. Recently, I noticed for the HDD, there are shortcut links for all the folders . I could open the folders in a new explorer window. Next day, my office computer antivirus detected attack in the HDD with Worm:Win32/Dorkbot!lnk. It deleted all the shortcuts. Now I can not find/open the folders though the files are there. I can understand the files are there during virus scanning or though disk usage.
Please help how to recover the data?

see if they are made hidden ?
Use Recuva and recover lost files.
Recovery of External HDD after worm attack.

How to install Google Maps on Nokia phone

Has Nokia barred Google maps on Nokia phone ? My phone Nokia 5800 Xpress Music. When I take send to the no. it says Invalid phone no. Please help. Google maps is not available on Ovi store too.

Its available on our S60 phones :D but not on Nokia Store.

Use your phone's Wi-Fi or 3G/EDGE connection to go to m.google.com and choose Maps from there. Then you can download maps from there on the phone itself.

Google's New Privacy Policy change, Good or Bad ?

Google Privacy policy change is a bit of concern for some sectors but people ignore that Facebook has openly admitted that it tracks user browsing pattern even if they are logged out and keeps pages long data about their customers. I personally trust Google as my email IDs been with them since a long time and nothing wrong happened to me till date. I continue to use Gmail and has no plans to stop as other services are not so popular. My contacts are on gtalk and I will be using it onwards. It is a bit of concern that is someone else bought Google, they may be not like the current management. But we must not forget that all those internet is built on Google's money. The search we do, the sites which offer free guides and solution through search results, the web industry and people who depend on that for livelihood etc. It would not have been possible for every individual to get ads for a useful site and imagine a life without Google. Google of course is doing a business and it earns heavily from it, but on the other side, we are getting benefited 10 fold that too for free.

If some other provider was in Google's place, first 10 searches per day will be free and then Rs. 10 or $ 1 per search. That is how things still work outside. Free is something we started to hear after Google. Though I would like people to make their concern reach Google and they take some steps to lessen the concern, it would be a bit harsh to criticize Google when it asks in Google Chrome that would you like to keep as default search engine for Chrome. Which other browser asks us whether or not to choose a provider that is not as profitable as the search page they offer ?