Re: Problems Moving from 3.23 to 4 (Win2k)
Victor Pendleton wrote: A. Clausen wrote: 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? What errors are being displayed when you attempt to log in? Is anything being written to the error log itself? Nothing out of the ordinary that I can see. It just simply doesn't seem to recognize 3.23's security settings. If I replace the 3.23 mysql database tables with 4.1 stock ones, I can log in, but I don't want to have to re-enter all of this by hand. -- A. Clausen [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problems Moving from 3.23 to 4 (Win2k)
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]
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]
Re: Problems Moving from 3.23 to 4 (Win2k)
What errors are being displayed when you attempt to log in? Is anything being written to the error log itself? A. Clausen wrote: 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? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]