Upgrading to 4.1.10 Win32 Horror!

Hi
Yesterday upgraded from 4.0.2 to to 4.1.10 (mistakenly previously posted to general)

Stages of Horror

1) You have uninstall old version (does not delete your databases fortunately, but backup any way
2a) B4 installing Either also remove references to mysql in the registry OR during installation name
choose Service name mysql41 (not mysql)
2b) New installation defaults to c:\program files\mysql rather than c:\mysql
I advise you to accept this, I tried to load it elsewhere w/o success

OK Mysql now runs phew, but now your real problems begin

None of your db apps will now run!

It's something to do with a new password algorithm

You are supposed to be able to fix this by specifying "old passwords" in your new my.ini
You are also advised to upgrade Perl,PHP, Drivers etc!!!!

This didn't work for me I'm temporarily using:-

#in my.ini
skip-grant-tables

THIS WORKED but I can do this because I work only a test server, but it's no solution to others.

IAC best read (real carefully)

http://dev.mysql.com/doc/mysql/en/upgrading-from-4-0.html

http://dev.mysql.com/doc/mysql/en/windows-upgrading.html

Hey I now read that I should have upgraded from

4.0.2 to 4.0.15
and then upgraded my grant tables

On Windows systems, there isn't an easy way to update the grant tables until MySQL 4.0.15. From
version 4.0.15 on, MySQL distributions include a mysql_fix_privilege_tables.sql SQL script that you
can run using the mysql client. If your MySQL installation is located at C:\mysql, the commands look
like this:

C:\> C:\mysql\bin\mysql -u root -p mysql
mysql> SOURCE C:\mysql\scripts\mysql_fix_privilege_tables.sql


Just ran this made no difference!

YUK YUK YUK



zzapper (vim, cygwin, wiki & zsh)
--

vim -c ":%s%s*%CyrnfrTfcbafbeROenzSZbbyranne%|:%s)[R-T]) )Ig|:norm G1VGg?"

http://www.vim.org/tips/tip.php?tip_id=305 Best of Vim Tips


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org