Shut down mysql then in your my.cnf add old-passwords directive. Then copy your user tables "again" from your backup. You should be ok now.
Fredrick ----- Original Message ----- From: "A. Clausen" <[EMAIL PROTECTED]> To: "MySQL Mailing List" <[EMAIL PROTECTED]> Sent: Friday, December 10, 2004 3:33 PM Subject: Problems Moving from 3.23 to 4 (Win2k) > I made a copy of my entire Mysql 3.23 data directory and moved it on to > a box with a fresh install of MySQL 4. While the NT service starts up > fine (I'm using 4.0.22-nt-max), I can't login. I know that there are > supposed to be mods made to the mysql database tables, but I thought > there was at least a minimum compatibility. The only way to get access > to anything is to shut down MySQL, put in the default table that came > with the install. What am I doing wrong here? > > -- > A. Clausen > [EMAIL PROTECTED] > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]