sql statement - How to add users in batches in mysql?

Question

To configure the company server, you need to create new mysql accounts for everyone. It is too troublesome to do it one by one. Is there any way to create a batch of users? I should write a script. It would be great if I could grant authorization in batches.

Answer 1

This is also an invitation. . Of course, if you do it in batches, you need to use a script. You have to make your specific needs clear. You can use the script however you want. .