Power Capacity of USB Ports

Previously, i wrote about the hack to enable and disable USB and also the simple way to know if you have a USB1.1 or a USB 2.0 on your PC. In this post which is also about USB or the Universal Serial Bus, i share with you an interesting finding. I often come across USB ports which are filled up with USB hubs that are further packed with USB devices. Such scenarios are becoming common these days with most of the electronic devices offering USB support. However, in such scenarios, the thing to remember is the power capacity of USB ports .

A single USB root hub, which typically supports two USB ports on a PC’s motherboard, delivers a maximum of 500 miliamps (500 mA) of electricity to its attached devices. In case, if the power demand exceeds this figure, the possibility of the entire USB bus shutting down is huge.

If you are using Windows XP, you can check the power needs of your USB port by following the steps mentioned below

1.) Right Click ‘My Computer’ and select Manage.

2.) From the Computer Management window, select Device Manager.

3.) Under Universal Serial Bus Controllers double click each instance of USB Root Hub.

Ensure that your USB devices are not underpowered.

4.) Select the Power tab for each one. This tab displays the power being used by each USB port or the device attached.

Follow me on Twitter at http://twitter.com/vaibhav1981

Do stay tuned to Technofriends for more, one of the best ways of doing so is by subscribing to our feeds. You can subscribe to Technofriends feed by clicking here.

Cheers

Vaibhav

Some interesting reads from the Blogosphere

If you haven’t yet read these great posts, go ahead and give them a Read.

1.) Best practices when moving your site : This great post from the Google Webmaster Blog explains the best practices to follow when moving your site so that you don’t end up hurting your site’s performance in Google Search results.

2.) New Facebook Feature: Import Your Digg Stories! : This blogpost is about the new feature introduced by Facebook. This allows you to import your Digg Stories to your Facebook mini feed.

3.) Get Your Database Under Version Control : Databases are critical part of our applications. This post is about the importance of getting your Database under version control.

4.) 24 Killer plugins for your WordPress blog : This interesting post by Mani ( I met him at the BCB6 camp) talks about 24 plugins which you should use in your WordPress blog.

5.) Fix Your Broken Outlook Personal Folders (PST) File : Read this interesting post to fix your Broken Personal Folder files in Microsoft Outlook.

Do stay tuned to Technofriends for more, one of the best ways of doing so is by subscribing to our feeds. You can subscribe to Technofriends feed by clicking here.

You can also follow me on Twitter at http://twitter.com/vaibhav1981

Cheers

Vaibhav

2 Interesting Google Hacks

This post is about refining your search results in Google using 2 interesting hacks. When doing a Google search, you can refine your search and eliminate a number of irrelevant search results by using the intitle: and intext: commands.

intitle: ‘intitle’ only looks for text that’s in the title of a webpage. In this case, title doesn’t mean the title on a page. It’s essentially the text between the <title> </title> tags in the HTML code of a web page. Therefore, lets assume you want to search for information on say ‘ Learn Java’, type intitle:”Learn Java” in the Google Searchbar or Searchbox. ( See figure below)

Google hack for searching the title of a post.

intext: ‘intext’ searches the body of the webpage for the text that you want to find. When intext: is specified in the search, Google ignores the text in any links or email addresses on the page, as well as the text in the page’s title. ( See figure below)

Google Intext Hack to search for text in Webpages.

Interested readers can go ahead and read on my post on some interesting Gmail Hacks. Also, another old post which describes the method of finding IP Address of the sender in Gmail might interest you.

Do stay tuned to Technofriends for more, one of the best ways of doing so is by subscribing to our feeds. You can subscribe to Technofriends feed by clicking here.

You can also follow me on Twitter at http://twitter.com/vaibhav1981

Cheers

Vaibhav

[How-To] Create and Delete Users in MySQL

MYSQL which forms the M of the LAMP series is a widely used open source relational database management system (RDBMS).
While working on a project, i learnt that some of the developers who were too much addicted with tools like PhpMyAdmin didn’t actually know how to create / delete users from a command line. For the information of them and for all others, this is the post to read.

MYSQL Logo

Creating Users
First and the foremost thing to know, if you wish to create users on your MySQL engine, you must have sufficient administrator rights. Specifically speaking, you must have the privilege either for CREATE USER or INSERT privilege on the mysql database.
CREATE USER user@host IDENTIFIED BY 'password';

To create a user that can connect to a MySQL database running on the local machine, use localhost.
CREATE USER 'technofriends'@'localhost' IDENTIFIED BY 'matrix';

Typically in a web application scenario, one allows access to database from a script using a single MySQL username and password, even if the web application performs additional user authentication.

It must be noted that CREATE USER command was added in the MySQL version 5.0.2. In earlier versions, users could be created automatically when assigning permissions using the GRANT command or by manually inserting records in the mysql database.

The mysql database contains three tables – user, host and db. These tables contains the database permissions.

The user table contains the usernames and password combination of anyone who has access to any part of the MYSQL database. The password part is the encrypted string, which can be generated using the PASSWORD() function.

As an administrator, you can even directly insert the values into the user table of mysql database and get the desired results.
INSERT INTO user(Host,User,Password) VALUES('localhost', 'technofriends', PASSWORD('matrix'));
FLUSH PRIVILEGES;

The FLUSH PRIVILEGES command is required to inform MySQL to reload the privilege data after the change is made.

Deleting Users

To delete users from the MySQL database use the DROP command.
DROP USER user@host;

The command in turn removes the user record from the mysql.user table.

As the CREATE USER command, even the DROP USER command has been added since MySQL 5.0.2. In previous versions of MySQL you must revoke the user’s privileges first, delete the records from user manually and then issue the FLUSH PRIVILEGES command.

DELETE FROM user WHERE User= 'technofriends' AND Host= 'localhost';
FLUSH PRIVILEGES;


This brings me to the end of this post. I would suggest visiting this link from MySQL Reference manual to all those interested in knowing more.

Also read:

How not to get Phished,Learn from Phil the Fish

Bluetooth hacking: Essential tools.

Spoofing Explained : Another attempt to cover Hacking fundas

Learn to Hack )

Do stay tuned to Technofriends for more, one of the best ways of doing so is by subscribing to our feeds. You can subscribe to Technofriends feed by clicking here.

Cheers

Vaibhav

IT Knowledge Exchange: A free edition of Experts Exchange

Experts Exchange is one of the famous and most used forum for all IT related issues/problems. However, as this forum happens to be a paid one; there have been many attempts to crack open its authentication mechanism so as to allow free access. Over the months, i have found atleast 3-5 different ways mentioned in various blogs like this and this and this. This clearly shows the interest in getting quality solutions for free. In order to get free solutions to your problems, i would suggest using IT Knowledge Exchange.

IT Knowledge Exchange

IT Knowledge Exchange is part of the TechTarget network of technology focused sites and as per the website was created to allow IT professionals to ask questions and get answers in a collaborative manner.

IT Knowledge Exchange was created to allow IT pros to ask questions, get answers,
collaborate and exchange knowledge with their peers. Whether you are looking for
an answer to an IT problem that has got you stuck or feel like helping your peers
by answering their questions, IT Knowledge Exchange allows you to easily find the
answer you are looking for.

IT Knowledge Exchange has a huge variety of questions. Users get points and ratings to answer the questions. Its definitely worth a try for all your IT related doubts. Go ahead and give it a try, am sure you would like it.
Also read: [How- To] Calculate Equated Monthly Installment using MS Excel

Google Code University: Learn programming the Google way

How-To: Create Basic Charts using Microsoft Excel

MS Office Fun: Excel Games

How-To: Copy Excel cells into a Word document

Do stay tuned to Technofriends for more, one of the best ways of doing so is by subscribing to our feeds. You can subscribe to Technofriends feed by clicking here.

Cheers

Vaibhav

What is Twitter?

I found this interesting video from CommonCraft which talks about Twitter in Plain English. A must for all those who are still not there on Twitter because of their own conceptions about it. A good watch for those who are already on board.

For those of you viewing this post on your reader software, please click here

By the way, you can follow me on Twitter by clicking here

Also read :PollDaddy launches Twitter Polls

Use Twitter to Publicize your blog

Twitter and Productivity.

RSS in Plain English

Do stay tuned to Technofriends for more, one of the best ways of doing so is by subscribing to our feeds. You can subscribe to Technofriends feed by clicking here.

Cheers

Vaibhav

How does a Blackberry device work?

In this post, i would like to share with you the working of a blackberry device. Many people i know use Blackberry devices for e-mail purposes. However, almost Ninety-five percent of them are unaware of its working mechanism. I derive the motivation of this post from them.

Blackberry

As we all know, there is always a software behind the hardware. This holds true for the blackberry as well. Blackberry Server Software comes in two forms

  1. BlackBerry Professional Software (BPS)
  2. BlackBerry Enterprise Server (BES)

The way that the BlackBerry server works applies to both the BlackBerry Professional Software (BPS) and the BlackBerry Enterprise Server (BES)

The basic steps in receiving an email on a blackberry device are as follows:

Blackberry Architecture

[Image Source: McGill.ca ]

  1. The email message is sent.
  2. Message arrives at your email server ( usually the exchange server) and is sent as normal to your PC/ Laptop.
  3. The BlackBerry server ( the mail is delivered using a “push” concept to the Blackberry Enterprise Server) compresses, encrypts and forwards the message automatically to your BlackBerry handset.
  4. Message arrives at the BlackBerry via the Internet and the mobile carrier’s network.
  5. The Blackberry handheld device receives, decrypts and decompresses the email, and alerts the user.

When you buy a BlackBerry handheld you can download for FREE a fully-functional version of BlackBerry Professional Software (BPS) for your existing email server. BlackBerry Professional Software Express (BPS Express) is a FREE download of BlackBerry Professional Software that can support up to 30 BlackBerry users connecting to their email server.

The FREE download includes:

  • A copy of BlackBerry Professional Software, with the capacity to support up to 30 users
  • One user license – Client Access License (CAL
  • The latest version of BlackBerry Enterprise Server Solution software, version 4.1

BPS Express is the ideal solution for smaller organisations with their own email server or for larger organisations that arent sure how many BlackBerry users they will grow to.

To expand the number of users you simply purchase additional user licenses as your needs grows. And if you reach the point where you need more than 30 users, you can upgrade to the BlackBerry Enterprise Server (BES).

To download and configure the Blackberry Professional Software Express for your blackberry, follow this link.

BlackBerry Enterprise Server is the fully-featured BlackBerry mobile email service. It’s designed for medium to large organisations with their own Lotus Domino or Microsoft Exchange servers for email and mobile data applications, that are going to start with at least 20 users and grow from there.

BlackBerry Enterprise Server lets the user access his/her email, electronic calendar, tasks list and contacts list as well as any internal applications or software on their BlackBerry handheld.

The BlackBerry Enterprise Server supports triple DES security (considered unbreakable) so confidential data is transmitted securely.

For blackberry usage and applications, i would suggest you go through the below mentioned links.

  • Also follow Kelly Carter’s blog called My Blackberry Pearl 8130. Kelly talks about the tricks, tips and various Blackberry applications.

Hope you enjoyed reading this post.

Also read:

[How-To] Get more from your iPod Battery

Send Free SMS using Yahoo Mail

How-To: Save your mobile battery

IMEI: What is it?

Do stay tuned to Technofriends for more, one of the best ways of doing so is by subscribing to our feeds. You can subscribe to Technofriends feed by clicking here.

Cheers

Vaibhav