Granted as a whole to roles, databases are not shown in SHOW DATABASES

--error 0,ER_CANNOT_USER

drop user beep@'%';

--error 0,ER_CANNOT_USER

drop role r1;

drop database if exists db;

create role r1;

create user beep@'%';

create database db;

create table db.t1 (i int);

grant select on db.* to r1;

grant r1 to beep@'%';

--connect (con1,localhost,beep,,)

show databases;

set role r1;

show databases;

drop user beep@'%';

drop role r1;

drop database if exists db;

Warnings:

Note	1008	Can't drop database 'db'; database doesn't exist

create role r1;

create user beep@'%';

create database db;

create table db.t1 (i int);

grant select on db.* to r1;

grant r1 to beep@'%';

show databases;

Database

information_schema

test

set role r1;

show databases;

Database

db

information_schema

test

@@ -16,6 +16,5 @@

 set role r1;

 show databases;

 Database

-db

 information_schema

 test

mysqltest: Result length mismatch