Not the answer you need?
Register and ask your own question!

Reinstall MySQL and Preserve All MySQL Grants and Users

DBA100DBA100 Current User Role Patron
read this : 
https://www.percona.com/blog/2017/01/11/reinstall-mysql-and-preserve-all-mysql-grants-and-users/
I am not sure if  pt-show-grants tools will migrate all user login  + thier password and all user DB grants all together.

what if source DB server do not have percona toolkit install, do you know if this tools can scan remove DB and save the output locally ?

Please suggest.

Best Answer

Answers

  • DBA100DBA100 Current User Role Patron
    edited August 12
    so by this, all password and permission grant all can be restore ?
    then  users.dmp is the sql script for us to restore by :
     mysql  -u <user account> -p < users.dmp
    ?
    when I tried, it seems that if there is already an existing SAME account already there it can't recreate, right?

    how to make it works then.

    I found a link say that this is going to work but I am not sure, someone said no as it broke things:
    mysqldump -u root -p mysql user > user_table_dump.sql
    is that right?



Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.