WampServer

After a couple of mistakes, I have re-installed 2.Ob version (2.0f didn't seem to find my D but I can't access phpmyadmin, as I get the "you don't have permission ..." message.
I'm working on an only "locahost" computer and haven't changed anything, apart for desinstalling/re-installing Wampserver.
What is the problem and what can I do to make it work properly, as it has done for months before I tried to install the 2.0f version?

Thanks for helping.

[www.marie-noelle-augendre.com]

what colour is the wamp icon

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

The Wamp icon in white; and I can run pages that use the database.
Thanks for helping.

[www.marie-noelle-augendre.com]

i think there maybe just a small issue in ur phpmyadmin.conf file in c:/wamp/alias/phpmyadmin

post the file up here

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

Here it is :


Alias /phpmyadmin "c:/wamp/apps/phpmyadmin3.1.1/"

# to give access to phpmyadmin from outside
# replace the lines
#
# Order Deny,Allow
# Deny from all
# Allow from 127.0.0.1
#
# by
#
# Order Allow,Deny
# Allow from all
#

<Directory "c:/wamp/apps/phpmyadmin3.1.1/">
Options Indexes FollowSymLinks MultiViews
AllowOverride all
Order Deny,Allow
Deny from all
Allow from 127.0.0.1
</Directory>

[www.marie-noelle-augendre.com]

is the version of phpmuyadmin you have 3.1.1 ?


try ht tp://127.0.01/phpmyadmin

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

Where can I find the version number? I'm not authorized to launch phpmyadmin and I can't see it on the localhost home page.

[www.marie-noelle-augendre.com]

in the c:/wamp/apps folder
whats the exact name of the phpmyadmin folder


did u try 127.0.01/phpmyadmin?

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

The name of the phpmyadmin folder is phpmyadmin2.11.5
Does it match the Wampserver 2.0b version? or the 2.0f one? I tried to reinstall the 2.0b version because the new version doesn't seem to find my SQL base.

I don't know who is supposed to be 127.0.0.1
Anyway, 127.0.0.1/phpmyadmin doesn't work either.

[www.marie-noelle-augendre.com]

127.0.0.1 is localhost



anyway 2.11.5 doesnt match ur file so change the phpmyadmin.conf to




Alias /phpmyadmin "c:/wamp/apps/phpmyadmin2.11.5/"

# to give access to phpmyadmin from outside
# replace the lines
#
# Order Deny,Allow
# Deny from all
# Allow from 127.0.0.1
#
# by
#
# Order Allow,Deny
# Allow from all
#

<Directory "c:/wamp/apps/phpmyadmin2.11.5/">
Options Indexes FollowSymLinks MultiViews
AllowOverride all
Order Deny,Allow
Deny from all
Allow from 127.0.0.1
</Directory>

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

Great! That works ... once I thought to restart the services
Now I can make a backup of my database before re-upgrading Wampserver ... and see what else is left to be done to make it work properly.

Thanks a lot for having spent so much time on my problem, and provided a bunch of accurate answers. I've learnt a lot in the process.

Edit (a few minutes later): in fact, I had to change another line in the alias file, the one a bit lower about the directory. Fingers crossed...

[www.marie-noelle-augendre.com]



Edited 1 time(s). Last edit at 02/07/2009 06:29PM by mnaugendre.

Hopefully, this will be the last questions

I have successfully installed the last version of WampServer, but had to resort to the same modification in order to have access to phpmyadmin.

So, how can I use the new version of phpmyadmin? Same question for mysql, as my databases are still in the mysql5.0.51a folder?

[www.marie-noelle-augendre.com]

i had 2.11.5 in the directory line ...



2f comes with the nesest version of both,.. you should neeed to do anything,,,



just esport allyour databases in 2d and import to 2f - 2b was using MYISAM and 2F is not setup to use INNODB by default so you may ned to change this....

if you get any errors in the process post them up here

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

If I leave the phpmyadmin.conf as it comes with the package, I get a phpmyadmin homepage ("Bienvenue à phpMyAdmin", but with a message "Accès refusé" and cannot process further.

When I change the phpmyadmin.conf so it points to phpmyadmin2.11.5, I can see all my databases that are still in the mysql5.0.51a folder. I have them backuped as xxx.sql files, but how do I access the new mysql so I can import them?

[www.marie-noelle-augendre.com]

installed the new mysql?

then left click wamp icon > MYSQL >VERSION > and tick the one you want


then open phpmyadmin and import the databases

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

LOL ... I should do this more often; that would hopefully prevents me to ask so dumb questions and lose your time.
Works like a charm with the new mysql version.

Only thing left is the access problem with phpmyadmin 3.1.1. I've asked a question on the phpmyadmin french forum, but if you have one more good idea ...

Thanks a lot.

[www.marie-noelle-augendre.com]

i need the entire phpmyadmin error printed.


these is usually an error number like 2005 1603 etcc

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

There is no error number; it's just an information message: "Accès refusé" (= access denied) in a rectangular box with an "i" icon preceding it.
Over it is the "Bienvenue à phpMyAdmin" title; under is a horizontal line, followed by a link to open a new phpMyAdmin window.

[www.marie-noelle-augendre.com]

I eventually got the answer from the PhpMyAdmin support : [sourceforge.net]

For those who don't read french, this has to added to config.in.php :
$cfg['Servers'][$i]['AllowNoPasswordRoot'] = true;

and the problem will be solved.
I've also been told that the error message will be more comprehensible from the next version (3.2).

Thanks a lot for your cooperation.

[www.marie-noelle-augendre.com]