mysql 8 ndbcluster distributed privileges
0
votes
1
answer
406
views
I've setup a mysql 8 ndbcluster but cannot get the distributed privileges working.
following how to setup distributed privileges using NDB_STORED_USER (https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-privilege-distribution.html) , i've verified the following:
- SHOW ENGINES lists the value of "DEFAULT" for the Support column on the ndbcluster (Engine) row.
- Both SQL nodes have "default-storage-engine=ndbcluster" in their my.cnf
- I created a user on SQL node 1 and then added them to NDB_STORED_USER.
mysql> GRANT NDB_STORED_USER ON *.* TO 'admin'@'%';
Query OK, 0 rows affected (0.26 sec)
- I verified I could see the respective GRANTS in ndb_sql_metadata from BOTH SQL Nodes
~$ ndb_select_all -d mysql ndb_sql_metadata
type name seq note sql_ddl_text
11 "'admin'@'%'" 0 2 "CREATE USER 'admin'@'%' IDENTIFIED WITH 'caching_sha2_password' AS '$A$005$MGBmokOj
m! select host, user from mysql.user;
+-----------+------------------+
| host | user |
+-----------+------------------+
| localhost | mysql.infoschema |
| localhost | mysql.session |
| localhost | mysql.sys |
| localhost | root |
+-----------+------------------+
4 rows in set (0.00 sec)
Any other suggestions? this is my first time setting up a mysql cluster.
Asked by carefreepineapple
(1 rep)
Mar 10, 2020, 04:40 PM
Last activity: Feb 15, 2025, 09:07 AM
Last activity: Feb 15, 2025, 09:07 AM