I am planning to update from mysql 4 to mysql 5 on
a) my intranet server b) my webserver
After installing mysql 5.1 on my notebook testwise, I was faced with the problem of not being able to import dump-files (from my notebook) on any of both mysql 4 environments.
It seems I made a mistake with the default sort-charset (latin-swedish OMG;), but I cannot remember to have defined this anywhere in the installation process.
Imports from 4 to 5 work perfectly fine, but not vice versa. What exactly is the background with this feature?
What do I have to take care for if I want to update on my webserver? Will I have to copy the database to a new 5.1 Version and then redefine access-parameters (password) in all scripts to that new updated database or is there any chance to tell my hoster "please now update my mysql-version and keep the databases"?
Another problem I often encounter when changing versions, "Client does not support authentication protocol" when trying to connect with the same password. The encryption methods changed from one version to the next.
SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('newpwd');