<div dir="auto">Hi Daniel,<div dir="auto"><br></div><div dir="auto">was macht GRANT USAGE? Die Doku sagt dazu:</div><div dir="auto">The <a href="https://dev.mysql.com/doc/refman/5.7/en/privileges-provided.html#priv_usage" style="margin:0px;padding:0px;vertical-align:baseline;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial"><font color="#000000" face="courier new, courier, fixed, monospace"><span style="border-style:initial;border-color:initial;outline-color:initial;outline-style:initial;font-size:12.6814px;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial">USAGE</span></font></a> privilege specifier stands for <span style="margin:0px;padding:0px;border:0px;outline:0px;vertical-align:baseline;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;width:auto">“<span style="margin:0px;padding:0px;border:0px;outline:0px;vertical-align:baseline;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;width:auto">no privileges.</span>”</span><br></div><div dir="auto">(<a href="https://dev.mysql.com/doc/refman/5.7/en/privileges-provided.html#priv_usage">https://dev.mysql.com/doc/refman/5.7/en/privileges-provided.html#priv_usage</a>)<br></div><div dir="auto"><br></div><div dir="auto">Und ist @'localhost' beim zweiten GRANT beabsichtigt?</div><div dir="auto"><br></div><div dir="auto">Grüße</div><div dir="auto">Frank</div></div><div class="gmail_extra"><br><div class="gmail_quote">Am 15.01.2018 11:06 AM schrieb "Daniel Lauckner" <<a href="mailto:vz@jahp.de" target="_blank">vz@jahp.de</a>>:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hallo,<br>
<br>
<br>
am Montag, 15. Januar 2018 um 10:44 hat <a href="mailto:ralf.wismann@gmx.de">ralf.wismann@gmx.de</a> geschrieben:<br>
> Die externe Zugriffsmöglichkeit auf die Datenbank wäre mir sehr wichtig.<br>
<br>
Diese Datei editieren:<br>
sudo nano /etc/mysql/mariadb.conf.d/50-<wbr>server.cnf<br>
<br>
Adresse von 127.0.0.1 auf folegnd ändern:<br>
bind-address            = 0.0.0.0<br>
<br>
SQL neu starten:<br>
sudo systemctl restart mysqld<br>
<br>
Dann brauchst du noch einen DB-User mit externem Zugriff:<br>
sudo mysql -uroot -praspberry<br>
CREATE USER 'vz'@'%' IDENTIFIED BY 'secure';<br>
GRANT USAGE ON *.* TO 'vz-admin'@'%';<br>
GRANT ALL PRIVILEGES ON `volkszaehler`.* TO 'vz-admin'@'localhost' WITH GRANT OPTION;<br>
exit<br>
<br>
Zu beachten wäre allerdings: '%' bedeutet das man auch außerhalb<br>
vom lokalen Netz zugreifen darf.<br>
<br>
<br>
mfg Daniel<br>
<br>
</blockquote></div></div>