maria-discuss team mailing list archive

[Felipe Gasper <felipe@xxxxxxxxxxxxxxxx>]

Hi Sergei!

On 13 Apr 2015 5:34 PM, Sergei Golubchik wrote:
>
> > Should MariaDB not accept “mysql_native_password” as a value in that column?
>
> Right, that's exactly the issue I was referring to.
> I know about this case because I've fixed it.
> It's MDEV-6253 and it was fixed in 10.0.12.
>
> But ok, now I see that the bug was about the user being unable to
> connect. That part was fixed. But SHOW GRANTS apparently wasn't.
>
> Reported as MDEV-7985

What will the “life” of this bug and its fix look like? Is there 
anything that could be done to help bump it along?

We have code that depends on SHOW GRANTS for backups; that logic is now 
effectively discarding users’ passwords when, for example, an account is 
transferred from one server to another.

As a workaround I’m going to do:

UPDATE mysql.user SET plugin='' WHERE plugin='mysql_native_password'; 
FLUSH PRIVILEGES;

Does this look like a reasonable workaround?

Also, are all 10.0 releases affected, do we know?

Thank you! :)

-Felipe Gasper