Import .sql file into multiple databases

How to import .sql file into multiple databases at one shot.

I have tried this:

mysql -uroot -p -all-databases < test.sql

But it asks for database name. Whatever there in test.sql file should reflect in all the databases/Schemas.

If you're running on Linux/Unix, you can do it with a bit of shell:

for DB in `mysql -u root -r --silent -p -e 'show databases;' | egrep -v "_schema$|^mysql$|^sys$"`
do 
  mysql -uroot -p $DB < test.sql
done

Will obviously be easier if you temporarily set it up to be passwordless.

StackExchange Database Administrators Q#142159, answer score: 2