Skip to content

Fails to create root user if password policy plugin is used #283

@bjoernv

Description

@bjoernv

The container creating fails, if a password policy plugin like simple_password_check is configured. This only happens, if the database directory is empty or the root does not exists.

This is the log:

[...]
---> 09:19:33     MySQL started successfully
This installation of MariaDB is already upgraded to 10.11.10-MariaDB.
There is no need to run mysql_upgrade again for 10.11.10-MariaDB.
You can use --force if you still want to run mysql_upgrade
---> 09:19:33     Setting password for MySQL root user ...
--------------
CREATE USER IF NOT EXISTS 'root'@'%'
--------------

ERROR 1819 (HY000) at line 1: Your password does not satisfy the current policy requirements (simple_password_check)

For testing you can use this my.cnf:

[mysqld]

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links = 0

# http://www.percona.com/blog/2008/05/31/dns-achilles-heel-mysql-installation/
skip_name_resolve

# http://www.chriscalender.com/ignoring-the-lostfound-directory-in-your-datadir/
ignore-db-dirs=lost+found

# GlusterFS equivalent of 'lost+found'
ignore-db-dirs=.trashcan

# NetApp snapshot dir
ignore-db-dirs=.snapshot

!includedir /etc/my.cnf.d

[mariadb]
plugin_dir = /usr/lib64/mariadb/plugin
plugin_load_add = simple_password_check

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions