WampServer

I installed 2.0 then created several databases.
Then dropped those databases I created and installed a older version of php and mysql.

My configuration is:

Apache Version :
2.2.11
PHP Version :
5.2.9-2
MySQL Version :
5.0.51b
Error


When I browse to phpmyadmin I receive the following error:

SQL query: Edit

SHOW PLUGINS

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PLUGINS' at line 1

Not available in that mysql version...
See : [dev.mysql.com]

Florian

WampServer Patch (Screenshots)
Topic EN : www.wampserver.com
Topic FR : www.wampserver.com

hi,

you have to install an older phpmyadmin Version.

Here you get them:
[www.oldapps.com]

copy the extracted package to wamp/apps
and give the folder the name you like, maybe "phpmyadmin_2_9_1_5"

Then you have to tell apache, that there is another phpmyadmin Verion

In the Wamp-Menu choose Apache and there Alias Directories -> Add an alias

There you get a console, maybe use the console like its explained there or you just type blabla, finish the console and then go to wamp/alias in you windows-Explorer
and copy the content of the existing phpmyadmin.conf of the current phpmyadmin and paste it into the created "blabla.conf"-file(this is the file, the console created, but you can edit the file)
Now, that you copied the content of the current phpmyadmin.conf to the conf.File for our old phpmyadmin Verion you have to get the pathes right.

Take care of the slash before and take care that no slash is added behind(only in the first place):
Alias /phpmyadmin_for_mysql4_1 "c:/wamp/apps/phpmyadmin_2_9_1_5/"

Now you can access the old phpmyadmin via

[localhost]

and the new one via

[localhost]

IMPORTANT:

Change this lines in the "directory" Part:

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

to

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


Because it looks like open doors, don´t if it is, but better you change it...


Please remember that the new phpmyadmin can´t accesss the mySql 4.0.xx or others
You have to switch the mysql, before you use the new phpmyadmin.