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]