When adding a new host to a user SP will use this query (where password is copied from an existing user):
CREATE USER 'horst'@'%' IDENTIFIED BY PASSWORD '*27193CCC36970235099CF910EC3128B90A4EB4D4';
When changing a pasword the query is:
SET PASSWORD FOR 'horst'@'%' = PASSWORD('test');
However, when both adding a new host and changing the password at the same time the query is:
CREATE USER 'horst'@'localhost' IDENTIFIED BY PASSWORD 'foobar';
This is invalid and will be rejected by MySQL with Password hash should be a 41-digit hexadecimal number (or similar).
Password hash should be a 41-digit hexadecimal number
Fix an issue where changing a user password and adding a host at the …
…same time would result in a query error (#2427)
Fix #2427 for 1.1.x branch
Backport of 0ac1ebf
@dmoagx can you confirm this is fixed close the issue?
This has been included in 1.1.2