Tag: MySQL

 FIX ERROR – MySQL: Your password does not satisfy the current policy requirements

When trying to set a password for the mysql user, the following error occurs:   This error appears if your password does not meet the following requirements, for "validate_password.policy" in "MEDIUM" mode it is: Minimum length 8 characters At least one digit At least one uppercase letter At least one special character   Solution: 1. … Continue reading " FIX ERROR – MySQL: Your password does not satisfy the current policy requirements"

 MySQL – Reset root password

We stop the mysqld service and start it with the following keys:   Log in without a password:   And run:   Now the mysqld service running in the background needs to be stopped. We look at the process ID:   Kill the process:   And start the mysqld service:

BASH – backup sites and MySQL databases on AWS S3

The script finds all folders in a given directory and archives them one by one, copies them to S3 Bucket and deletes them locally. It also receives a list of all MySQL databases, excluding system databases, archives them in turn, sends them to S3 Bucket and deletes them locally.