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.