Allow mysql remote access

Enable bind address at


change bind address to your ip remote or to allow from all

add mysql port to firewall via ufw allow mysql

CREATE USER 'user'@'ip_address' IDENTIFIED BY 'some_pass';
GRANT ALL PRIVILEGES ON *.* TO 'user'@'ip_address';

If you see %, well then, there’s another problem altogether as that is “any remote source”. If however you do want any/all systems to connect via root, use the % wildcard to grant access:

CREATE USER 'user'@'%' IDENTIFIED BY 'some_pass';

Finally, reload the permissions, and you should be able to have remote access:


Howto use B-L072Z-LRWAN1 with lmic

My notes howto make B-L072Z-LRWAN1 can use lmic in arduino, i’m using standard lmic and this library can’t work until you add manually pin spi at your setup.


And you can use this pinout

// Pin mapping
const lmic_pinmap lmic_pins = {
.nss = PA15,
.rst = PC0,
.dio = {PB4, PB1, PB0},

For complete code you can see at my github here

Add dependency when install Pillow at alpine image docker

Pillow needs dependency jpeg-dev, zlib-dev and libjpeg so add this to your Dockerfile before requirement instalation

RUN apk add jpeg-dev zlib-dev libjpeg
COPY ./requirements.txt .
And rebuilt the image, hope this helps

Happy Codding 
Salam Ngoprek

Rangkuman Cloud AWS

  • Lima pilar dari AWS Well-Architected Framework, di antaranya:
    • Operational excellence (Keunggulan Operasional)
    • Security (Keamanan)
    • Reliability (Keandalan)
    • Performance efficiency (Efisiensi Kinerja)
    • Cost optimization (Pengoptimalan Biaya)
  • Enam manfaat dari komputasi cloud, antara lain:
    • Ubah pengeluaran di muka menjadi pengeluaran variabel.
    • Manfaatkan masifnya skala ekonomi.
    • Berhenti menebak kapasitas.
    • Tingkatkan kecepatan dan ketangkasan.
    • Hentikan biaya pengelolaan dan pemeliharaan data center.
    • Mendunia dalam hitungan menit.

Remote Desktop Linux Mint

Install vino

sudo apt install vino

type on your terminal

gsettings set org.gnome.Vino require-encryption false

gsettings set org.gnome.Vino prompt-enabled false

sudo vim /etc/lightdm/lightdm.conf


add startup


node-red flow menampilkan data dari gps

[{"id":"81f9ffeb.66d4d","type":"gpsd","z":"e108dd82.a3cce","name":"","hostname":"localhost","port":"2947","tpv":true,"sky":false,"info":false,"device":false,"gst":false,"att":false,"x":400,"y":160,"wires":[["33ea6491.a441ac","9f80de4c.be389"]]},{"id":"33ea6491.a441ac","type":"debug","z":"e108dd82.a3cce","name":"","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":710,"y":160,"wires":[]},{"id":"9f80de4c.be389","type":"function","z":"e108dd82.a3cce","name":"","func":"msg.payload = {\n    name:\"cyberdeck\",\n    icon:\"fa-car\",\n    lat :,\n    lon : msg.payload.lon,\n}\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":570,"y":260,"wires":[["f568e1f8.f22dd","a3414ec7.91967"]]},{"id":"f568e1f8.f22dd","type":"debug","z":"e108dd82.a3cce","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":820,"y":260,"wires":[]},{"id":"a3414ec7.91967","type":"worldmap","z":"e108dd82.a3cce","name":"","lat":"","lon":"","zoom":"12","layer":"OSM","cluster":"","maxage":"","usermenu":"show","layers":"show","panit":"false","panlock":"false","zoomlock":"false","hiderightclick":"false","coords":"none","showgrid":"false","allowFileDrop":"false","path":"/map","x":800,"y":360,"wires":[]}]