create user 'admin'@'127.0.0.1' ;
GRANT ALL PRIVILEGES ON *.* TO 'admin'@'127.0.0.1'  WITH GRANT OPTION;
ALTER USER 'admin'@'127.0.0.1' IDENTIFIED WITH mysql_native_password BY '2y';

create user 'admin'@'localhost' ;
GRANT ALL PRIVILEGES ON *.* TO 'admin'@'localhost'  WITH GRANT OPTION;
ALTER USER 'admin'@'localhost' IDENTIFIED WITH mysql_native_password BY '2y';

create user 'admin'@'%' identified by '2y';
GRANT ALL PRIVILEGES ON *.* TO 'admin'@'%'  WITH GRANT OPTION;
ALTER USER 'admin'@'%' IDENTIFIED WITH mysql_native_password BY '2y';

 
create database db1;
create database db2;
create user 'admin'@'%' identified by 'Automng_123';
GRANT SELECT, INSERT, UPDATE, DELETE,CREATE,DROP,TRUNCATE,RENAME TABLES ON db1.* TO 'admin'@'%';
GRANT SELECT, INSERT, UPDATE, DELETE,CREATE,DROP,TRUNCATE,RENAME TABLES ON db2.* TO 'admin'@'%';

GRANT SELECT, INSERT, UPDATE, DELETE ON db2.* TO 'admin'@'%';

CREATE,DROP,TRUNCATE

GRANT ALTER,CREATE,DROP ON db2.* TO 'admin'@'%';

GRANT TRUNCATE TABLES  ON db2.* TO 'admin'@'%';
GRANT RENAME TABLES  ON *.* TO 'admin'@'%';

GRANT TRUNCATE ON database_name.table_name TO 'username'@'host';