Page 1 of 1
What encryption xampp use to set password in MySQL??
Posted:
17. February 2011 20:12by sanjaydsh
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!
Re: What encryption xampp use to set password in MySQL??
Posted:
17. February 2011 20:34by sanjaydsh
Forgot to mention, I'm using xampp for windows 1.7.3.
Re: What encryption xampp use to set password in MySQL??
Posted:
17. February 2011 20:48by Altrea
Why don't you just use the privileges tab in phpmyadmin?
Re: What encryption xampp use to set password in MySQL??
Posted:
17. February 2011 23:02by sanjaydsh
Sure, I'll try it out. Thanks!
But still can't I generate this by using some script?
Re: What encryption xampp use to set password in MySQL??
Posted:
17. February 2011 23:19by Sharley
In \xampp\mysql\scripts folder you may find a script suitable for your needs or at least one you could adapt.
Re: What encryption xampp use to set password in MySQL??
Posted:
17. February 2011 23:23by Altrea
sanjaydsh wrote:But still can't I generate this by using some script?
Sure, you can. phpMyAdmin is just a php administration application too.
for further reading =>
MySQL Password hashingor use the mysql command line commands
Re: What encryption xampp use to set password in MySQL??
Posted:
17. February 2011 23:59by sanjaydsh
Nice! Thanks, this will help!
Thank you Sharley and Altrea, really appreciate your prompt help!