Earn As You Learn VIA Blog

Learning is a long term process and as you learn you will get the power of knowledge. Getting paid as you learn are not always possible and especially through blogging. There are case where people may be stopped from learning all due to short of money, which is great blunder. So its always well and good to earn a little as we learn so that it can aid us a lot for uninterrupted march upward in life.

In the search of earning while learning i found some interesting site. I wish to talk a lot about it and here in this post i will take a short trip into earning as you learn. Before i start let me make a note that its not all about making money but its all about earning for learning.

In the search for a better place to earn i found payingpost site, where we get paid to post.
However you are not going to move away from the theme of your blog because as you register (which is free) you are given option to choose opportunities as per your interest of your blog.



Payingpost not just preserves your interest but also provide lot of features like best user friendly layout site. They keep their site live with lots of great stuff and its stylish too. Everyone is given option to get registered as a advertiser or as a blogger. Paying post also provide you affiliation program which brings dollar to your finance.

Payingpost has also said that i would come up with much interesting stuff like sms alert when any new opportunities are available as per our interest.Payingpost also takes care that it will correct if any problem occurs by mailing to support[at]payingpost.com.If you wish to know more about payingpost before joining then just visit the payingpost blog where you get the most about earning through blogging.

All you will have to do is to post a review about any of the opportunities available to you which is simple as advertising on blog. This way of advertising brings a great market to blogging. I hope payingpost would be very helpful to add to your pocket some finance.

Online Resource for Web learning

Books are always the best partner who can let you know more and more about anything you wish to learn. Books from Deitel and Associates are my most favourite books for learning web programming language.

At Deitel site you can get to know most about web 2.0 and web service related article. If you are a registered user, which is just free of charge, you can get access to download of examples from their books. Here is the reference to deitel site ..external link

Some of his popular books include:
C How to Program, 5/e
C++ How to Program, 6/e
Visual C# 2008 How to Program, 3/e
Internet & World Wide Web How to Program, 4/e
Java How to Program, 7/e
Visual Basic 2008 How to Program

and many more..Never forget to check the link.

Client does not support authentication protocol requested by server; consider upgrading MySQL client

I got this error at the very initial step of my hosting process. And as i searched through the documentation in mysql, i found that this error is caused basically due to compatibility problem between the client and server version. As an effective step to remove this problem mysql community suggest four possible action.

I am not going to explain each of the possibilities but i wish to refer to link where i found the solution, external link . Hope you found your solution.

Can't connect to MySQL server on 'localhost' (10061)

Such an error is caused basically when no mysql client is installed on the domain in which you are working, with the localhost as the option during installation( i hope so).

If you have arrived at this link only because you have got such an error with your mysql server and you need much more detail, then go for any other reference on this problem. I am sorry to say this because i am going to just tell about the problem which caused me such an error and the simple mistake which i committed and rolled back after a short tutor from my hosting documents to correct this problem.

As i worked through the document for my hosting site i found that i should use the host mentioned specifically for my hosting, which is like 'host.domain.extension:port_no'. As i changed the hostname from localhost to the said hostname, my problem got cleared.

So ensure that usage of localhost is appropriate for you or not.

Create user in mysql database

Often it is necessary to maintain individual profile and access privileges for each user. Mysql database provide many query statement to create user ,grant user privileges and revoke privileges.
Lets learn some of the queries to create a user, grant access permission for user and revoke access.

Creating a user without password:
mysql> create user dbuser1;
Query OK, 0 rows affected (0.06 sec)

Creating a user with password:
mysql> create user dbuser2 identified by 'password';
Query OK, 0 rows affected (0.06 sec)

Setting password for a user with password():
mysql> set password for dbuser1 = password('password');
Query OK, 0 rows affected (0.01 sec)

Queries to give privileges to user are...

Global level:

GRANT ALL ON *.* TO 'dbuser'@'localhost';
GRANT ALL ON *.* TO 'dbuser';

Database level:

GRANT ALL ON mydb.* TO 'dbuser'@'localhost';
GRANT ALL ON mydb.* TO 'dbuser';

Table level:

GRANT ALL ON mydb.mytbl TO 'dbuser'@'localhost';
GRANT ALL ON mydb.mytbl TO 'dbuser';

For more information and example visit mysql doc