<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><br class=""><div><blockquote type="cite" class=""><div class="">Aber ich vermute eher du hast am hostname rumgemacht?</div><div class=""><div class=""><br class="">Gruß<br class="">Udo<br class=""></div></div></blockquote><br class=""></div><div>ich habe einen dbadmin für den externen Zugriff eingerichet</div><div>meinst du das?</div><div>(ging aber auch schon am alten Raspi)</div><div><br class=""></div><div>so:</div><div><pre style="margin: 0cm 0cm 0.0001pt 36pt; font-size: 10pt; font-family: 'Courier New'; text-indent: -18pt;" class=""><span lang="EN-US" class=""><br class=""></span></pre><pre style="margin: 0cm 0cm 0.0001pt 36pt; font-size: 10pt; font-family: 'Courier New'; text-indent: -18pt;" class=""><span lang="EN-US" class="">sudo nano /etc/mysql/my.cnf<o:p class=""></o:p></span></pre><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span lang="EN-US" class=""> </span></div><div style="margin: 0cm 0cm 0.0001pt 36pt; font-size: 11pt; font-family: Calibri, sans-serif; text-indent: -18pt;" class="">Dann die bind adress auf deine IP ändern oder auskommentieren.<o:p class=""></o:p></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div><pre style="margin: 0cm 0cm 0.0001pt 36pt; font-size: 10pt; font-family: 'Courier New'; text-indent: -18pt;" class="">service mysql restart<o:p class=""></o:p></pre><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div><div style="margin: 0cm 0cm 0.0001pt 36pt; font-size: 11pt; font-family: Calibri, sans-serif; text-indent: -18pt;" class=""><span lang="EN-US" class="">mysql --user=root --password=raspberry<o:p class=""></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span lang="EN-US" class=""> </span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span lang="EN-US" style="font-size: 10pt; font-family: 'Courier New';" class="">use mysql;<o:p class=""></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span lang="EN-US" style="font-size: 10pt; font-family: 'Courier New';" class="">CREATE USER <a href="mailto:%22dbadmin%22@%22192.168.178.Deine" style="color: purple;" class="">"dbadmin"@"192.168.178.Deine</a>IP" IDENTIFIED BY "meinPasswort";<o:p class=""></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span lang="EN-US" style="font-size: 10pt; font-family: 'Courier New';" class="">GRANT ALL PRIVILEGES ON *.* TO "dbadmin"@"192.168.178.DeineIP";<o:p class=""></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span lang="EN-US" style="font-size: 10pt; font-family: 'Courier New';" class="">Update user set host='%' where user='dbadmin';<o:p class=""></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span style="font-size: 10pt; font-family: 'Courier New';" class="">flush privileges;</span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span style="font-size: 10pt; font-family: 'Courier New';" class=""><br class=""></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span style="font-size: 10pt; font-family: 'Courier New';" class=""><br class=""></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span style="font-size: 10pt; font-family: 'Courier New';" class=""><br class=""></span></div></div><div><br class=""></div><br class=""></body></html>