MySQL Error [mysqld: unknown variable 'old_passwords=1'] after 'apt-get upgrade'

jme · 08-13-2005, 06:49 AM

Yesterday I did an apt-get upgrade on my workstation and when I have come to start-up MySQL I am getting the following error:

Code:

mysqld: unknown variable 'old_passwords=1'

I am running Ver 12.22 Distrib 4.0.24, for pc-linux-gnu (i386)

I have tried google-ing for this to no avail.

Any thoughts?

Jamie

corfe · 08-13-2005, 02:53 PM

Check out this Bug Report - it looks like the same thing. I don't have mysql installed, but if you can figure out which config file the bug poster is talking about, and comment out the same line, it sounds like that will fix it.

If you're not able to fix it that way, you can always revert to the old version: The only way I know of how to do that, is to go to /var/cache/apt/archives, and look for the last version of the package : check "dpkg -l mysql-server", see what version it says, something like 4.0.24-x. Now in /var/cache/apt/archives, find the deb file for mysql version 4.0.24-y, where y is (x-1), or the previous version (the one you had right before it broke). "dpkg -i filename.deb" to install that package; if it depends on some packages that need downgraded too, dpkg will error out and tell you which files it needs. Then just try a dpkg -i again, with all those files it needs together on the command line.

Actually, does anyone know a better way to downgrade to a previous version of a package?

jme · 08-14-2005, 07:18 AM

thanks for the link - only problem is that i can't find the file that he's refering to...

If anyone has any thoughts ... :P

Jamie

demian · 08-14-2005, 10:44 AM

/etc/mysql/my.cnf

jme · 08-15-2005, 07:43 AM

Cheers.

I don't know how I missed that!

chris71mach1 · 08-17-2005, 10:19 PM

yea and by the way, yall freakin ROCK! this thread and the bugfix that yall posted here helped me fix my own mysql server. this is why linux rocks. thanks you guys!

magellan2k · 08-29-2005, 11:17 AM

Hi,

thanks, this helped me too. There was only 1(!) link at google with
unknown variable 'old_passwords=1'

So - that's it.
Thanx a lot!

bram · 08-31-2005, 06:11 AM

Quote:

This was a temporary problem. Now the mysql-server (4.0) package is no longer
availble and replaced by mysql-server-4.1

but i guess this only works for sarge

Abject · 08-31-2005, 11:00 PM

I had this problem after upgrading MySQL 4.0 (Sid/Etch). At first, it looked like this:

Code:

Starting MySQL database server: mysqld...failed.
        Please take a look at the syslog.
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!

Went to this section of the MySQL docs, which said (among other things) to try starting MySQL by hand:

Code:

# mysqld
050831 20:35:50 mysqld: unknown variable 'old_passwords=1'

And that led me here!

Thanks, corfe!

moz667 · 09-05-2005, 04:07 PM

Solved comment a line in /etc/my.cnf thats have old_passwords=1...

but don't know for what is this.

Any ideas?

==============
Salud3!

smarinier · 10-05-2005, 07:55 AM

Maybe "old-passwords" is more correct than "old_password" and second, old-password shouldn't be used in [client] section, but only in server ([mysqld]).