github.com/pingcap/tiflow@v0.0.0-20240520035814-5bf52d54e205/dm/tests/dm_syncer/data/db2.prepare.user.sql (about)

     1  drop user if exists 'dm_syncer';
     2  flush privileges;
     3  create user 'dm_syncer'@'%' identified by '';
     4  grant all privileges on *.* to 'dm_syncer'@'%';
     5  revoke select, reload on *.* from 'dm_syncer'@'%';
     6  revoke create temporary tables, lock tables, create routine, alter routine, event, create tablespace, file, shutdown, execute, process, index on *.* from 'dm_syncer'@'%'; # privileges not supported by TiDB
     7  flush privileges;