Run the following MySql query to generate the new download limit of 100 for all Woocommerce products in WordPress. UPDATE wp_postmeta SET meta_value = “100” WHERE meta_key = “_download_limit”
Tag: MySql
Allow remote access to MYSQL database
To allow remote access to MySql first create a MySql user and assign host as %. CREATE USER ‘newuser’@’%’ IDENTIFIED BY ‘password’; then grant privileges GRANT ALL PRIVILEGES ON * . * TO ‘newuser’@’%’; then flush privileges FLUSH PRIVILEGES; You may need to add the following to /etc/mysql/my.cnf to listen for all ip’s instead of […]