The documentation at: http://www.gentoo.org/doc/en/mysql-upgrading.xml after the "mysql_fix_privilege_tables" part of the document, could you guys update it to show that you have to run FLUSH PRIVILEGES as root? None of my old users worked until I did that. Reproducible: Always Steps to Reproduce: 1. 2. 3.
If you look carefully at the doc, you'll see that after fixing priv table, it indicates that you should restart mysql: If you now restart your MySQL daemon and everything went as expected, you will have a fully working version of 4.1.x! :-) Code Listing 3.6: Restart the MySQL instance # /etc/init.d/mysql restart Which of course takes care of the privileges flushing (and some other things, like modified variables, etc)
(In reply to comment #1) > If you look carefully at the doc, you'll see that after fixing priv table, it > indicates that you should restart mysql: Indeed.