Page 2 of 2
Posted: Sun Feb 19, 2006 11:23 am
by scott
Also are you using old_passwords=1 in /etc/my.cnf?
Posted: Sun Feb 19, 2006 1:26 pm
by jahwz
scott wrote:Also are you using old_passwords=1 in /etc/my.cnf?
I did add 'old_passwords=1' before the initial restart after upgrading. Just now shutdown mysql, removed the old_passwords from my.cnf and the same error appears in the logs only when mysqld starts. HTH...
Code: Select all
060219 12:18:32 mysqld started
060219 12:18:32 InnoDB: Started; log sequence number 0 2170533
060219 12:18:32 [Warning] mysql.user table is not updated to new password format; Disabling new password usage until mysql_fix_privilege_tables is run
060219 12:18:32 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
/usr/libexec/mysqld: ready for connections.
Version: '4.1.15' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
Posted: Sun Feb 19, 2006 2:08 pm
by scott
Im guessing that time_zone_leap_second table is something it would set up on an initial install. I'm just speculating at this point since I cant duplicate it, but thats the kind of thing that would make an upgrade from 3->4.1 unworkable. If its true, then you'd have to remove mysql completely, install 4.1, and then re-import the older version 3 data. This is something to consult the mysql.com people about. I don't get into the internals of the way the DB server is set up.
Posted: Sun Feb 19, 2006 3:15 pm
by breun
I also have the leap second table error in my logs, but MySQL seems to work just fine if I add 'old-passwords' to the first section of /etc/my.cnf (except for the
problem I'm experiencing with a perl webapp).
Posted: Mon Feb 20, 2006 12:24 am
by Stucco
I've been wondering, is it
or
that goes in my.cnf?
Posted: Mon Feb 20, 2006 5:31 am
by breun
There is more than one way to make it work. I use just this in the first section of /etc/my.cnf:
old-passwords
(without and '=1' or 'set' or what have you.)
Posted: Mon Feb 20, 2006 10:17 am
by scott
Its: old_passwords=1