WampServer

Hi

I had to reinstall WAMPserver as my installation had stopped functioning (no idea why). I have done this before with no problems, but I am now getting the above message and can't access any of my sites.

Any suggestions?

Dave



Edited 1 time(s). Last edit at 04/19/2012 11:21AM by DaveinSpain.

have a look at this.

[forum.wampserver.com]

see if it helps

RiggsFolly Wrote:
-------------------------------------------------------
> have a look at this.
>
> [forum.wampserver.com]
>
> see if it helps


Thanks for that. It has been of some help in that I can now access my sites by removing localhost and typing 127.0.0.1 in the location bar, but the system steadfastly refuses properly address localhost correctly, regardless of what I do with the DNS client settings. I have even tried using "ipconfig /flushdns" from the commad line. I have been using WAMPServer for 4 years and this hasn't happened before, so I guess that it is down to dear old Microsoft again, sending updates to make problems for them to fix next time.

Dave

can i take a look using teamviewer?

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

I managed to resolve this as follows:

I switched off all services in WAMPserver then went to C:\windows\system32\drivers\etc and opened the
‘hosts’ file

At the bottom of the file I found this:
127.0.0.1 localhost
::1 localhost
127.0.0.1 localhost
127.0.0.1 localhost
127.0.0.1 localhost
127.0.0.1 localhost

I changed it to this:
127.0.0.1 localhost
127.0.0.1 localhost
127.0.0.1 localhost
127.0.0.1 localhost
127.0.0.1 localhost
127.0.0.1 localhost

Then I did ipconfig /flushdns from the command prompt, started all services in WAMPserver

Success!

You only need 1 of those 127.0.0.1 localhost lines.


It looks like something you have installed and reinstalled has duplicated that line unnecessarily.

Hello,

I too am a newbee. I have read all the above .. I am getting the same error. I looked in the file mentioned above on my machine and this is what I see..

127.0.0.1 localhost
::1 localhost

127.0.0.1 localhost

I tried to delete the ::1 localhost and save my file but my computer said I do not have permission. I tried to change the permissions and then it tells me I could cause security problems with the root directory.

Do I change the permissions then save this file then change the permissions back?

Please help me.. my phpadmin will not function because of this error.


Thank you
Andi

Andi,

Remove the line

::1 localhost

that is for IPV6 and you dont need it, in fact it confuses everything currently.

Move the file to the desktop. Edit it . Move it back

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Good Morning Steven,

Thank you very much!!! Yeah!! I did as you suggested and I am now past the 403 error.

phpAdmin is trying to hook up to mySql but doesn't like my password setup.
I did the steps in my sql to grant permission to root and added a password. I am confused..

Welcome to phpMyAdmin
Error

MySQL said:
#1045 - Access denied for user 'root'@'localhost' (using password: YES)

phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

I also in the config.inc.php have
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '69867';
$cfg['Servers'][$i]['AllowNoPassword'] = true;
set like the above.
I am confused.

Thank you for you help.
Andi

Remove ur password and change it back to false

Clear the browser history.

Log in to phpmyadmin

Click privileges - set a password for the user

Root @ localhost


Edit the file again with ur details

Clear browser history

Try again

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

In the phpmyadmin file I change it back. I stopped and started the services in the wampler but it won't go to green it only goes to orange.. I did try to open phpmyadmin and still get errors.

Andi

I am sorry... I know I am making this more difficult .. I changed as you requested.

the file I changed is config.inc.php. I change it back to spaces for the password and I in frustration saved as 'true' and 'false' testing both ways. and still I get the error.

Is there some other file I need to change like the config.php? Should I have not given my sql passwords?


Andi

I read this on a different website: I followed the instructions and still I am not granted access to phpadmin.
I am probably making life harder.. you know the more I learn the dumber I feel.

Andi


Many thanks fellas.
Thanks to you things are swimming again and everything is rosy.
And Longneck I've left a pint of Guinness for you at the bar!

For any other fellow newbies here is the whole fix:-
mysql>UPDATE mysql.user
->SET Password=PASSWORD("*******"
->WHERE User="root";
mysql>FLUSH PRIVILEGES;

This is from Sitepoint's "Build your own Database Driven Website using PHP and MYSQL"

And then as Longneck said specify the password in the config.inc.php file for phpmyadmin.

Kind regards,
Dermot.

Hi,

I uninstalled and reinstalled WAMP. I am now getting this error message:

Error

MySQL said:
#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured.

the port and socket in the config.inc.php is set to

$cfg['Servers'][$i]['port'] = '80';
$cfg['Servers'][$i]['socket'] = '3306';

I do not know whether these are correct or not.

Please let me know.

Thank you for your help.
Andi

Hi again...

I wanted to give you an update.

I no longer get an error message when selecting phpadmin from the menu. All I get is a browser window with 'localhost' as the title and the little circle goes round and round trying to hook up.

everything works on this WAMP menu except the phpadmin.

In my newly created database; I created one row in my new table from the sql monitor and one row from the SQLbuddy. When trying to run php script to insert a row it doesn't.

I appreciate any help you can give me on this.

I have been doing a lot of reading and it sounds like this is happening a lot and there is not one set cureall.

Thanks again,
Andi

I tried it again and now I get a sql error:


MySQL said:
Cannot connect: invalid settings.

phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

I have a password for sql.. so when I sign in I have to enter a password.

I copied the below sentence from another post. Please tell me where I can find these instructions.

"Actually, you should follow step 6 from my Setup Password guide on my personal websites"

I have struggled for several days with this.

In some of the posts you talk about cleaning out registers.. where do I do that..
I am sorry I am a newbe and need help.

thank you for any help you can give me.
Andi

I read your document "RiggsFolly" and I changed my config.inc.php file as written in under number 3 option 2. because option 1 was not working for me.. well option 2 does not work for me either. I also restarting the DNS client.

I don't know what else to do.

Thank you,
Charmaine

Not sure where you are now so see if this helps.


By default ( out of the wamp box ) mysql comes with a userid of 'root' which has no password.

in x:\wamp\apps\phpmyadminx.y.z is a file called config.inc.php

This file is used by phpmyadmin to login to the mysql database server.
It comes with the following parameters set

/* Server: localhost [1] */
$i++;
$cfg['Servers'][$i]['verbose'] = 'localhost';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['AllowNoPassword'] = true;

/* End of servers configuration */

which say login with user 'root' and use no password and also that no password is allowed 'AllowNoPassword' = true


If you have used some other tool to change the root user or even remove it completely then of course this config will not work.

So if you have added a password to 'root' using another tool you must change the config accordingly.

If you have removed the 'root' userid you must amend the config accordingly to use the new super user account you set up.

If you removed 'root' and did not setup a new super admin user then you are 'up a creek without the proverbial paddle'. So start again.

now you say in your last post

Quote

I have a password for sql.. so when I sign in I have to enter a password.

Now the question is, what userid did you set a password on and what was the password?
If the userid is root then change the ['password'] = parameter

If the userid is something else change the ['user'] = '' and ['password'] ='' to the new values.

if this is no help, then lets have a littel more information about what your current problem is.

I uninstalled and reinstalled 3 or 4 times trying to follow the instructions. When I first download it I go to phpadmin and get the error.. right now I am defragging my computer.. After I uninstalled WAMP the last time I installed the other one X something.. I ended up not getting any of the software but instead getting a lot of malware.. I have been trying to get that all cleaned off my computer.

After my defrag is done I will try again. Is there anything I need to do before downloading it to make sure my harddrive is clean.. so any of the previous files that I uninstalled will not be clouding things?

I appreciate any help on this,
Andi