How do I start Mysql with old password option.

I am trying to resolve an issue in mysql installation. I got an error
message concerning the PASSWORD. The instruction in the manual says:

1. Start mysqld with the --old-passwords option.

How do I start mysqld with the old password option?

Do I do this at the command promt and exactly what do I type?

2. mysql> SELECT Host, User, Password FROM mysql.user
-> WHERE LENGTH(Password) > 16;

I figured if I get the first part done, then I can do #2 without any
problem.

Thanks in advance



--
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 do I start Mysql with old password option.

I have found that the EASIEST way to do this is in the mysql.ini (mysql.cnf) file. Under [MYSQLD]
put in

set_variable = old_passwords=1


That will make the old_passwords work all the time.

J.R.

-----Original Message-----
From: Ola One [mailto:ola_atb@hotmail.com]
Sent: Tuesday, December 07, 2004 12:43 PM
To: win32@lists.mysql.com
Subject: How do I start Mysql with old password option.

I am trying to resolve an issue in mysql installation. I got an error message concerning the
PASSWORD. The instruction in the manual says:

1. Start mysqld with the --old-passwords option.

How do I start mysqld with the old password option?

Do I do this at the command promt and exactly what do I type?

2. mysql> SELECT Host, User, Password FROM mysql.user
-> WHERE LENGTH(Password) > 16;

I figured if I get the first part done, then I can do #2 without any problem.

Thanks in advance



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=bullijr@innovatim.com



--
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 do I start Mysql with old password option.

Hello again,

On Tue, 07 Dec 2004 12:43:18 -0500, Ola One wrote:
> I am trying to resolve an issue in mysql installation. I got an error
> message concerning the PASSWORD. The instruction in the manual says:
>
> 1. Start mysqld with the --old-passwords option.
>
> How do I start mysqld with the old password option?
>
> Do I do this at the command promt and exactly what do I type?

The best way to start MySQL with the option to use old passwords is to
specify this option using the config file (my.cnf or my.ini), this
works either if your're running mysqld from command line or as a
windows service. At the config file, you'll have something like this:

[mysqld]
old-passwords

At the command prompt, you'll start something like this.

C:\mysql\bin>mysqld --old-password

>
> 2. mysql> SELECT Host, User, Password FROM mysql.user
> -> WHERE LENGTH(Password) > 16;
>

To get to the mysql> prompt, you'll go to the command prompt from DOS
(command at win9x or cmd at winXP, NT) and CD to the mysql/bin
directory, run mysql -u (or other option needed to connect to
your host) and at the command prompt that appears (mysql>) type the
SQL queries.

> I figured if I get the first part done, then I can do #2 without any
> problem.
>
> Thanks in advance
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=danieldaveiga@gmail.com
>
>

--
Daniel da Veiga
Computer Operator - RS - Brazil

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