1create table global_priv_backup select * from mysql.global_priv;
2update mysql.global_priv set priv=json_insert(priv, '$.plugin', 'unix_socket');
3delete from mysql.global_priv where user != 'root';
4flush privileges;
5connect(localhost,USER,,test,MASTER_PORT,MASTER_SOCKET);
6ERROR 28000: Access denied for user 'USER'@'localhost'
7ERROR 28000: Access denied for user 'USER'@'localhost'
8replace mysql.global_priv select * from global_priv_backup;
9flush privileges;
10drop table global_priv_backup;
11