zeloc

SET @email='testspace@test.com', @passwd='Test@123456', @salt=MD5(RAND());

UPDATE customer_entity
    SET password_hash = CONCAT(SHA2(CONCAT(@salt, @passwd), 256), ':', @salt, ':1')
    WHERE email = @email;

zeloc

//Download From the server to your local
scp -P 2020 coxandcox@78.137.125.4:/home/coxandcox/stg.temp.db.sql.gz /Users/doug/Downloads/

//Upload From your machine to the server
scp -P 2020  /Users/doug/Downloads/rugs-buying-guide.pdf coxandcox@78.137.125.1:/home/coxandcox/production/pub/media/

zeloc

# Taking a mysqldump with single transation:

# standard
mysqldump --single-transaction -u root -proot bettys_local > bak_060618.sql.gz

# with host
mysqldump --single-transaction -h 127.0.0.1 -u root -proot bettys_local > bak_060618_1.sql.gz

# with gz and host
mysqldump --single-transaction -h 127.0.0.1 -u root -proot bettys_local | gzip > bak_060618_11.sql.gz

zeloc

select  `order`.`increment_id` as `Sales Order`, DATE(`note`.`created_at`) as `Date`, TIME(`note`.`created_at`) as `Time`, `note`.`comment` as `Note`  
FROM `sales_order` AS `order`
JOIN `sales_order_status_history` as `note`
ON `note`.`parent_id` = `order`.`entity_id`;

zeloc

### default for all ##
Host *
     ForwardAgent no
     ForwardX11 no
     ForwardX11Trusted yes
     User nixcraft
     Port 22
     Protocol 2
     ServerAliveInterval 60
     ServerAliveCountMax 30

zeloc

// Use Gists to store code you would like to remember later on
console.log(window); // log the "window" object to the console