After I uninstalled 4.1 I removed the /var/db/mysql/ directory so that the install of 4.0.6 would start fresh and create its defualt users and databases with no trace of the previous user entries.
> > Schrodinger wrote: > >> I have removed all localhost user entries and all users should now be >> able to connect from any host. But when a user attempts to connect with >> a password they get the usual >> >> ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: >> YES) > > In an earlier message, you said you downgraded from mysql 4.1.? to 4.0.6 > (Why not 4.0.16?). mysql 4.1 has a different password format in the > user table than previous versions. Pre 4.1.x mysql uses 16 byte hashes > to store passwords, 4.1.0 uses 45 byte hashes, and 4.1.1 (and up) uses > 41 byte hashes. If you kept (or restored) the mysql user table you > created in 4.1, you may now be comparing a 16 byte password hash to a 41 > or 45 byte hash. As I understand it, the only way that could match is > if both are blank. If this is the case for you, use GRANT to reset the > passwords to new 16 byte hashes. > > See <http://www.mysql.com/doc/en/Password_hashing.html> for more. > > Michael > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
