Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
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
up vote 1 down vote accepted

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

share|improve this answer
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 posting your answer, you agree to the privacy policy and terms of service.

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