CREATE SCHEMA IF NOT EXISTS _mydbtest_ DEFAULT CHARACTER SET latin1; GRANT USAGE ON *.* TO 'superadmin'; DROP USER 'superadmin'; grant all on _mydbtest_.* to 'superadmin'@'localhost' identified by 'superadmin'; flush privileges;