Last tested: May 15, 2019
No.
looker_tmp is used for creating temp tables for System Activity, and it's hardcoded into the codebase and it can't actually be named differently.
Relevant docs: https://docs.looker.com/setup-and-management/on-prem-mgmt/migrating-to-mysql#create_a_database_and_user
This content is subject to limited support.