.::: Install Golang 25 in Centos 9 :::.

 

1. download golang 

wget https://go.dev/dl/go1.25.7.linux-amd64.tar.gz

2. check after downlaod 

[root@teguhth-all golang]# wget https://go.dev/dl/go1.25.7.linux-amd64.tar.gz
--2026-02-09 15:59:22--  https://go.dev/dl/go1.25.7.linux-amd64.tar.gz
Resolving go.dev (go.dev)... 216.239.34.21, 216.239.38.21, 216.239.32.21, ...
Connecting to go.dev (go.dev)|216.239.34.21|:443... connected.
HTTP request sent, awaiting response... 302 Found
Location: https://dl.google.com/go/go1.25.7.linux-amd64.tar.gz [following]
--2026-02-09 15:59:22--  https://dl.google.com/go/go1.25.7.linux-amd64.tar.gz
Resolving dl.google.com (dl.google.com)... 74.125.24.136, 74.125.24.91, 74.125.24.190, ...
Connecting to dl.google.com (dl.google.com)|74.125.24.136|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 59768749 (57M) [application/x-gzip]
Saving to: ‘go1.25.7.linux-amd64.tar.gz’
 

.::: Sample Access Database MariaDB via Frontend & Backend using Lucee :::.

 

1. enable datasource 
 

2. backend 

http://10.10.10.90:8888/pembelian_api.cfm

[root@teguhth-all ROOT]# pwd
/opt/lucee/tomcat/webapps/ROOT
[root@teguhth-all ROOT]#
[root@teguhth-all ROOT]# cat pembelian_api.cfm
<cfquery name="qPembelian" datasource="dbteguhth">
 SELECT
        KODE_PEMBELIAN,
        KODE_BARANG,
        KODE_CUSTOMER,
        TANGGAL_PEMBELIAN,
        JUMLAH_PEMBELIAN
    FROM pembelian
</cfquery>

<cfcontent type="application/json">
<cfoutput>#serializeJSON(qPembelian)#</cfoutput>

[root@teguhth-all ROOT]#

.::: create Tools Migration from MongoDB to MariaDB using bash shell script nocsv :::.

  

1. sample data edb & mariadb

MySQL MariaDB
https://teguhth.blogspot.com/2019/04/study-kasus-praktis-belajar-query-mysql.html

MongoDB
https://teguhth.blogspot.com/2020/12/study-kasus-praktis-belajar-query.html

Install 
yum install jq -y

2. data server A & B 
server A mongodb
ip : 10.10.10.9
db : teguhth
port 27017
user : admin
password : admin

server B Mariadb
ip : 10.10.10.90
db : mariamongo
port 3306
user : admin
password : admin

buat script shell untuk migrasi dari server A mariadb to server B mongodb

3. run script migrasi 

migrasi_barang_mongo_to_mariadb_nocsv.sh
migrasi_customer_mongo_to_mariadb_nocsv.sh
migrasi_pasok_mongo_to_mariadb_nocsv.sh
migrasi_pembelian_mongo_to_mariadb_nocsv.sh
migrasi_suplier_mongo_to_mariadb_nocsv.sh

[root@teguhth-all nocsvmongo]# pwd
/data/migrasi/mongo-to-maria-and-reserve/nocsvmongo
[root@teguhth-all nocsvmongo]#
[root@teguhth-all nocsvmongo]# ls | grep _nocsv
migrasi_barang_mongo_to_mariadb_nocsv.sh
migrasi_customer_mongo_to_mariadb_nocsv.sh
migrasi_pasok_mongo_to_mariadb_nocsv.sh
migrasi_pembelian_mongo_to_mariadb_nocsv.sh
migrasi_suplier_mongo_to_mariadb_nocsv.sh
[root@teguhth-all nocsvmongo]#
 

4. result after migrasi 
 

5. script migrasi table barang 

[root@teguhth-all nocsvmongo]# pwd
/data/migrasi/mongo-to-maria-and-reserve/nocsvmongo
[root@teguhth-all nocsvmongo]#
[root@teguhth-all nocsvmongo]# cat migrasi_barang_mongo_to_mariadb_nocsv.sh
#!/bin/bash

########################################
# CONFIG
########################################

# MongoDB
MONGO_HOST="10.10.10.9"
MONGO_PORT="27017"
MONGO_DB="teguhth"
MONGO_USER="admin"
MONGO_PASS="admin"
MONGO_COLLECTION="barang"

# MariaDB
MARIA_HOST="10.10.10.90"
MARIA_PORT="3306"
MARIA_DB="mariamongo"
MARIA_USER="admin"
MARIA_PASS="admin"
MARIA_TABLE="barang"

########################################
# CREATE TABLE (optional)
########################################

echo "== Prepare MariaDB table =="

mariadb -h "$MARIA_HOST" -P "$MARIA_PORT" \
-u "$MARIA_USER" -p"$MARIA_PASS" "$MARIA_DB" <<EOF

CREATE TABLE IF NOT EXISTS $MARIA_TABLE (
    KODE_BARANG CHAR(6) PRIMARY KEY,
    NAMA_BARANG VARCHAR(25),
    SATUAN_BARANG VARCHAR(20),
    STOK_BARANG DECIMAL(4)
);

EOF

########################################
# STREAM INSERT
########################################

echo "== MongoDB → MariaDB INSERT =="

mongoexport \
  --host "$MONGO_HOST" \
  --port "$MONGO_PORT" \
  -u "$MONGO_USER" \
  -p "$MONGO_PASS" \
  --authenticationDatabase admin \
  -d "$MONGO_DB" \
  -c "$MONGO_COLLECTION" \
  --type=json |
jq -r '

"REPLACE INTO '"$MARIA_TABLE"' VALUES (\"" +
.KODE_BARANG + "\",\"" +
.NAMA_BARANG + "\",\"" +
.SATUAN_BARANG + "\"," +
(.STOK_BARANG|tostring) +
");"

' |
mariadb -h "$MARIA_HOST" -P "$MARIA_PORT" \
-u "$MARIA_USER" -p"$MARIA_PASS" "$MARIA_DB"

########################################
# DONE
########################################

echo "✅ Migrasi selesai — tanpa file CSV"

[root@teguhth-all nocsvmongo]#

6. script migrasi table suplier 

[root@teguhth-all nocsvmongo]# pwd
/data/migrasi/mongo-to-maria-and-reserve/nocsvmongo
[root@teguhth-all nocsvmongo]#
[root@teguhth-all nocsvmongo]# cat migrasi_suplier_mongo_to_mariadb_nocsv.sh
#!/bin/bash

########################################
# CONFIG
########################################

# MongoDB
MONGO_HOST="10.10.10.9"
MONGO_PORT="27017"
MONGO_DB="teguhth"
MONGO_USER="admin"
MONGO_PASS="admin"
MONGO_COLLECTION="suplier"

# MariaDB
MARIA_HOST="10.10.10.90"
MARIA_PORT="3306"
MARIA_DB="mariamongo"
MARIA_USER="admin"
MARIA_PASS="admin"
MARIA_TABLE="suplier"

########################################
# CREATE TABLE
########################################

echo "== Prepare MariaDB table suplier =="

mariadb -h "$MARIA_HOST" -P "$MARIA_PORT" \
-u "$MARIA_USER" -p"$MARIA_PASS" "$MARIA_DB" <<EOF

CREATE TABLE IF NOT EXISTS $MARIA_TABLE (
  KODE_SUPLIER CHAR(5) NOT NULL,
  NAMA_SUPLIER VARCHAR(30),
  ALAMAT_SUPLIER VARCHAR(30),
  KOTA_SUPLIER VARCHAR(15),
  TELEPON_SUPLIER VARCHAR(15),
  PRIMARY KEY (KODE_SUPLIER)
);

EOF

########################################
# STREAM INSERT
########################################

echo "== MongoDB → MariaDB INSERT suplier =="

mongoexport \
  --host "$MONGO_HOST" \
  --port "$MONGO_PORT" \
  -u "$MONGO_USER" \
  -p "$MONGO_PASS" \
  --authenticationDatabase admin \
  -d "$MONGO_DB" \
  -c "$MONGO_COLLECTION" \
  --type=json |
jq -r '

"REPLACE INTO '"$MARIA_TABLE"' VALUES (\"" +
.KODE_SUPLIER + "\",\"" +
.NAMA_SUPLIER + "\",\"" +
.ALAMAT_SUPLIER + "\",\"" +
.KOTA_SUPLIER + "\",\"" +
.TELEPON_SUPLIER + "\");"

' |
mariadb -h "$MARIA_HOST" -P "$MARIA_PORT" \
-u "$MARIA_USER" -p"$MARIA_PASS" "$MARIA_DB"

########################################
# DONE
########################################

echo "✅ Migrasi suplier selesai — tanpa CSV"

[root@teguhth-all nocsvmongo]#

7. script migrasi table customer 

[root@teguhth-all nocsvmongo]# pwd
/data/migrasi/mongo-to-maria-and-reserve/nocsvmongo
[root@teguhth-all nocsvmongo]#
[root@teguhth-all nocsvmongo]# cat migrasi_customer_mongo_to_mariadb_nocsv.sh
#!/bin/bash

########################################
# CONFIG
########################################

# MongoDB
MONGO_HOST="10.10.10.9"
MONGO_PORT="27017"
MONGO_DB="teguhth"
MONGO_USER="admin"
MONGO_PASS="admin"
MONGO_COLLECTION="customer"

# MariaDB
MARIA_HOST="10.10.10.90"
MARIA_PORT="3306"
MARIA_DB="mariamongo"
MARIA_USER="admin"
MARIA_PASS="admin"
MARIA_TABLE="customer"

########################################
# CREATE TABLE
########################################

echo "== Prepare MariaDB table customer =="

mariadb -h "$MARIA_HOST" -P "$MARIA_PORT" \
-u "$MARIA_USER" -p"$MARIA_PASS" "$MARIA_DB" <<EOF

CREATE TABLE IF NOT EXISTS $MARIA_TABLE (
  KODE_CUSTOMER CHAR(6),
  NAMA_CUSTOMER VARCHAR(30),
  ALAMAT_CUSTOMER VARCHAR(30),
  KOTA_CUSTOMER VARCHAR(15),
  TELEPON_CUSTOMER VARCHAR(15),
  PRIMARY KEY (KODE_CUSTOMER)
);

EOF

########################################
# STREAM INSERT
########################################

echo "== MongoDB → MariaDB INSERT customer =="

mongoexport \
  --host "$MONGO_HOST" \
  --port "$MONGO_PORT" \
  -u "$MONGO_USER" \
  -p "$MONGO_PASS" \
  --authenticationDatabase admin \
  -d "$MONGO_DB" \
  -c "$MONGO_COLLECTION" \
  --type=json |
jq -r '

"REPLACE INTO '"$MARIA_TABLE"' VALUES (\"" +
.KODE_CUSTOMER + "\",\"" +
.NAMA_CUSTOMER + "\",\"" +
.ALAMAT_CUSTOMER + "\",\"" +
.KOTA_CUSTOMER + "\",\"" +
.TELEPON_CUSTOMER + "\");"

' |
mariadb -h "$MARIA_HOST" -P "$MARIA_PORT" \
-u "$MARIA_USER" -p"$MARIA_PASS" "$MARIA_DB"

########################################
# DONE
########################################

echo "✅ Migrasi customer selesai — tanpa CSV"

[root@teguhth-all nocsvmongo]#

8. script migrasi table pasok 

[root@teguhth-all nocsvmongo]# pwd
/data/migrasi/mongo-to-maria-and-reserve/nocsvmongo
[root@teguhth-all nocsvmongo]#
[root@teguhth-all nocsvmongo]# cat migrasi_pasok_mongo_to_mariadb_nocsv.sh
#!/bin/bash

########################################
# CONFIG
########################################

# MongoDB
MONGO_HOST="10.10.10.9"
MONGO_PORT="27017"
MONGO_DB="teguhth"
MONGO_USER="admin"
MONGO_PASS="admin"
MONGO_COLLECTION="pasok"

# MariaDB
MARIA_HOST="10.10.10.90"
MARIA_PORT="3306"
MARIA_DB="mariamongo"
MARIA_USER="admin"
MARIA_PASS="admin"
MARIA_TABLE="pasok"

########################################
# CREATE TABLE
########################################

echo "== Prepare MariaDB table pasok =="

mariadb -h "$MARIA_HOST" -P "$MARIA_PORT" \
-u "$MARIA_USER" -p"$MARIA_PASS" "$MARIA_DB" <<EOF

CREATE TABLE IF NOT EXISTS $MARIA_TABLE (
  KODE_PASOK CHAR(10),
  KODE_BARANG CHAR(6),
  KODE_SUPLIER CHAR(5),
  TANGGAL_PASOK DATE,
  JUMLAH_PASOK DECIMAL(4),
  PRIMARY KEY (KODE_PASOK, KODE_BARANG, KODE_SUPLIER),
  FOREIGN KEY (KODE_BARANG) REFERENCES barang(KODE_BARANG),
  FOREIGN KEY (KODE_SUPLIER) REFERENCES suplier(KODE_SUPLIER)
);

EOF

########################################
# STREAM INSERT WITH DATE FIX
########################################

echo "== MongoDB → MariaDB INSERT pasok =="

mongoexport \
  --host "$MONGO_HOST" \
  --port "$MONGO_PORT" \
  -u "$MONGO_USER" \
  -p "$MONGO_PASS" \
  --authenticationDatabase admin \
  -d "$MONGO_DB" \
  -c "$MONGO_COLLECTION" \
  --type=json |

jq -r '

def month:
  ascii_downcase |
  {jan:"01",feb:"02",mar:"03",apr:"04",may:"05",jun:"06",
   jul:"07",aug:"08",sep:"09",oct:"10",nov:"11",dec:"12"}[.];

def pad2:
  tostring | if length==1 then "0"+. else . end;

def fixdate:
  capture("(?<d>\\d+)-(?<m>[A-Za-z]+)-(?<y>\\d+)") as $x
  | "20\($x.y)-\($x.m|month)-\($x.d|pad2)";

"REPLACE INTO '"$MARIA_TABLE"' VALUES (\"" +
.KODE_PASOK + "\",\"" +
.KODE_BARANG + "\",\"" +
.KODE_SUPLIER + "\",\"" +
(.TANGGAL_PASOK|fixdate) + "\"," +
(.JUMLAH_PASOK|tostring) +
");"

' |

mariadb -h "$MARIA_HOST" -P "$MARIA_PORT" \
-u "$MARIA_USER" -p"$MARIA_PASS" "$MARIA_DB"

########################################
# DONE
########################################

echo "✅ Migrasi pasok selesai — tanggal sudah dikonversi"

[root@teguhth-all nocsvmongo]#

9. script migrasi table pembelian 

[root@teguhth-all nocsvmongo]# pwd
/data/migrasi/mongo-to-maria-and-reserve/nocsvmongo
[root@teguhth-all nocsvmongo]#
[root@teguhth-all nocsvmongo]# cat migrasi_pembelian_mongo_to_mariadb_nocsv.sh
#!/bin/bash

########################################
# CONFIG
########################################

# MongoDB
MONGO_HOST="10.10.10.9"
MONGO_PORT="27017"
MONGO_DB="teguhth"
MONGO_USER="admin"
MONGO_PASS="admin"
MONGO_COLLECTION="pembelian"

# MariaDB
MARIA_HOST="10.10.10.90"
MARIA_PORT="3306"
MARIA_DB="mariamongo"
MARIA_USER="admin"
MARIA_PASS="admin"
MARIA_TABLE="pembelian"

########################################
# CREATE TABLE
########################################

echo "== Prepare MariaDB table pembelian =="

mariadb -h "$MARIA_HOST" -P "$MARIA_PORT" \
-u "$MARIA_USER" -p"$MARIA_PASS" "$MARIA_DB" <<EOF

CREATE TABLE IF NOT EXISTS $MARIA_TABLE (
  KODE_PEMBELIAN CHAR(10),
  KODE_BARANG CHAR(6),
  KODE_CUSTOMER CHAR(6),
  TANGGAL_PEMBELIAN DATE,
  JUMLAH_PEMBELIAN DECIMAL(4),
  PRIMARY KEY (KODE_PEMBELIAN, KODE_BARANG, KODE_CUSTOMER),
  FOREIGN KEY (KODE_BARANG) REFERENCES barang(KODE_BARANG),
  FOREIGN KEY (KODE_CUSTOMER) REFERENCES customer(KODE_CUSTOMER)
);

EOF

########################################
# STREAM INSERT + DATE FIX
########################################

echo "== MongoDB → MariaDB INSERT pembelian =="

mongoexport \
  --host "$MONGO_HOST" \
  --port "$MONGO_PORT" \
  -u "$MONGO_USER" \
  -p "$MONGO_PASS" \
  --authenticationDatabase admin \
  -d "$MONGO_DB" \
  -c "$MONGO_COLLECTION" \
  --type=json |

jq -r '

def month:
  ascii_downcase |
  {jan:"01",feb:"02",mar:"03",apr:"04",may:"05",jun:"06",
   jul:"07",aug:"08",sep:"09",oct:"10",nov:"11",dec:"12"}[.];

def pad2:
  tostring | if length==1 then "0"+. else . end;

def fixdate:
  capture("(?<d>\\d+)-(?<m>[A-Za-z]+)-(?<y>\\d+)") as $x
  | "20\($x.y)-\($x.m|month)-\($x.d|pad2)";

"REPLACE INTO '"$MARIA_TABLE"' VALUES (\"" +
.KODE_PEMBELIAN + "\",\"" +
.KODE_BARANG + "\",\"" +
.KODE_CUSTOMER + "\",\"" +
(.TANGGAL_PEMBELIAN|fixdate) + "\"," +
(.JUMLAH_PEMBELIAN|tostring) +
");"

' |

mariadb -h "$MARIA_HOST" -P "$MARIA_PORT" \
-u "$MARIA_USER" -p"$MARIA_PASS" "$MARIA_DB"

########################################
# DONE
########################################

echo "✅ Migrasi pembelian selesai — tanggal sudah dikonversi"

[root@teguhth-all nocsvmongo]#

.::: create Tools Migration from MariaDB to MongoDB using bash shell script using insert & no csv :::.

   

correlation with https://teguhth.blogspot.com/2025/12/create-tools-migration-from-mongodb-to.html

1. data migration server A Maria to server B mongo
server A Mariadb
ip : 10.10.10.90
db : teguhth
port 3306
user : admin
password : admin

server B mongodb
ip : 10.10.10.9
db : mariadbsample
port 27017
user : admin
password : admin

buat script shell untuk migrasi dari server A maria to server B mongo 

db.barang.find();

db.barang.drop();

db.suplier.find();

db.suplier.drop();

db.customer.find();

db.customer.drop();

db.pasok.find();

db.pasok.drop();

db.pembelian.find();

db.pembelian.drop();
 

.::: create Tools Migration from SQL Server MSSQL to MariaDB using bash shell script using insert & NoCSV :::.

 

correlation with https://teguhth.blogspot.com/2024/01/install-configure-odbcinstini-odbc-for.html

1. sample data mssql & mariadb

MySQL MariaDB
https://teguhth.blogspot.com/2019/04/study-kasus-praktis-belajar-query-mysql.html

MSSQL
https://teguhth.blogspot.com/2019/04/study-kasus-praktis-belajar-query.html

2. data server A & B 
server A sql server
ip : 10.10.10.7
db : teguhth
schema : dbo
port 1433
user : admin 
password : admin11!!

server B Mariadb
ip : 10.10.10.90
db : teguhthsql
port 3306
user : admin
password : admin

mysql -h 10.10.10.90 -uadmin -p --skip-ssl

buat script shell untuk migrasi dari server A mssql to server B 
 

.::: create Tools Migration from MariaDB to PostgreSQL using bash shell script (no csv):::.

  

correlation https://teguhth.blogspot.com/2025/12/create-tools-migration-from-postgresql.html

1. sample data edb & mariadb

MySQL MariaDB
https://teguhth.blogspot.com/2019/04/study-kasus-praktis-belajar-query-mysql.html

PostgreSQL
https://teguhth.blogspot.com/2019/09/study-kasus-praktis-belajar-query.html

2. data server A & B 

server A Mariadb
ip : 10.10.10.9
db : teguhth
port 3306
user : admin
password : admin

server B Postgres
ip : 10.10.10.90
db : mariaedb
port 5432
user : admin
password : admin
 

.::: Script backup Daily MariaDB Windows :::.

  

1. check
SHOW VARIABLES LIKE 'datadir';
SHOW VARIABLES LIKE 'basedir';

C:\Windows\system32>mariadb -uroot -proot
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 11
Server version: 10.11.11-MariaDB mariadb.org binary distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> SHOW VARIABLES LIKE 'datadir';
+---------------+--------------------------------------+
| Variable_name | Value                                |
+---------------+--------------------------------------+
| datadir       | C:\Program Files\MariaDB 10.11\data\ |
+---------------+--------------------------------------+
1 row in set (0.001 sec)

MariaDB [(none)]> SHOW VARIABLES LIKE 'basedir';
+---------------+---------------------------------+
| Variable_name | Value                           |
+---------------+---------------------------------+
| basedir       | C:\Program Files\MariaDB 10.11\ |
+---------------+---------------------------------+
1 row in set (0.001 sec)

MariaDB [(none)]>

.::: Shell Script to Detect and Compare AI-Generated vs Original Images and Videos :::.

  

A. Install

1. Install for image

sudo dnf install ImageMagick -y
sudo dnf install perl-Image-ExifTool -y

[root@teguhth-all sampleimage]# identify -version
Version: ImageMagick 6.9.13-25 Q16 x86_64 18639 https://legacy.imagemagick.org
Copyright: (C) 1999 ImageMagick Studio LLC
License: https://imagemagick.org/script/license.php
Features: Cipher DPC Modules OpenMP(4.5)
Delegates (built-in): bzlib cairo djvu fontconfig freetype gslib gvc jbig jng jp2 jpeg lcms lqr ltdl lzma openexr pangocairo png ps raqm raw rsvg tiff webp wmf x xml zlib
[root@teguhth-all sampleimage]#

[root@teguhth-all sampleimage]# convert -version
Version: ImageMagick 6.9.13-25 Q16 x86_64 18639 https://legacy.imagemagick.org
Copyright: (C) 1999 ImageMagick Studio LLC
License: https://imagemagick.org/script/license.php
Features: Cipher DPC Modules OpenMP(4.5)
Delegates (built-in): bzlib cairo djvu fontconfig freetype gslib gvc jbig jng jp2 jpeg lcms lqr ltdl lzma openexr pangocairo png ps raqm raw rsvg tiff webp wmf x xml zlib

[root@teguhth-all sampleimage]# exiftool -ver
13.10
[root@teguhth-all sampleimage]#

.::: Script to kill Locking in Database Oracle using oracle & root User :::.

 

1. run from https://teguhth.blogspot.com/2024/11/how-to-sample-simulation-blocking.html

export ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1
export ORACLE_SID=tgh
export PATH=$ORACLE_HOME/bin:$PATH

 

or 

 

export ORACLE_HOME=/u01/app/oracle/product/12.2.0/dbhome_1 
export ORACLE_SID=tgh 
export PATH=$ORACLE_HOME/bin:$PATH 

2. original script locking
SELECT
    s1.sid AS waiting_session,
    s1.serial# AS waiting_serial,
    s1.username AS waiting_user,
    s1.status AS waiting_status,
    s2.sid AS blocking_session,
    s2.serial# AS blocking_serial,
    s2.username AS blocking_user,
    s2.status AS blocking_status,
 s1.event,
    'ALTER SYSTEM KILL SESSION ''' || s1.sid || ',' || s1.serial# || ''' IMMEDIATE;' AS query_kill
FROM
    v$session s1
JOIN
    v$session s2
ON
    s1.blocking_session = s2.sid;

.::: Find ENCRYPTION_KEY_ID & CURRENT_KEY_ID MariaDB from OS & Database MariaDB :::.

 

correlation https://teguhth.blogspot.com/2023/06/enable-encryption-table-database-for.html
https://teguhth.blogspot.com/2023/05/how-to-remove-encryptionkeyid-from-file.html


A. from OS

1. query 1 
grep -o 'ENCRYPTION_KEY_ID`=[0-9]*' teguhth_enc.sql | sort | uniq

2. query 2

grep -o 'ENCRYPTION_KEY_ID`=[0-9]*' teguhth_enc.sql | cut -d= -f2 | sort | uniq

3. query 3

grep -i  ENCRYPTION_KEY_ID teguhth_enc.sql
 

 

.::: Sample Create VIEW, Routine / Store Procedure, Trigger with DEFINER=`simple_admin`@`%` in MariaDB :::.

 

correlation https://teguhth.blogspot.com/2019/04/study-kasus-praktis-belajar-query-mysql.html#more

1. create user 

SELECT Host, User FROM mysql.user WHERE User='simple_admin';

create user 'simple_admin'@'%' identified by 'simple_admin';

GRANT CREATE ROUTINE, ALTER ROUTINE, TRIGGER, CREATE VIEW
ON teguhth.* TO `simple_admin`@`%`;

GRANT EXECUTE ON PROCEDURE teguhth.sp_insert_pembelian
TO 'simple_admin'@'%';

GRANT ALL PRIVILEGES ON *.* TO 'simple_admin'@'%' WITH GRANT OPTION;

flush PRIVILEGES;

Kalau DEFINER tidak ada ? ERROR 1449
 

.::: Sample Access Database MariaDB via Frontend & Backend using php :::.

 

1. instal httpd

2. config 

[root@teguhth-all html]# pwd
/var/www/html
[root@teguhth-all html]# cat config.php
<?php
$host = "10.10.10.90";
$user = "admin";
$pass = "admin";
$db   = "teguhth";
$port = 3306;

$conn = new mysqli($host, $user, $pass, $db, $port);

if ($conn->connect_error) {
    die("Koneksi gagal: " . $conn->connect_error);
}
?>

[root@teguhth-all html]#
 

.::: create Tools Migration from SQL Server MSSQL to MariaDB using bash shell script using csv :::.

 

correlation with correlation with https://teguhth.blogspot.com/2024/01/install-configure-odbcinstini-odbc-for.html

1. sample data mssql & mariadb

MySQL MariaDB
https://teguhth.blogspot.com/2019/04/study-kasus-praktis-belajar-query-mysql.html

MSSQL
https://teguhth.blogspot.com/2019/04/study-kasus-praktis-belajar-query.html

2. data server A & B 
server A sql server
ip : 10.10.10.7
db : teguhth
schema : dbo
port 1433
user : admin 
password : admin11!!

server B Mariadb
ip : 10.10.10.90
db : teguhthsql
port 3306
user : admin
password : admin

mysql -h 10.10.10.90 -uadmin -p --skip-ssl

buat script shell untuk migrasi dari server A mssql to server B