====== Create and Permissions ======

**Syntax - Create User**

<code sql>
CREATE USER 'username'@'host' IDENTIFIED WITH authentication_plugin BY 'password';

Beispiel:
CREATE USER 'sammy'@'localhost' IDENTIFIED BY 'password';
</code>


**Syntax Grant**

<code sql>
GRANT PRIVILEGE ON database.table TO 'username'@'host';
FLUSH PRIVILEGES;

Beispiel:
GRANT CREATE, ALTER, DROP, INSERT, UPDATE, DELETE, SELECT, REFERENCES, RELOAD on *.* TO 'sammy'@'localhost' WITH GRANT OPTION;

SHOW GRANTS FOR 'username'@'host';
</code>

**Sonstiges**
<code sql>
REVOKE type_of_permission ON database_name.table_name FROM 'username'@'host';
DROP USER 'username'@'localhost';
</code>