[MDEV-9273] ERROR 1819 on grant statment for existing user Created: 2015-12-13  Updated: 2016-03-07  Resolved: 2016-01-26

Status: Closed
Project: MariaDB Server
Component/s: Authentication and Privilege System
Affects Version/s: 10.1.9
Fix Version/s: 10.1.11

Type: Bug Priority: Major
Reporter: Andy Ferretti Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: None
Environment:

Linux with parameters set:
plugin-load-add=simple_password_check.so
simple_password_check_other_characters=0

Sprint: 10.1.11

 Description   

For statements:

CREATE USER 'usergoodmixed'@'%' IDENTIFIED BY 'Hi123456';
 
GRANT select  ON  performance_schema.users to  'usergoodmixed'@'%'

I get error :

ERROR 1819 (HY000) at line 25 in file: 'password_complexity_test.sql': Your password does not satisfy the current policy requirements

on the grant statement.
I see a MySQL Bug:
https://bugs.mysql.com/bug.php?id=70451
Is this issue addressed with MariaDB?

 Comments   
Comment by Andy Ferretti [ 2015-12-31 ]

I haven't seen any response to this. Is there something that I need to do to notify of this issue? I noticed that MySQL does not have this problem, so this creates an inconsistency between MySQL and MariaDB.

Comment by Sergei Golubchik [ 2016-01-05 ]

No, thanks, you don't need to do anything — creating an issue is enough.

Comment by Andy Ferretti [ 2016-01-21 ]

It looks like this is fixed for 10.1.11 when it comes available.

Comment by ManasaTulluri [ 2016-03-07 ]

Hi,

I am using version 10.1.10-MariaDB . I did not face this issue in Windows OS. But with the same 10.1.10 version in Linux I face ERROR 1819 with grant and revoke statements
Could you please let me know what is the solution?

Thanks & Regards,
Manasa Tulluri.

Comment by Andy Ferretti [ 2016-03-07 ]

The people at MariaDB fixed this with 10.1.11.

Generated at Thu Feb 08 07:33:26 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.