mysql 8 exec query shell

#!/bin/bash

MYSQL_PWD="${DB_PASSWORD:-ndasmu}"
export MYSQL_PWD

mysql -u root --raw dbname << "EOF"
    SELECT id, name, telo
    FROM tablenya
    ORDER BY id DESC
    LIMIT 10
EOF

unset MYSQL_PWD

#!/bin/bash
MYSQL_PWD="${DB_PASSWORD:-ndasmu}"
export MYSQL_PWD

mysql -u root dbname -e "select 1"

unset MYSQL_PWD

#!/bin/bash
echo "[client]" > /dev/shm/hapus
echo "user=root" >> /dev/shm/hapus
echo "password=ndasmu" >> /dev/shm/hapus

mysql --defaults-extra-file=/dev/shm/hapus dbname -e "select 1"

rm /dev/shm/hapus