Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

1 Answer

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
add comment

Your Answer

 
discard

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.