CREATE USER 'devops'@'%' IDENTIFIED BY 'devOps_';

grants the required permissions.

GRANT SELECT, INSERT, UPDATE, CREATE, RELOAD, SHOW DATABASES ON . TO devops@'%' with grant option;

FLUSH PRIVILEGES;

verfiying DROP and ALTER permissons that we didn't allow to devops user.

DROP DATABASE test;

here you can check we are not able to DROP database. if i will allow DROP permission to user then user can DROP database,

GRANT DROP ON . TO devops@'%' with grant option; FLUSH PRIVILEGES;

Note: we need to run these cmd on master user.