Monthly Archives: January 2024

regular expression untuk NIP PNS Indonesia

Posted on Thursday, 25 January 2024 by site admin

Beberapa waktu lalu ada pertanyaan di komunitas bagaimana regular expression untuk NIP PNS Indonesia? Jadi NIP PNS Indonesia itu ada 18 digit angka semua yaitu terdiri dari 8 angka tahun bulan tanggal lahir ybs (dari tahun 1900 s.d 2099), 6 … Continue reading →

Posted in linux | Leave a comment

cara copy ssh publik key ke server tujuan/remote pakai command ssh-copy-id

Posted on Sunday, 14 January 2024 by site admin

oke, jadi biasanya saya kalau ssh ke server remote memang sudah pakai ssh key aja, males bolak-balik ngetikin password kalau mau nge-remote ke server dan memang cara ini lebih aman daripada pakai password tapi dengan catatan jangan sampai private key … Continue reading →

Posted in linux | Leave a comment

how to sort data in alias column on mysql

Posted on Saturday, 6 January 2024 by site admin

so i have been learning mysql syntax about a 5 days now and there is this LENGTH function in mysql that count string length in the column like this: SELECT id, LOWER(NAME) AS ‘Name Lower’, LENGTH(NAME) AS ‘Name Length’ FROM … Continue reading →

Posted in mysql | mariadb | Leave a comment

failed to start mariadb 10.5 on Rocky Linux 8.9

Posted on Wednesday, 3 January 2024 by riza

so this is my first post in 2024, probably would write again regularly. today i try to install mariadb 10.5 on rocky linux 8.9 and it is sucessfully installed but it failed to start. this is the error message from … Continue reading →

Posted in linux, my life, mysql | mariadb | Leave a comment