old-passwords question
Posted: Sat Mar 18, 2006 4:52 pm
Hi, a few months ago my mysql-server was updatet from 3.23 to 4.1, and "old-passwords" was added to the my.cnf file.
One month ago, I did some optimizing of the my.cnf file, and upon restarting the mysql-service, several database-tables vanished completely (.MYD-files gone). I quickly rebuildt the tables from backup and everything has worked like a charm since.
Today I decided that it was time for a server reboot, and checked the my.cnf for any changes I could use the opportunity to change, and I noticed that "old-passwords" where gone? When I check mysql server-vars, it says "old-passwords = 0", so the service is running without the parameter set. Could this explain the disappearing tables a month ago?
Everywhere I look, it says you're supposed to put "old-passwords" in my.cnf when upgrading from 3.23, but I can't find anything if the line is meant to be there forever or can safely be removed after the upgrade.
Just for the record, in the mysql database, user-table, some passwords have half the lenght of other users. But all users databases works just fine. So there's a mix of old format passwords and new longer format passwords at the time being.
So, my main question; Am I in the clear? Can I continue without "old-passwords" and expect no problems, or is this a disaster waiting to happen on the next server restart?
One month ago, I did some optimizing of the my.cnf file, and upon restarting the mysql-service, several database-tables vanished completely (.MYD-files gone). I quickly rebuildt the tables from backup and everything has worked like a charm since.
Today I decided that it was time for a server reboot, and checked the my.cnf for any changes I could use the opportunity to change, and I noticed that "old-passwords" where gone? When I check mysql server-vars, it says "old-passwords = 0", so the service is running without the parameter set. Could this explain the disappearing tables a month ago?
Everywhere I look, it says you're supposed to put "old-passwords" in my.cnf when upgrading from 3.23, but I can't find anything if the line is meant to be there forever or can safely be removed after the upgrade.
Just for the record, in the mysql database, user-table, some passwords have half the lenght of other users. But all users databases works just fine. So there's a mix of old format passwords and new longer format passwords at the time being.
So, my main question; Am I in the clear? Can I continue without "old-passwords" and expect no problems, or is this a disaster waiting to happen on the next server restart?