What encryption xampp use to set password in MySQL??

Problems with the Windows version of XAMPP, questions, comments, and anything related.

What encryption xampp use to set password in MySQL??

Postby sanjaydsh » 17. February 2011 20:12

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!
sanjaydsh
 
Posts: 6
Joined: 15. February 2011 20:49

Re: What encryption xampp use to set password in MySQL??

Postby sanjaydsh » 17. February 2011 20:34

Forgot to mention, I'm using xampp for windows 1.7.3.
sanjaydsh
 
Posts: 6
Joined: 15. February 2011 20:49

Re: What encryption xampp use to set password in MySQL??

Postby Altrea » 17. February 2011 20:48

Why don't you just use the privileges tab in phpmyadmin?
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8298
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: What encryption xampp use to set password in MySQL??

Postby sanjaydsh » 17. February 2011 23:02

Sure, I'll try it out. Thanks!
But still can't I generate this by using some script?
sanjaydsh
 
Posts: 6
Joined: 15. February 2011 20:49

Re: What encryption xampp use to set password in MySQL??

Postby Sharley » 17. February 2011 23:19

In \xampp\mysql\scripts folder you may find a script suitable for your needs or at least one you could adapt.
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: What encryption xampp use to set password in MySQL??

Postby Altrea » 17. February 2011 23:23

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 hashing

or use the mysql command line commands
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8298
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: What encryption xampp use to set password in MySQL??

Postby sanjaydsh » 17. February 2011 23:59

Nice! Thanks, this will help! :)
Thank you Sharley and Altrea, really appreciate your prompt help!
sanjaydsh
 
Posts: 6
Joined: 15. February 2011 20:49


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 28 guests