WampServer

Hello,

I've just installed the WAMP software from here: [www.wampserver.com]

It all installed just fine. I had a problem in that the W favicon was orange. It was a Skype issue, and I've now changed the port away from 80 to solve that problem.

However, I still get the problem I noticed with the link between phpMyAdmin and MySQL. I've read many other solutions to the problems around the Internet:
(1) Change the config file from mysqli to mysql
(2) Add a random password to the config file (I added it to the MySQL config file too)
(3) Changing the hosts to comment out the ::1 if there was one. (I commented it out.)
(4) Uninstalling and reinstalling the whole of the software.

None of these seems to have worked. Are there any other things I can try to fix it?



Edited 1 time(s). Last edit at 10/25/2012 03:31PM by alexholowczak.

You get this error if you used phpMyAdmin to set a password on the 'root' userid.

The default settings for phpMyAdmin expect no password on 'root'.

So edit this file
D:\wamp\apps\phpmyadmin3.5.1 ( version numbers may differ )

compare yours with these here, this will make phpMyAdmin throw a userid/password dialog when it is run
you woudl keyin root and [whatever the password is]


$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'] = 'http';
$cfg['Servers'][$i]['user'] = '';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['AllowNoPassword'] = false;
$cfg['Servers'][$i]['LogoutURL'] = 'http://localhost/';

Thanks for your reply; unfortunately this is one more to add to the list of things that didn't work.

I have also tried auth_type = 'cookie', and commenting out user and password, to no avail.

Get Teamviewer and ill fix it

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

Hi,

No need - Having applied the above fix, I pressed refresh and it worked!

Alex

I just tried this - I now get the following - any suggestions?
MySQL said:

Cannot connect: invalid settings.

you made a mistake if you got this error....

what did you change?

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

I couldn't get signed on this morning, so I changed some password settings (also prompted by a warning note to change the root password setting for security reasons) - that resulted in the 1045 error - then I followed the advice above changing the file as posted by RiggsFolly

can you get teamviewer and i will troubleshoot it?

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

I tried again last night and it worked. The only thing that I'd done in the meantime was close the browser and re-open it. I had previously closed the browser tab and stopped and started all services but that hadn't worked.
Thanks for your time!