ปองพลบล็อค: 2023

วันอังคารที่ 28 พฤศจิกายน พ.ศ. 2566

jhcisbackup20231128

# !/bin/sh

/usr/local/mysql/bin/mysqldump --skip-comments --default-character-set=utf8 --routines --lock-tables=false --compatible=no_key_options -u root -pnhc03301 jhcisdb > /home/jhcis/Desktop/jhcisdb-backup-tmp/jhcisdb-03301.$(date -d "+0 day" "+%Y-%m-%d").sql

cd /home/jhcis/Desktop/jhcisdb-backup-tmp/

FILE1=jhcisdb-03301.$(date -d "+0 day" "+%Y-%m-%d").sql

if [ -f "$FILE1" ]; then

sudo zip -r jhcisdb-03301.$(date -d "+0 day" "+%Y-%m-%d").zip "$FILE1"

FILE2=jhcisdb-03301.$(date -d "+0 day" "+%Y-%m-%d").zip

sudo cp /home/jhcis/Desktop/jhcisdb-backup-tmp/$FILE2 /home/jhcis/Google\ Drive/jhcisbackup/

cd /home/jhcis/Google\ Drive/jhcisbackup/

if [ -f "$FILE2" ]; then

sudo rm -f /home/jhcis/Google\ Drive/jhcisbackup/jhcisdb-03301.$(date -d "-0 day" "+%Y-%m-%d").sql

sudo rm -f /home/jhcis/Google\ Drive/jhcisbackup/jhcisdb-03301.$(date -d "-32 day" "+%Y-%m-%d").zip

sudo rm -f /home/jhcis/Google\ Drive/jhcisbackup/jhcisdb-03301.$(date -d "-33 day" "+%Y-%m-%d").zip

วันพฤหัสบดีที่ 27 กรกฎาคม พ.ศ. 2566

MySQL Ver.5.6.45

MySQL Ver.5.6.45 ต้องทำพิธีเบิกเนตร ไม่งั้น ลูกๆมองหาแม่ไม่เจอ

===

CREATE USER 'root'@'%' IDENTIFIED BY '123456';

GRANT GRANT OPTION ON *.* TO 'root'@'%';

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE ON *.* TO 'root'@'%';

GRANT SELECT, INSERT, UPDATE, REFERENCES, DELETE, CREATE, DROP, ALTER, INDEX, TRIGGER, CREATE VIEW, SHOW VIEW, EXECUTE, ALTER ROUTINE, CREATE ROUTINE, CREATE TEMPORARY TABLES, LOCK TABLES, EVENT ON `jhcisdb`.* TO 'root'@'%';

GRANT GRANT OPTION ON `jhcisdb`.* TO 'root'@'%';

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