Note: This is also a MySQL 8 workaround for the new caching_sha2_password authentication plugin.
Example below uses the legacy mysql_native_password
instead for compatibility reasons.
CREATE USER `my_root_user`@`%` IDENTIFIED WITH mysql_native_password BY 'my_root_pwd';