WampServer

I checked apache and Mysql services they are fine. But it is not turning green.

I am running wamp2.2e on windowsxp 32 bit

If it is Orange, then one of the services has not started.

look at wampmanager -> Apache -> Service -> Start resune service
If that link is GREEN then Aapche has not started


look at wampmanager -> MySQL -> Service -> Start resune service
If that link is GREEN then MySQL has not started


Which one is it?

Apache is still green even though I am giving start/resume its not turning green.

two times i uninstalled and installed the WAMP same problem. I am losing stored earlier data too.

One more thing how to connect to remote server from wamp.

I am creating a database and want to see how to search page get connected to mysql database

Something else has allocated port 80 !

Run this:

wampmanager -> Apache -> Service -> Test port 80.

This will launch a command window and report what has got port 80 allocated.
If yuo cannot sort the probelm out yourself then port back here what is using port 80.

I have 4 tables in mysql database.

In the search.php file when I type the name and say search no results are displayed.

plz help me and tell me how to overcome this.

I hvae set password to mysql to mysql DB in sql buddy.

Is this this the main reason?

I am also unable to open phpnyadmin also.

if you install 64 bit wamp ,then uninstall it and install 32 bit

1. MySQL is delivered in a default state, in this state it only has one User defined, that user is 'root' and it has No password defined. It looks like there are actually 3 'root' users when you view users with phpMyAdmin, but its actually one user that is allowed to login from 3 locations i.e. ip address's localhost, 127.0.0.1 and ::1 and localhost.

2. It is very insecure to leave it in that state as everybody knows what your superuser accounts userid and password is, so people use phpMyAdmin to change one or hopefully all the 3 'root' users password.

This all goes smoothly until they try to go back to phpMyAdmin to create there first database. Now they cannot get in as the root user has a password but they have forgotten to tell the phpMyAdmin application what that new password is.

phpMyAdmin is in fact just a php application. In order for it to gain access to the mysql system it needs a userid and password. It is configured by default to expect the default state of mysql i.e. a user account called 'root' with no password.


So what you have to do is edit the phpMyAdmin config file to inform it what the new password is. To do this you edit c:\wamp\apps\phpmyadmin3.x.y\config.inc.php

The normal instruction is to change these parameters like this:
From:
This says the userid to use is 'root', there is no password, and you are aloowed to use a userid without a password
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['AllowNoPassword'] = true;

To:
This says the userid is 'root', the password is 'whatever you created as a password', and stops phpMyAdmin allowing the user of userids with no password.
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'your new password';
$cfg['Servers'][$i]['AllowNoPassword'] = false;


My personal preference is to use these parameters instead:

$cfg['Servers'][$i]['auth_type'] = 'http';
$cfg['Servers'][$i]['user'] = '';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['AllowNoPassword'] = false;

This makes phpMyAdmin throw a userid/password challenge dialog every time you try to login.
You would use root as the userid and 'the password you setup' as the password.

I think this is even more secure as even if someone has access to your PC they cannot edit this file to see your super user password, as it is not actually recorded. It does mean you have to rememer it as once forgotten you are into a whole heep of hassle to get back into mysql.

Thank you i will surely check with this