Laravel 5 - Text to Encrypted Password

Question

I had a website and passwords are stored in plain text. Now I converted to Laravel 5 and I want to convert all those plain passwords of users to Laravel encrypted password from PhpMyAdmin. Therefore, I need an SQL statement to convert all passwords which is in password column to Laravel encrypted password.

If is not possible to do it from PhpMyAdmin then please explain another alternative.

Thanks in advance.

Answer 1

You don't encrypt passwords, you hash them. There won't be a single SQL statement to perform application level hashing, loop through all the users and update their password within Laravel:

User::all()->each(function($user) {
   $user->update(['password' => bcrypt($user->password)]);
});

Note: Verify your password column's length can store the full hash. (I'd recommend just using varchar 255)