4.1 uses different size password field and the PASSWORD() function (used
for authentication) returns a different hash than it did. You coulod fix
this by doing an update user set password= PASSWORD('the old password
that I happen to know') for each user if that is feasible , or you can
start the ddatabase with --old-password flag to have the function return
short hashes.
You can read more here:
http://dev.mysql.com/doc/mysql/en/upgrading-from-4.0.html
Hope that helps.
-Corey
Dave Kennedy wrote:
Env: Windows XP
This procedure was followed to upgrade to MySQL 4.1
1. Uninstall MySQL 4.0 (c:\mysql\), data directory (c:\mysql\data)
2. Install MySQL 4.1 (c:\program files\MYSQL\MySQL Server 4.1\)
3. The new data directory is (c:\program files\mysql\MySql Server
4.1\Data)
How is the MySQL 4.0 data (c:\mysql\data\) transferred in MySQL 4.1 ?
The problem I am having is with the users
Users are lost when a database is imported
7 messages in com.mysql.lists.win32Re: Upgrade to MySQL 4.1 from 4.0
