I want to exports all users from mysql version 8.0 to 5.7. Can you guide me for this activity. I want same password and privs should migrate.

  • select `user`, `host`, `authentication_string` FROM `mysql`.`user`; will give all users. show grants for `username`@`host`; will give all grants for each user.
    – Akina
    Feb 10 '20 at 12:47

Issue fixed. I found mysql tables (db & user) columns available in 5.7. So i copy these tables from 8.0 to 5.7. And copy data only for available columns in tables db & user of mysql schema. Now its working fine.

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.