Sample Header Ad - 728x90

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