I am migrating a MySql Server Instance to another physical server. I have transferred over all of the Databases via MySql Administrator but I do not see a way for me to export all of the Mysql Users for those databases.

Is there a way to do this?

  • possible duplicate of How to copy user priviledges with MySQL? – Zoredache Sep 24 '10 at 0:01
  • See the linked question where I provide a way to export the privilege information in a way that may be a bit cleaner then a export/import of the mysql database. – Zoredache Sep 24 '10 at 0:03

just export mysql database - it contains all permissions and account information with hashed passwords.

  • Depending on the version differences and how you go about it a pure export/import of the database may not be what you want. The schema for the privilege tables has changed over time. – Zoredache Sep 24 '10 at 0:04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.