I've to set some bulk users in MySQL with different user id, passwords and privileges.
I do not want to do that one by one, I would like to use insert sql to do that.
Problem is I don't know what encryption algorithm is being used to generate the encrypted password to store in the "users" table.
Please advise, if it's possible to do it by backend script. Thanks!