mysql server

// https://www.shellhacks.com/mysql-show-users-privileges-passwords/
//melihat user dan host yang diizinkan
SELECT user,host FROM mysql.user;

//distinct atau grouping user berdasarkan username
SELECT DISTINCT user FROM mysql.user;

//update host user di mysql
UPDATE mysql.user SET Host='%' WHERE Host='localhost' AND User='username';

SELECT
-- *
JSON_EXTRACT(object_json_namakolomnya, "$.penyedia_id")
FROM
permohonan_pembaruan_staging
WHERE
permohonan_pembaruan_id = '4512';

//buat user dan bisa di remote menggunakan IP lokal Server

CREATE USER 'nama_usernya'@'%' IDENTIFIED BY 'passwordnya_apa';

GRANT ALL ON *.* TO 'nama_usernya'@'%';

FLUSH PRIVILEGES;

- membuat user mysql dan privilege nya

CREATE USER 'nama_user'@'192.168.ipnya' IDENTIFIED BY 'passXXXX';

GRANT ALL PRIVILEGES ON * . * TO 'nama_user'@'192.168.ipnya';

flush privileges;

- cara melihat whitelist server linux : sudo iptables -L -v -n | more

- import data menggunakan terminal server

mysql -u <username> -p <databasename> < <filename.sql>