Pages

Monday, September 10, 2012

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.

Sunday, September 9, 2012

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 ?