Next edition of Networking coming up...

Goggle mania:)

Hi All,

A very interesting trivia. A couple of days back I had this problem with my Gmail. I received mails which said the time stamp was 2 , all the mails that I received on that day. So I started imagining that may be google has some kind of bug. You can check all the information in your e-mail through the option of mail details.

So I remembered this interesting thing I learnt in class, you receive any data from the internet through a special port number assigned to that application from your operating system. Now say your private IP address is 192.168.1.34:4445 is the port number for the application running on your system. May be you are accessing google through the 66.102.7.78:80(HTTP webserver)..Check out netstat -a -n in your command prompt.

Now this might not be relevant to me trying to understand google's operation in the time set, but it just a flashed a idea in my mind... Now it got me thinking how is date getting set?

Not to derail from the point, which is that the information is extracted by google from your system time settings. Wow! and guess what my system time setting was 2 days behind...

Neat.. So there goes my little experience..:)

Beginner's Guide to WAMP server installation:Problems and fixes

These are some of the problems I encountered while setting up the WAMP  and how I fixed it.
While installing WAMP server always change the root password. 

Otherwise your security is compromised because of the default password settings. 

Remember MYSQL is just like a webserver, it can be accessed from any computer on the same network, depending on what your security measures are anyone in the world can access your MYSQL server.  

1. Sometimes you may encounter an error  'mysqladmin' is not recognized as an internal or external command, operable program or batch file.'  

What you should do in this situation is that enter -->the bin folder --->mysql folder in the bin folder ---> enter the bin folder in the mysql folder   

2.Now execute the following operations:  

The default password for root initially is set to null.

To set a password:  

a.Check the status of the Mysql server: 

mysqladmin -u root status  

Basic statistics about the Mysql server is obtained. 

Uptime: 102262 Threads: 1 Questions: 1 Slow queries: 0 

Opens: 15 Flush tables: 1 Open tables: 0 Queries per second avg: 0.0  

If you don't get this message. Check your installation again.  

b. The next step would be to execute to the following:  

mysqladmin -u root -p password "newpassword"  

Replace "newpassword" with whatever you wish to use for your Mysql server.  

When you hit enter you might be asked for the current password "PLEASE HIT ENTER AGAIN" because you don't have a current password for your root.  

c. Supposing you want to change your root password, go to mysql:  

SET PASSWORD FOR ROOT@LOCALHOST=PASSWORD('rubios');  

d. Suppose you forgot your root password for your mysql, follow the following steps:  

1.Log in as an administrator. Start menu->control panel->Administrative Tools->Services 

2.Here Just stop the Mysql Service. 

3.Type the following command into a text file: 

Update mysql.user set password=PASSWORD('Newpassword') where user='root'; 

FLUSH PRIVILEGES;  

Type the entire command in a single line and save it in a text file . (For example: Startpass.txt)  

4.Enter the command prompt and type the following command: 

C:\mysql\bin\mysqld-nt --init-file=C:\Startpass.txt  

This C:\Startpass.txt can be saved any location. This is just an example. The same implies to the location of the mysql.  

5. For higher versions of the Mysql the following commands may be added:(-defaults-file option)  

C:\"C:\mysql\bin\mysqld-nt.exe" 

--defaults-file="C:\mysql\my.ini" 

--init-file=C:\Startpass.txt  

6. Restart the Mysql service normally.    

Phpmyadmin issues:  

The best thing to do in a situation when the Phpmyadmin gives a lot of trouble is to reinstall the entire wamp server setup. 

Before doing that please try the following:  

--> Go to apps folder in the wamp folde. 

--> Go to phpmyadmin folder. Find the file "config.inc".  

--> Edit the password for root and set your new root password.  

The file is given below.