Skip to content

Instantly share code, notes, and snippets.

@eduavila
Created February 9, 2024 21:41
Show Gist options
  • Save eduavila/105b9d0117da2e27e2d5672626a7c378 to your computer and use it in GitHub Desktop.
Save eduavila/105b9d0117da2e27e2d5672626a7c378 to your computer and use it in GitHub Desktop.
Adicionar permissão mysql

Adicionar permissão

 GRANT SELECT, SHOW VIEW ON basededados.* TO 'usuario'@'%';
 flush privileges;

Visualizar permissões do usuário.

show grants for 'usuario'@'%';

REMOVENDO ACESSOS.


REVOKE ALL PRIVILEGES ON *.* FROM 'usuario'@'%';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment