How to set the old-password dirretive

------_=_NextPart_001_01C4F1A3.00AEC486
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

I have a problem with my database. I am not able to connect to it even
though I can se that is running, so now I wonder how to set the old
dirrective as describe in a mail from this list.

Rene

Ola One wrote:

> Could someone direct me to the easiest way to install Mysql
> ver 4.1.7?

I'm assuming a Windows installation is what you're after...?

The 4.1.7 Essentials distribution was pretty simple to install.
It's one of the download options listed at mysql.com.
It has a wizard-type procedure that you step through and make
decisions - MySQL will make the appropriate my.cnf file.

The only catch I encountered (and this is a problem with any
4.1.* distribution) is that you need to be aware of the new
password length (assuming you're upgrading from 4.0.*).
I initially had problems getting phpMyAdmin to work - finally
fixed it by specifying a MySQL user with the OLD_PASSWORD
option.

Another way to fix would be to start the MySQL service with the
--old-password directive; then the whole system reverts to
using the old password format.

Peter.


------_=_NextPart_001_01C4F1A3.00AEC486--

RE: How to set the old-password dirretive

Rene,
Put this into your my.ini file under the [MYSQLD] section:

Set-variable = old_password=1

That's how you get your pre 4.1 clients to log onto the 4.1.x servers.

J.R.

-----Original Message-----
From: Rene Harder Olsen [mailto:rehol@tdc.dk]
Sent: Monday, January 03, 2005 9:46 AM
To: win32@lists.mysql.com
Subject: How to set the old-password dirretive

I have a problem with my database. I am not able to connect to it even though I can se that is
running, so now I wonder how to set the old dirrective as describe in a mail from this list.

Rene

Ola One wrote:

> Could someone direct me to the easiest way to install Mysql
> ver 4.1.7?

I'm assuming a Windows installation is what you're after...?

The 4.1.7 Essentials distribution was pretty simple to install.
It's one of the download options listed at mysql.com.
It has a wizard-type procedure that you step through and make decisions - MySQL will make the
appropriate my.cnf file.

The only catch I encountered (and this is a problem with any
4.1.* distribution) is that you need to be aware of the new password length (assuming you're
upgrading from 4.0.*).
I initially had problems getting phpMyAdmin to work - finally fixed it by specifying a MySQL user
with the OLD_PASSWORD option.

Another way to fix would be to start the MySQL service with the --old-password directive; then the
whole system reverts to using the old password format.

Peter.



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: How to set the old-password dirretive

Hmmm, I just use...
[MYSQLD]
old-passwords
----- Original Message -----
From: "J.R. Bullington"
To:
Cc: "'Rene Harder Olsen'"
Sent: Monday, January 03, 2005 6:51 AM
Subject: RE: How to set the old-password dirretive


> Rene,
> Put this into your my.ini file under the [MYSQLD] section:
>
> Set-variable = old_password=1
>
> That's how you get your pre 4.1 clients to log onto the 4.1.x servers.
>
> J.R.
>
> -----Original Message-----
> From: Rene Harder Olsen [mailto:rehol@tdc.dk]
> Sent: Monday, January 03, 2005 9:46 AM
> To: win32@lists.mysql.com
> Subject: How to set the old-password dirretive
>
> I have a problem with my database. I am not able to connect to it even
though I can se that is
> running, so now I wonder how to set the old dirrective as describe in a
mail from this list.
>
> Rene
>
> Ola One wrote:
>
> > Could someone direct me to the easiest way to install Mysql
> > ver 4.1.7?
>
> I'm assuming a Windows installation is what you're after...?
>
> The 4.1.7 Essentials distribution was pretty simple to install.
> It's one of the download options listed at mysql.com.
> It has a wizard-type procedure that you step through and make decisions -
MySQL will make the
> appropriate my.cnf file.
>
> The only catch I encountered (and this is a problem with any
> 4.1.* distribution) is that you need to be aware of the new password
length (assuming you're
> upgrading from 4.0.*).
> I initially had problems getting phpMyAdmin to work - finally fixed it by
specifying a MySQL user
> with the OLD_PASSWORD option.
>
> Another way to fix would be to start the MySQL service with
the --old-password directive; then the
> whole system reverts to using the old password format.
>
> Peter.
>
>
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
http://lists.mysql.com/win32?unsub=palmtreeFRB@earthlink.net
>


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org