mysql create user issue

[professorxuk]

Running script mysql-init.sql fails, introduced in branch 69-mysql-configuration (chapter 123)
with the following error
SQL Error [1524] [HY000]: Plugin 'mysql_native_password' is not loaded

Cause : authentication plugin mysql_native_password was removed in v9, previously deprecated/disabled
source: https://blogs.oracle.com/mysql/post/mysql-90-its-time-to-abandon-the-weak-authentication-method#:~:text=Text%20Size%20100%25:,precomputed%20hashes%20to%20crack%20passwords.

Workaround is to replace the create command with the following commands
CREATE USER IF NOT EXISTS restadmin@%;
ALTER USER 'restadmin' IDENTIFIED WITH caching_sha2_password BY '';