问题主要发生在连接数据库时。 问题：MySQL数据库更改密码显示 error: 'Your password does not satisfy the current policy requirements'
解决方法： select @@validate_password_policy; SHOW VARIABLES LIKE 'validate_password%';
validate_password_dictionary_file 插件用于验证密码强度的字典文件路径。
validate_password_length 密码最小长度，参数默认为8，它有最小值的限制，最小值为：validate_password_number_count + validate_password_special_char_count + (2 * validate_password_mixed_case_count)
validate_password_mixed_case_count 密码至少要包含的小写字母个数和大写字母个数。
validate_password_number_count 密码至少要包含的数字个数。
validate_password_policy 密码强度检查等级，0/LOW、1/MEDIUM、2/STRONG。有以下取值： Policy Tests Performed 0 or LOW Length 1 or MEDIUM Length; numeric, lowercase/uppercase, and special characters 2 or STRONG Length; numeric, lowercase/uppercase, and special characters; dictionary file 默认是1，即MEDIUM，所以刚开始设置的密码必须符合长度，且必须含有数字，小写或大写字母，特殊字符。
validate_password_special_char_count 密码至少要包含的特殊字符数。
set global validate_password_mixed_case_count=0; SET password for 'root'@'localhost'=password('newpassword');
问题：Your database must use 'READ-COMMITTED' as the default isolation level 解决方法： cat /etc/my.cnf | grep -v "^#" | grep -v "^$" [mysqld] init_connect='SET collation_connection = utf8_unicode_ci' init_connect='SET NAMES utf8' character-set-server=utf8 collation-server=utf8_unicode_ci skip-character-set-client-handshake transaction_isolation = READ-COMMITTED datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock symbolic-links=0 log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid
问题：Collation error The database collation 'utf8_general_ci' is not supported by Confluence. You need to use 'utf8_bin'. 解决方法： create database confluence character set utf8 collate utf8_bin; grant all on confluence.* to 'confluenceuser'@'%' identified by 'password' with grant option; grant all on confluence.* to 'confluenceuser'@localhost identified by 'password' with grant option; flush privileges;
数据库测试： mysql -u confluenceuser -h localhost -p
