svaroqui
commented
1 year ago Pease make sure all the nodes get those privileges for both db-servers-credential and replication-credential user
Open zhituanchen opened 1 year ago
svaroqui
commented
1 year ago Pease make sure all the nodes get those privileges for both db-servers-credential and replication-credential user
Hi I got a error about the privilege: The current version: v2.2.32.How to solve it.thk!
The user privileges list: root@localhost:3306(production)(none) 17:12:49>SELECT COALESCE(MAX(Select_priv),'N') as Select_priv, COALESCE(MAX(Process_priv),'N') as Process_priv, COALESCE(MAX(Super_priv),'N') as Super_priv, COALESCE(MAX(Repl_slave_priv),'N') as Repl_slave_priv, COALESCE(MAX(Repl_client_priv),'N') as Repl_client_priv, COALESCE(MAX(Reload_priv),'N') as Reload_priv FROM mysql.user WHERE user = 'dbadmin' AND host IN('mongodb-dev-master','10.0.0.231','%','10.0.0.231/255.0.0.0','10.0.0.231/255.255.0.0','10.0.0.231/255.255.255.0','10.%.%.%','10.0.%.%','10.0.0.%','10.%','10.0.%'); +-------------+--------------+------------+-----------------+------------------+-------------+ | Select_priv | Process_priv | Super_priv | Repl_slave_priv | Repl_client_priv | Reload_priv | +-------------+--------------+------------+-----------------+------------------+-------------+ | Y | Y | Y | Y | Y | Y | +-------------+--------------+------------+-----------------+------------------+-------------+ 1 row in set (0.01 sec)
root@localhost:3306(production)(none) 17:12:50>SELECT COALESCE(MAX(Select_priv),'N') as Select_priv, COALESCE(MAX(Process_priv),'N') as Process_priv, COALESCE(MAX(Super_priv),'N') as Super_priv, COALESCE(MAX(Repl_slave_priv),'N') as Repl_slave_priv, COALESCE(MAX(Repl_client_priv),'N') as Repl_client_priv, COALESCE(MAX(Reload_priv),'N') as Reload_priv FROM mysql.user WHERE user = 'repl_slave' AND host IN('10.0.0.162','10.0.0.162','%','10.0.0.162/255.0.0.0','10.0.0.162/255.255.0.0','10.0.0.162/255.255.255.0','10.%.%.%','10.0.%.%','10.0.0.%','10.%','10.0.%'); +-------------+--------------+------------+-----------------+------------------+-------------+ | Select_priv | Process_priv | Super_priv | Repl_slave_priv | Repl_client_priv | Reload_priv | +-------------+--------------+------------+-----------------+------------------+-------------+ | Y | Y | Y | Y | Y | Y | +-------------+--------------+------------+-----------------+------------------+-------------+ 1 row in set (0.00 sec)
grant REPLICATION CLIENT,SUPER,RELOAD on . to dbadmin@'%'; grant REPLICATION CLIENT,SUPER,RELOAD on . to dbadmin@'localhost'; grant REPLICATION CLIENT,SUPER,RELOAD on . to repl_slave@'%';