====== MySQL Berechtigung erteilen ======

Einzelne Tabelle:

<code sql>
GRANT ALL PRIVILEGES ON DatabaseName.TableName TO 'User'@'localhost';
</code>

Alle Tabellen einer Datenbank:

<code sql>
GRANT ALL PRIVILEGES ON DatabaseName.* TO 'User'@'localhost';
</code>

Alle Datenbanken:

<code sql>
GRANT ALL PRIVILEGES ON *.* TO 'User'@'localhost';
</code>

Anschließend ein

<code SQL>
FLUSH PRIVILEGES;
</code>

[[https://chartio.com/resources/tutorials/how-to-grant-all-privileges-on-a-database-in-mysql/#database-specific-privileges|Quelle]], [[https://www.hostinger.com/tutorials/mysql/how-create-mysql-user-and-grant-permissions-command-line|Quelle2]], [[https://askubuntu.com/questions/34409/unable-to-login-to-phpmyadmin-with-the-root-user|Quelle3]]

{{tag>[MySQL Berechtigung GRANT]}}