MySQL 8: Add Access Host with caching_sha2_password

Version 1.59.5


When duplicating a mysql.user entry to add an access host, if the existing entry was using caching_sha2_password, the mysql_use_new_user_methods call to CREATE USER was not picking up the $A$005$ tag in the hash, using mysql_native_password instead, throwing errors during access host creation (user row duplication)

Interested to try DirectAdmin? Get a 30-day Free Trial!