Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2007
    Posts
    4
    Plugin Contributions
    0

    Default 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!!!

  2. #2
    Join Date
    Jun 2005
    Location
    Cumbria, UK
    Posts
    10,266
    Plugin Contributions
    3

    Default Re: Zen not runing on MySQL older than 4.1?

    Download and install XAMPP...

    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

  3. #3
    Join Date
    Mar 2007
    Posts
    4
    Plugin Contributions
    0

    Default 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!!!

 

 

Similar Threads

  1. v150 if the language pack is older than current zc version
    By jaca in forum Addon Language Packs
    Replies: 2
    Last Post: 27 Mar 2012, 12:00 AM
  2. Importing older mysql store into 1.38
    By rayrock1111 in forum General Questions
    Replies: 0
    Last Post: 15 Mar 2010, 01:50 AM
  3. Delete customer carts older than date X (SQL help?)
    By bodyjewelrystores in forum General Questions
    Replies: 10
    Last Post: 1 Mar 2010, 03:36 PM
  4. Requiring Account creators to be older than 18
    By pointwise in forum General Questions
    Replies: 2
    Last Post: 29 Jul 2009, 11:31 PM
  5. Replies: 3
    Last Post: 18 Jul 2009, 04:54 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg