WampServer

Hi,

I have connection problem to phpmyadmin when I change php version. I have created database when I had php 5.2,5 and if I swich to lower version < php 5 I can't connect to the database.
The error msg I get: #1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
How can I solve this?

Regards/Per



Edited 3 time(s). Last edit at 04/24/2008 12:02AM by psn.

Switch back to mysql 5.2.5 and use OLD_PASSWORD to setup password for user(s) that you want to use w/ older mysql

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

Where or how do I do this, in priviligies?

Regards/Per

Yep, or through mysql console

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

Ok fixed the login and when I open up phpmyadmin I get a warning (redcross cant load mysqli-extention, check your php settings) I have check my settings but I can't find this extention at all under 4.4.7. I can find it when I swich back to higher version. So question is what can I do to fix this part?

Regards/Per

open config.inc.php in c:wamp/apps/phpmyadmin

in it ul find a line


$cfg['Servers'][$i]['extension'] = 'mysqli'; // The php MySQL extension to use ('mysql' or 'mysqli')


and change it to

$cfg['Servers'][$i]['extension'] = 'mysql'; // The php MySQL extension to use ('mysql' or 'mysqli')

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

Ok but will this part not fail when I swich back to php5.2.5? Can't this be solved by automatic in the config file?

I mean is it possible to have this set depending on which version I run?

Regards/Per

it may fail...

maybe not tho


this phpmyadmin file is just php setting varibles

$cfg['Servers'][$i]['extension'] = 'mysqli'; // The php MySQL extension to use ('mysql' or 'mysqli')




so maybe add some php to check the verison of php running



$version=phpversion ();

if ($version>5) {$cfg['Servers'][$i]['extension'] = 'mysqli'; }

else {$cfg['Servers'][$i]['extension'] = 'mysql'; }





dont have time to code it properely but this shoud work,,, just check to see wat value u get for version,, it maybe be 5.2.2 and > may not relaise it as a number

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



Edited 1 time(s). Last edit at 04/24/2008 11:36PM by stevenmartin99.

Thxs this solved the problem.

One last quest, when I run now 4.4.7 I get also an info:
Your PHP MySQL mapversion 3.23.49 differ from your MySQL serverversion 5.0.45. This can course failure!

What does this means? Should I do something about this or?

Regards/Per

it think its to do with what it expects to find in phpmyadmin.. but it finds another version


[main]
language = english
status = offline
wampserverVersion = 2.0
wampserverLastKnown = 2.0
installDir = "c:/wamp"
navigator = "C:\WINDOWS\explorer.exe"
defaultLanguage = english


[php]
phpVersion = "5.2.5"
phpLastKnown = 5.2.5
phpIniDir = .
phpConfFile = php.ini
phpExeDir = .


[phpCli]
phpCliVersion = 5.2.5
phpExeFile = php.exe
phpCliFile = php-win.exe


[apache]
apacheVersion = "2.2.8"
apacheLastKnown = 2.2.8
apacheExeDir = bin
apacheConfDir = conf
apacheExeFile = httpd.exe
apacheConfFile = httpd.conf
apacheServiceInstallParams = -n wampapache -k install
apacheServiceRemoveParams = -n wampapache -k uninstall


[mysql]
mysqlVersion = "5.0.51a"
mysqlLastKnown = 5.0.51a
mysqlConfDir = .
mysqlConfFile = my.ini
mysqlExeDir = bin
mysqlExeFile = mysqld-nt.exe
mysqlServiceInstallParams = --install-manual wampmysqld
mysqlServiceRemoveParams = --remove wampmysqld


[apps]
phpmyadminVersion = 2.11.5
sqlitemanagerVersion = 1.2.0




like this file kinda sets the vaules.. im not sure if these get passed on to anything,
it should be fine if its running ok

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

where did you get this list of information?

Regards/Per

wampmanger.conf in wamp folder.. but i think its dynamic file... im not sure.. it may change as u installed or sleect other versions

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

Ok, here is my list:
[main]
language = "swedish"
status = "offline"
wampserverVersion = 2.0
wampserverLastKnown = 2.0
installDir = e:/wamp
navigator = C:/Program Files/Mozilla Firefox/firefox.exe
defaultLanguage = english


[php]
phpVersion = "4.4.7"
phpLastKnown = 5.2.5
phpIniDir = "."
phpConfFile = "php.ini"
phpExeDir = "."


[phpCli]
phpCliVersion = 5.2.5
phpExeFile = php.exe
phpCliFile = php-win.exe


[apache]
apacheVersion = "2.0.61"
apacheLastKnown = 2.2.6
apacheExeDir = "bin"
apacheConfDir = "conf"
apacheExeFile = "Apache.exe"<-- Differs from yours, why?
apacheConfFile = "httpd.conf"
apacheServiceInstallParams = "-n wampapache -k install"
apacheServiceRemoveParams = "-n wampapache -k uninstall"


[mysql]
mysqlVersion = "5.0.45"
mysqlLastKnown = 5.0.45
mysqlConfDir = "."
mysqlConfFile = "my.ini"
mysqlExeDir = "bin"
mysqlExeFile = "mysqld-nt.exe"
mysqlServiceInstallParams = "--install-manual wampmysqld"
mysqlServiceRemoveParams = "--remove wampmysqld"


[apps]
phpmyadminVersion =2.11.5

The list is dynamic as it change info when I change version, the only part that differs from your list is apacheExeFile.

Regards/Per

phpVersion = "4.4.7"
phpLastKnown = 5.2.5


this is probaly causing the error...

phpmyadmin is probably reading both . and seeing that its expecting 5.2.5 and now its getting 4.4.7


it shud be fine

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

Ok and I I check the file after I changed version of apache to 2,2,8 and then it updated the list to the same as yours.

I have also updated recently to the higher version of phpmyadmin and discovered that the old 2,10 is still in the directory, should I delete this old version? Can that course any problem?

Regards/Per

no but again phpmyadmin is written in many wamp files with the version name,,,, search the wamp folder for phpmyadmin in the files and see if theyd cause an issue that it wud use the wrong version



most of these files are dynacmic tho so they are only reading in what is running..


phpmyadmin is just like a website in a folder... it wont do anyhting wrong.. it will just either run or not run.


i tink ul be fine how u have it

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

Quote

when I open up phpmyadmin I get a warning (redcross cant load mysqli-extention, check your php settings) I have check my settings but I can't find this extention at all under 4.4.7

sqli runs better than sql but not available in php4

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

thxs all for your help

Regards/Per

no probelm

your welcome

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