Hi Yesterday upgraded from 4.0.2 to to 4.1.10 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 General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
