Replication复制权限发生变化
1) SHOW MASTER STATUS语句更名为SHOW BINLOG STATUS 2) REPLICATION CLIENT权限更名为BINLOG MONITOR 3) SHOW BINLOG EVENTS语句需要BINLOG MONITOR权限 4) SHOW SLAVE HOSTS语句需要REPLICATION MASTER ADMIN权限 5) SHOW SLAVE STATUS语句需要REPLICATION SLAVE ADMIN和SUPER权限 6) SHOW RELAYLOG EVENTS语句需要REPLICATION SLAVE ADMIN权限
例如,在之前的版本,搭建主从复制,赋予账号权限通常是
GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'repl'@'%' IDENTIFIED BY 'repl';
MariaDB 10.5版本里,改为:
GRANT REPLICATION SLAVE, REPLICATION SLAVE ADMIN, REPLICATION MASTER ADMIN, REPLICATION SLAVE ADMIN, BINLOG MONITOR, SUPER ON *.* TO 'repl'@'%' IDENTIFIED BY 'repl';