i was shifting my server from one system to another i was trying to export all the users ive created there are around 1000 i find no such options to export all the users is there any options if not please introduce this it will be very helpful
There is no standard way to export/import USER information. The USER information are stored in tables in MySQL system DB.
You can very well export it and then import it at the target machine and issue the statement “FLUSH PRIVILEGES”. This is NOT RECOMMENDED though as you should not play around with data in the system tables.