[MDEV-22040] versioning.truncate_privilege : GRANT fails with "Access denied", for root user Created: 2020-03-25  Updated: 2020-03-26  Resolved: 2020-03-26

Status: Closed
Project: MariaDB Server
Component/s: Authentication and Privilege System, Tests
Affects Version/s: 10.5.2
Fix Version/s: 10.5.3

Type: Bug Priority: Major
Reporter: Vladislav Vaintroub Assignee: Alexander Barkov
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Problem/Incident
is caused by MDEV-22030 Don't grant REPLICATION MASTER ADMIN ... Closed

 Description   

To reproduce, run versioning.truncate_privilege after main.mysql_upgrade_noengine, like this

perl mysql-test-run.pl --no-reorder main.mysql_upgrade_noengine versioning.truncate_privilege

main.mysql_upgrade_noengine 'innodb'     [ pass ]   7889
versioning.truncate_privilege 'innodb'   [ fail ]
        Test ended at 2020-03-25 22:34:42
 
CURRENT_TEST: versioning.truncate_privilege
mysqltest: At line 37: query 'grant all on *.* to mysqltest_1@localhost' failed: 1045: Access denied for user 'root'@'localhost' (using password: NO)
 
The result from queries just before the failure was:
< snip >
connection root;
create table mysqltest.t (a int) with system versioning;

See also
http://buildbot.askmonty.org/buildbot/builders/win32-debug/builds/16679/steps/test/logs/stdio
http://buildbot.askmonty.org/buildbot/builders/winx64-debug/builds/18261/steps/test/logs/stdio

If I revert 19e998d20c2b209305057fddb8fddf243d4f0619 ( MDEV-22030), everything this fixes it.



 Comments   
Comment by Alexander Barkov [ 2020-03-26 ]

https://github.com/MariaDB/server/commit/b8e75791943d8220fde6c1ab80885e01601253c3

Generated at Thu Feb 08 09:11:44 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.