MySQL对以特定名字开头的数据库进行授权

分类: IT文章 • 2022-03-29 21:27:56

对以"db_1"开头的数据库进行授权

grant all privileges on `db_1%`.* to dp_admin identified by 'password';

grant select on `db_1%`.* to dp_admin identified by 'password';