baiano

baiano / createWordpressMySqlUser

Last active August 25, 2022 02:43

Create user with permissions for a new wordpress site.

	CREATE USER 'newUser'@'localhost' IDENTIFIED BY 'aBigPasswordForMyDatabaseAccess';
	GRANT SELECT, INSERT, CREATE, UPDATE, DELETE, ALTER, DROP, INDEX ON databaseName.* TO 'newUser'@'localhost';

baiano / increaseWoocommerceProductsPricesByPercentage.sql

Created August 5, 2022 00:15

Increase price of products woocommerce

	-- 10%
	UPDATE wp_postmeta
	SET meta_value = ROUND(meta_value * 1.10, 2)
	WHERE meta_key = '_price';

	UPDATE wp_postmeta
	SET meta_value = ROUND(meta_value * 1.10, 2)
	WHERE meta_key = '_regular_price';

	UPDATE wp_postmeta

baiano / gist:5240323

Created March 25, 2013 20:17

Line 54, replace "$di" for "$dir"