Hello Patrice On 2005-02-07 Patrice Pawlak wrote: > The configuration file /etc/mysql/my.cnf for MySQL 4.1 comes with a wrong > variable name: old-passwords should be replaced by old_passwords. > > Not having this variable set prevent older clients from connecting to the > server, which can be quite blocking in some configurations.
It seems to be true that the preferred way of writing the options is with underscore but it nevertheless also works with dashes, I just verified it: ---------- "old-passwords = 1" mysql> SHOW VARIABLES LIKE "%pass%"; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | old_passwords | ON | +---------------+-------+ 1 row in set (0.00 sec) ---------- "# old-passwords = 1" and restart mysql> SHOW VARIABLES LIKE "%pass%"; ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... Connection id: 4 Current database: *** NONE *** +---------------+-------+ | Variable_name | Value | +---------------+-------+ | old_passwords | OFF | +---------------+-------+ 1 row in set (0.00 sec) ---------- "old_passwords = 1" and restart mysql> SHOW VARIABLES LIKE "%pass%"; ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... Connection id: 4 Current database: *** NONE *** +---------------+-------+ | Variable_name | Value | +---------------+-------+ | old_passwords | ON | +---------------+-------+ 1 row in set (0.01 sec) old-passwords will be replaced with old_passwords in the next upload. bye, -christian- -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
