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 just localhost, this will override the setting bind-address = 127.0.0.1
[mysqld] bind-address = 0.0.0.0
You may also need to allow TCP port 3306 for incoming connections in your firewall for MySql.