Monday, 28 October 2013

Error: #1045 - Access denied for user 'root'@'localhost' (using password: NO)

Error: #1045 - Access denied for user 'root'@'localhost' (using password: NO)



Error: #1045 - occur when you already installed mysql with password.
After that when you will install wamp server then you will get this error.


Here is a solution for this problem:Just follow some simple steps :



1. Open C:\wamp 


2. Then open apps  folder.

3. Then open phpmyadmin3.2.0.1  folder.

4. Then you will find config.inc  file.

5. Open this file with dream weaver

6. Find $cfg['Servers'][$i]['password'] = '';

7. Replace with $cfg['Servers'][$i]['password'] = '123';   (Here 123 is password of mysql)

8.Then Find $cfg['Servers'][$i]['AllowNoPassword'] = true;

9. Replace with $cfg['Servers'][$i]['AllowNoPassword'] = false;

10. Then restart all services.

11. Enjoy.

Monday, 5 August 2013

Calculate your aggregate percentage of B.Tech. according to GBTU norms.


Calculate your aggregate %age of B.Tech. till third year according to GBTU norms.
 
Enter Your Total marks of first year
Enter Your Total marks of Second year
Enter Your Total marks of Third year
Your Aggregate %age is :



Calculate your aggregate %age of B.Tech. till final year according to GBTU norms.

Enter Your Total marks of first year
Enter Your Total marks of Second year
Enter Your Total marks of Third year
Enter Your Total marks of Fourth year
Your Aggregate %age is:







For Lateral Entry Student


Calculate Your Aggregate %age of B-Tech Till 3rd year According to GBTU Norms.

Enter Your Total Marks of Second Year
Enter Your Total Marks of Third Year
Your Aggregate %age is:

 For Lateral Entry Student

Calculate Your Aggregate %age of B-Tech Till Final year According to GBTU Norms.

Enter Your Total Marks of Second Year
Enter Your Total Marks of Third Year
Enter Your Total Marks of Fourth Year
Your Aggregate %age is:

Thursday, 28 February 2013

How to Shutdown a computer with a cellphone/email


In this tutorial, I am going to teach you how you can control your computer’s basic function using Microsoft Outlook and your Cell Phone Network. For this tutorial I am demonstrating how a user can shutdown, restart, hibernate their computer, just by sending an email from their phone.
To make this happen, all you need is Microsoft Outlook installed on the PC which you want to control from your cell phone
Now let’s begin with the tutorial.

First, you need the batch files to perform the Shutdown, Hibernate operation.
For example,
shutdown -r -t 10 -c “shutting down”
Copy this code and paste it in notepad, save it as shutdown.bat
Now open up Microsoft Outlook. I am assuming that you have already configured it for your Email and I am not going to teach you about setting mail in Microsoft Outlook. Now we will need to make it so that Outlook checks your inbox about every minute.
You can do this by going to Tools>Options. Then click on Mail Setup tab, and then, the Send/Receive button.
 
Make sure that the Schedule an automatic send/receive every… box is checked, and set the number of minutes to 1 or anytime you may like. Now you may close all of these dialog boxes.

Now go to Tools>Rules and Alerts. Click on E-mail Rules tab. In new window select Check messages when they arrive and click Next.







Now in next page, check on, on this machine only and with specific words in the subject.
After checking these two values, click on specific words underlined.
 

 


Search Text window will open, in the input field type the command that shuts down the PC. You can use any commands. For prevention of accidental execution I kept %shutdown% as a command. Click on Add button after you are done and click on OK.
 
 


 
Now click on Next.
In the next window check mark on start application. In the lower screen, click on application link.
 
 
 



Now you’ll be welcomed to your familiar file open window. Load all files. And select the batch file that you’ve created to shutdown your PC.


If everything went well you’ll see the screen similar to below:






Click on Next, again click on next (don’t choose any things in this step). And finally click on Finish button.


 
You’ll have %shutdown% alert shown in the E-mail Rules tab.
 

 


 
Now, when you send a message from your phone to your e-mail address with the Subject  %shutdown%your computer will trigger shutdown.bat file and instantly executes the command in that batch file finally leading to shutdown the PC.
You can use any batch file to execute any command.