On 10.3 or earlier versions, create a user identified via ed25519 plugin:
MariaDB [test]> install soname 'auth_ed25519';
|
Query OK, 0 rows affected (0.00 sec)
|
|
MariaDB [test]> create user foo@localhost identified via ed25519 using 'test';
|
Query OK, 0 rows affected (0.01 sec)
|
|
MariaDB [test]> select user, host, password, plugin, authentication_string from mysql.user where user = 'foo' \G
|
*************************** 1. row ***************************
|
user: foo
|
host: localhost
|
password:
|
plugin: ed25519
|
authentication_string: test
|
1 row in set (0.00 sec)
|
Shutdown the server, start 10.4 on the same datadir, run mysql_upgrade.
MariaDB [test]> select plugin_name, plugin_status from information_schema.plugins where plugin_name = 'ed25519';
|
+-------------+---------------+
|
| plugin_name | plugin_status |
|
+-------------+---------------+
|
| ed25519 | ACTIVE |
|
+-------------+---------------+
|
1 row in set (0.00 sec)
|
|
MariaDB [test]> show grants for foo@localhost;
|
ERROR 1141 (42000): There is no such grant defined for user 'foo' on host 'localhost'
|
|
MariaDB [test]> select user, host, password, plugin, authentication_string from mysql.user where user = 'foo' \G
|
*************************** 1. row ***************************
|
User: foo
|
Host: localhost
|
Password:
|
plugin: ed25519
|
authentication_string: test
|
1 row in set (0.01 sec)
|
It appears that the rules have become stricter, and now authentication_string must be the hashed password. Unfortunately, it's not that simple to unset/update the password. I did it eventually this way:
MariaDB [test]> update mysql.global_priv set Priv = '{"access":0,"ssl_type":0,"ssl_cipher":"","x509_issuer":"","x509_subject":"","max_questions":0,"max_updates":0,"max_connections":0,"max_user_connections":0,"max_statement_time":0.000000,"plugin":"ed25519","authentication_string":"","default_role":"","is_role":false}' where user = 'foo';
|
Query OK, 1 row affected (0.01 sec)
|
Rows matched: 1 Changed: 1 Warnings: 0
|
|
MariaDB [test]> flush privileges;
|
Query OK, 0 rows affected (0.00 sec)
|
Now it works:
MariaDB [test]> show grants for foo@localhost;
|
+----------------------------------------------------------------+
|
| Grants for foo@localhost |
|
+----------------------------------------------------------------+
|
| GRANT USAGE ON *.* TO 'foo'@'localhost' IDENTIFIED VIA ed25519 |
|
+----------------------------------------------------------------+
|
1 row in set (0.00 sec)
|
- is duplicated by
-
MDEV-17950
SHOW GRANTS FOR does not work for a user identified with non-existing plugin
-
-
Closed
{"report":{"fcp":1045.1000003814697,"ttfb":219.10000038146973,"pageVisibility":"visible","entityId":71975,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"ab8eb31f-04a6-4b42-85a3-94f0dc533c56","navigationType":0,"readyForUser":1139.9000005722046,"redirectCount":0,"resourceLoadedEnd":1154.8000001907349,"resourceLoadedStart":234.10000038146973,"resourceTiming":[{"duration":320.69999980926514,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":234.10000038146973,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":234.10000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":554.8000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":320.79999923706055,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2cib/820016/12ta74/2bf333562ca6724060a9d5f1535471f6/_/download/contextbatch/css/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":234.4000005722046,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":234.4000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":555.1999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":329.9000005722046,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":234.69999980926514,"connectEnd":234.69999980926514,"connectStart":234.69999980926514,"domainLookupEnd":234.69999980926514,"domainLookupStart":234.69999980926514,"fetchStart":234.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":234.69999980926514,"responseEnd":564.6000003814697,"responseStart":564.6000003814697,"secureConnectionStart":234.69999980926514},{"duration":387.19999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/s/2d8175ec2fa4c816e8023260bd8c1786-CDN/lu2cib/820016/12ta74/2bf333562ca6724060a9d5f1535471f6/_/download/contextbatch/js/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true","startTime":234.9000005722046,"connectEnd":234.9000005722046,"connectStart":234.9000005722046,"domainLookupEnd":234.9000005722046,"domainLookupStart":234.9000005722046,"fetchStart":234.9000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":234.9000005722046,"responseEnd":622.1000003814697,"responseStart":622.1000003814697,"secureConnectionStart":234.9000005722046},{"duration":390.9000005722046,"initiatorType":"script","name":"https://jira.mariadb.org/s/a9324d6758d385eb45c462685ad88f1d-CDN/lu2cib/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":235,"connectEnd":235,"connectStart":235,"domainLookupEnd":235,"domainLookupStart":235,"fetchStart":235,"redirectEnd":0,"redirectStart":0,"requestStart":235,"responseEnd":625.9000005722046,"responseStart":625.9000005722046,"secureConnectionStart":235},{"duration":391.30000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":235.19999980926514,"connectEnd":235.19999980926514,"connectStart":235.19999980926514,"domainLookupEnd":235.19999980926514,"domainLookupStart":235.19999980926514,"fetchStart":235.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":235.19999980926514,"responseEnd":626.5,"responseStart":626.4000005722046,"secureConnectionStart":235.19999980926514},{"duration":391.3999996185303,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":235.4000005722046,"connectEnd":235.4000005722046,"connectStart":235.4000005722046,"domainLookupEnd":235.4000005722046,"domainLookupStart":235.4000005722046,"fetchStart":235.4000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":235.4000005722046,"responseEnd":626.8000001907349,"responseStart":626.8000001907349,"secureConnectionStart":235.4000005722046},{"duration":473.1000003814697,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2cib/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":235.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":235.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":708.6000003814697,"responseStart":0,"secureConnectionStart":0},{"duration":391.70000076293945,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":235.69999980926514,"connectEnd":235.69999980926514,"connectStart":235.69999980926514,"domainLookupEnd":235.69999980926514,"domainLookupStart":235.69999980926514,"fetchStart":235.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":235.69999980926514,"responseEnd":627.4000005722046,"responseStart":627.3000001907349,"secureConnectionStart":235.69999980926514},{"duration":472.79999923706055,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2cib/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.css?jira.create.linked.issue=true","startTime":235.9000005722046,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":235.9000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":708.6999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":391.80000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/s/5d5e8fe91fbc506585e83ea3b62ccc4b-CDN/lu2cib/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.js?jira.create.linked.issue=true&locale=en","startTime":236.10000038146973,"connectEnd":236.10000038146973,"connectStart":236.10000038146973,"domainLookupEnd":236.10000038146973,"domainLookupStart":236.10000038146973,"fetchStart":236.10000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":236.10000038146973,"responseEnd":627.9000005722046,"responseStart":627.9000005722046,"secureConnectionStart":236.10000038146973},{"duration":787.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":236.9000005722046,"connectEnd":236.9000005722046,"connectStart":236.9000005722046,"domainLookupEnd":236.9000005722046,"domainLookupStart":236.9000005722046,"fetchStart":236.9000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":236.9000005722046,"responseEnd":1024.4000005722046,"responseStart":1024.4000005722046,"secureConnectionStart":236.9000005722046},{"duration":917.8000001907349,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":237,"connectEnd":237,"connectStart":237,"domainLookupEnd":237,"domainLookupStart":237,"fetchStart":237,"redirectEnd":0,"redirectStart":0,"requestStart":237,"responseEnd":1154.8000001907349,"responseStart":1154.6999998092651,"secureConnectionStart":237},{"duration":305.20000076293945,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":720.6999998092651,"connectEnd":720.6999998092651,"connectStart":720.6999998092651,"domainLookupEnd":720.6999998092651,"domainLookupStart":720.6999998092651,"fetchStart":720.6999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":720.6999998092651,"responseEnd":1025.9000005722046,"responseStart":1025.9000005722046,"secureConnectionStart":720.6999998092651},{"duration":196.89999961853027,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":1014.6000003814697,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1014.6000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1211.5,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":46,"responseStart":219,"responseEnd":227,"domLoading":231,"domInteractive":1269,"domContentLoadedEventStart":1269,"domContentLoadedEventEnd":1318,"domComplete":2357,"loadEventStart":2357,"loadEventEnd":2359,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1250},{"name":"bigPipe.sidebar-id.end","time":1250.8000001907349},{"name":"bigPipe.activity-panel-pipe-id.start","time":1251},{"name":"bigPipe.activity-panel-pipe-id.end","time":1253.5},{"name":"activityTabFullyLoaded","time":1331.3000001907349}],"measures":[],"correlationId":"c12d57c4d960a1","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":104,"dbReadsTimeInMs":10,"dbConnsTimeInMs":18,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}