Copy MySQL User but change HostName I am migrating to a docker MariaDB setup and all my users were created w/ "Localhost". From what I read and tested ironically '%' excludes localhost. I want to copy my existing users adding a second entry utilizing '%' as the hostname. Any suggestions?
You have to call SHOW CREATE USER 'username'@'localhost' and SHOW GRANTS FOR 'username'@'localhost' for all the users fetched by 

SELECT user, host 
  FROM mysql.user
 WHERE host = 'localhost'


and to replace all 'localhost' entries by '%' in the returned statements.