Forums / Installing on a Windows Server / Zen not runing on MySQL older than 4.1?

Zen not runing on MySQL older than 4.1?

Locked

Views: 1,754

Results 1 to 3 of 3
This thread is locked. New replies are disabled.
13 Mar 2007, 3:44 PM
#1
stellan avatar

stellan

New Zenner

Join Date:
Mar 2007
Posts:
4
Plugin Contributions:
0

Zen not runing on MySQL older than 4.1?

Is this true? Tryiong to install zen localy. I have mySql 5.o running but i cant run trought the instllation process. It stops when i try to connect to the database:

Client does not support authentication protocol requested by server; consider upgrading MySQL

Found a thread about this saying that you have to downgrade below 4.1. Is that true?

If so. Does anybody know where I can download that old verison of MySql? the only have above 4.1 on myphp.com.

Thanks for great support!!!

13 Mar 2007, 5:58 PM
#2
schoolboy avatar

schoolboy

Totally Zenned

Join Date:
Jun 2005
Location:
Cumbria, UK
Posts:
10,327
Plugin Contributions:
0

Re: Zen not runing on MySQL older than 4.1?

Download and install XAMPP...

https://www.apachefriends.org/en/xampp.html

But it MUST be this version:-

xampp-win32-1.4.16

That will install apache, php and mysql, ALL of the correct versions, so before you install, get rid of everything else.

...Oh... I got the above snippet FROM THE BRAND NEW BOOK (see the link at the top right corner of this page? Click on it... you'll be so glad you did!

20 years a Zencart User

14 Mar 2007, 10:10 AM
#3
stellan avatar

stellan

New Zenner

Join Date:
Mar 2007
Posts:
4
Plugin Contributions:
0

Re: Zen not runing on MySQL older than 4.1?

Thanks! But here I got the solution everyone is looking for. Its so simple!

Use the software MySQLAdministrator
Under startup varibels go to Security tab
Check "Use old password"
Stop and start the MySQL service (done under service controll)
Create a new user and set a password
Use this new user to conect to the database
Done

The problem is that al 4.1 mySQL and above store passwords with an algorythm that php 5 cant understand. By doing these settings you use the old system to store password.

I got the information from: http://www.ozzu.com/ftopic73598.html

Thanks Atno!!!