up vote 0 down vote favorite
share [g+] share [fb]

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?

link|improve this question
83% accept rate
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
feedback

1 Answer

up vote 1 down vote accepted

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

link|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
feedback

Your Answer

 
or
required, but never shown
discard

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