Found the missing bit: the display_name
and user_nicename
fields also need to be updated….
So:
UPDATE wp_users u INNER JOIN newDir.hashOldLoginToNew l ON u.user_login = l.oldLogin
SET
u.user_login = l.newLogin,
u.user_nicename = l.newLogin,
u.display_name = l.newLogin
works beautifully!
HTH someone else stuck in this problem….
–Dale