← Back to team overview

maria-discuss team mailing list archive

Re: mysql_native_password in mysql.user WAS Re: SHOW GRANTS change?

 

Hi, Felipe!

On Apr 14, Felipe Gasper wrote:
> 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?

The bug has fixVersion 10.0, which generally means it should be fixed in
the next 10.0 release (unless we'll have too many higher-priority bugs).

So for now you can expect that nothing will happen to MDEV-7985 until
10.0 is the next release in our release schedule. After that you can
expect this bug to be fixed.

The release schedule is in Jira (I'm keeping it up to date, so I
encourage people to look at it :).  The current plan is to have 5.5.43
released on 2015-04-21, then 10.0.18 on 2015-04-28, then 10.1.5 on
2015-05-12.

So, unless the plan changes, you can expect no activity on the bug until
2015-04-21, and then it should be closed as fixed no later than 2015-04-28.

There is no need to bump the priority - it's high enough to almost
guarantee a fix in 10.0.18.

> 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?

Yes. Perfectly reasonable.

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

I think so, yes :(

Regards,
Sergei


References