Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
396 views
in Technique[技术] by (71.8m points)

mysql - Converting plain password to Laravel encrypted password

I have a table called "users" where I have username and password from my users.

The passwords are in plain text. Now I've created a new site with Laravel 5.4 and Auth.

So if a user wants to loggin into my site I need to convert my password plain text to the new password encrypted.

How can I get the "salt" from my Auth and also a tools to get the encrypted password from my plain password and "salt". The reason is because I created a new column in my users table so I want to put there the password encrypted using a query.

Thanks for helping!

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Reply

0 votes
by (71.8m points)

Laravel uses bcrypt() to hash passwords. Assuming you have the plain text passwords stored in users.password, you just need to loop through and bcrpyt() them.

AppUser::get()->each(function ($user) {
    $user->password = bcrypt($user->password);
    $user->save();
});

The above code will overwrite the plain text value stored in users.password with the hashed value. After you do this, user's should be able to log in with Laravel's auth. Additionally, you will not be able to retrieve the user's plain text password. This is good, and is the whole point of hashing passwords.


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...