grant all privileges on schema_name.* to 'new_user_name'@'%' identified by 'newpassword';
Attention: This can be used to create new root user