title: User migration from MySQL 5.1 to MySQL 8.0
body: <p>I am trying to migrate databases and users from MySQL 5.1 to MySQL 8.0. Starting with MySQL 8 we can no longer (implicitly) create a user using the GRANT command. Need to use CREATE USER instead, followed by the GRANT statement. But the challenge with this method is, it doesn’t take encrypted password while creating a user.</p>
  
  <p>I have a long list of users and need to migrate them with their existing passwords and privileges. Any suggestion would be of great help!</p>