How-to-Guide

How to create MySQL database

MySQL is one of the most popular database which is used for php based sites, like WordPress, Question2Answer. Here are simple steps to create MySQL database and grant required permissions to database user.

After above step you will see MySQL prompt.
mysql>

Create database
mysql> create database NEWDB;

Add user with password for database
mysql> grant usage on *.* to NEWDBADMIN@localhost identified by ‘YOURSTRONGPASSWORD’;

Grant all permissions for NEWDBADMIN user
mysql> grant all privileges on NEWDB.* to NEWDBADMIN@localhost;

You can use above credentials in wp-config.php for WordPress or qa-config.php for Question2Answer and install.

How to encrypt text files using Notepad++

Encryption is necessary if the document is very important. There are so many text editors, but Generally many professionals use a popular text editor Notepad++. we can encrypt the text or whole document in the notepad with a simple plugin, NppCrypt. so its unreadable to user without password.

Step 1:
Download and install Notepad++

Step 2:
Visit Notepad++ plugin collection and download NppCrypt Plugin from the given list. Extract the nppcrypt.dll file to your ‘programFiles/Notepad+ +/plugins’ folder to install this plugin.

Step 3:
for encryption select the text or to encrypt whole document don’t select text. and go to Plugins–>NppCrypt–>Encrypt

Step 4:
Select the type of cipher and choose Strong passwordfor the decryption. ie whenever you want to decrypt the selected text you need this password. Press Ok and the text encrypted.

Step 5:
Similarly for decryption go to Plugins–>NppCrypt–>Decrypt and enter the password which you set at the time of encryption. press ok. the text gets decrypted.

For step by step guide watch below video

Do you know, your Facebook account has 3 Passwords?

Its interesting and I found accidentally. Facebook allows us to log in to our account by using 3 passwords. and many users are not aware of this feature. Don’t get shocked. This is purposefully done by Facebook to simplify the login process.

You may surprise but one is the main password that you created and other 2 passwords can be constructed by changing case of characters from your main password.

1. Main Password:

for example your original password is ‘passWord‘. (Password should be strong enough, Click for guide) . and obviously you can login to your facebok account by using your original password. 😉

2. Inverted Caps:

Here is your second password, that is toggled letters of your original password. Upper case letter will be in lower case and lower case letter will be upper case letter. This feature is provided if mistakenly you kept your capslock on. so there is no need to re type the password again. ie PASSwORD.

3. Beginning letters capitalized:

The third type of password is mainly useful for mobile users.as you know mobile phone automatically by default types first letter in CAPS. facebook takes care of this condition of also.so mobile phone users no need to worry! ie third password will be PassWord.

These are the three different passwords that allows you to login to your facebook account.

1. passWord

2.PASSwORD

3.PassWord

Do you want to try these variations with your own password on the Facebook? login screen available at facebook.com/login.php.

Someone asked me is it allow to use multiple user names to login to facebook?

and my answer is Yes! Facebook is crazy. you can login to your Facebook account by using three different usernames too.

1. Your email id. eg android@gmail.com
2. Your Facebook user name in vanity url. such as https://www.facebook.com/Android. here Android is your user name.
3. Your mobile number .eg. +1234567890
If you have registered your cell phone number with facebook then you can login by using that also.

Which combination of user name and password do you use for login your facebook account?

How to Download Entire Website ?

Many time you don’t want just an article from a website but the whole /entire website. Its useful when there is no internet connectivity or server is down. Its important for research students, teachers in remote area to have access to particular contents from a website.

Whats the easiest way to donwload entire website to your hard drive and access it offline?

There is a great tool for downloading entire website. HATTRACK.

It allows you to download a World Wide Web site from the Internet to a local directory, building recursively all directories, getting HTML, images, and other files from the server to your computer. HTTrack arranges the original site’s relative link-structure. Simply open a page of the “mirrored” website in your browser, and you can browse the site from link to link, as if you were viewing it online. HTTrack can also update an existing mirrored site, and resume interrupted downloads. HTTrack is fully configurable, and has an integrated help system.

This tool is available for windows 2000/xp/vista/7 and Linux/ unix/ BSD

Let me know your views in comment. and if you like this trick then don’t hesitate to share it with your friends and family.

Tricks to Hide Any files inside the Image

The art and science of writing hidden messages in the image is known as steganography. Its the safe and cool way to pass your message to your loved ones with out knowledge of anyone else.

Can’t believe?? save the above image on your desktop and open it with WinRAR OR WinZip. See the magic. 🙂

Hiding data inside the image was never easy task but below tricks will show how to do this quickly and easily.

Below trick uses JPEG(JPG) image to store any data inside it. when i say any data means literally any file, .txt, .doc, .ppt, .exe, .pdf,.mp3 and so on..

Step 1 :

Take a JPEG and a text file for this trick. you can use any file instead of .txt, I have taken it for the sake of easy understanding. save it on C:\> drive

Step 2:

Now compress these two files to .zip or .rar file. save all these files on C:\ drive

Step 3:

Now go to command prompt.
start–> run–> type ‘cmd’ and press Enter.
start–> type ‘cmd’ and press Enter. (for windows 7)
a command prompt will open. go to C:\> by pressing cd..

Step 4:

Now combine image and .RAR OR .ZIP file to create new image, this new image will look same as original image. in command prompt, Type

c:\>copy /b monalisa.JPEG+secretMessage.rar NewMonalisa.jpeg

press Enter.

It will create new image same as original image but now its with the .rar file embedded inside it.Note that size of new image has increased.

[For enthusiasts /b converts the files in to binary format ie 010101.. thats why its possible to add .rar file in the image.]

Done!!

But how to Extract the data from that image?

Its also very simple Just open that image file with winRAR or change its extension from .jpeg to .RAR and
open that compressed file to your PC.

Thats it !! Good Luck !

Let me know your views in comment. and if you like this trick then don’t hesitate to share it with your friends and family.