Criar usuário no MYSQL

#Criar usuário

CREATE USER 'site'@'%' IDENTIFIED BY 'site';
CREATE USER 'site'@'localhost' IDENTIFIED BY 'site';

#Liberar acesso

GRANT ALL ON site.* TO 'site'@'%' IDENTIFIED BY 'site' WITH GRANT OPTION;
GRANT ALL ON site.* TO 'site'@'localhost' IDENTIFIED BY 'site' WITH GRANT OPTION;

#Trocar senha

update mysql.user set password=PASSWORD('site') where user='site';

#Apagar usuário

DROP USER 'site'@'%';

FLUSH PRIVILEGES;