Automatically replace user passwords in mysql db dump on server side (Laravel)

Use Case

To setup a development environment one needs a mysql dump of the application database. The dump origin is the production database.

Problem

I do not want to give the dump to anyone since it contains the (hashed) user passwords.

Solution Idea

Replace all user passwords (one password for all users for dev purpose would be ok) on the server side before giving access to the dump.

Environment

• Laravel application
• MySQL database
• The bash script could run over Capistrano or be executed on the server via ssh manually

Any ideas how to solve this in a smart way?

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2hR1Dlw
via IFTTT