Unable to Create Database in SiteWorx After Replacing MariaDB with MySQL 8
==========================================================================

.. contents::

How the Issue Manifests
-----------------------

- After replacing the default MariaDB instance with MySQL 8, attempting to create a database in SiteWorx fails with 
  the following error:

  .. image:: /images/sw-password-error-mysql8.png
     :alt: mysql database password error 

Cause of the Issue
------------------

- The most common cause of this issue is that the password requirements set in MySQL 8 include a special character, 
  which the automated passwords generated by InterWorx do not include
- The custom password provided does not meet the requirements set in MySQL 8

How to Resolve
--------------

#. Log in to the server at the CLI as root, either via SSH or from the terminal
#. Log into the server MariaDB/MySQL instance as the mysql root user with either of the following:
   
   .. code-block::

      mysql 
   
   or

   .. code-block::

      mysql -u root -p
  
#. Check the settings for password requirements with the following: 

   .. code-block::

      SHOW VARIABLES LIKE 'validate_password%';

   If there are password variables set, the output will be similar to the following example:

   .. code-block::

      mysql> SHOW VARIABLES LIKE 'validate_password%';
      +-------------------------------------------------+--------+
      | Variable_name                                   | Value  |
      +-------------------------------------------------+--------+
      | validate_password.changed_characters_percentage | 0      |
      | validate_password.check_user_name               | ON     |
      | validate_password.dictionary_file               |        |
      | validate_password.length                        | 8      |
      | validate_password.mixed_case_count              | 1      |
      | validate_password.number_count                  | 1      |
      | validate_password.policy                        | MEDIUM |
      | validate_password.special_char_count            | 1      |
      +-------------------------------------------------+--------+
      8 rows in set (0.01 sec)

      mysql>

#. Update the corresponding password validation variable, replacing {variable} and {setting} with the corresponding 
   information:

   .. code-block::

      SET GLOBAL validate_password.{variable} = {setting};

   For example, to make it so that so special characters are no longer required as part of the password, use
   the following command:

   .. code-block::
    
      mysql> SET GLOBAL validate_password.special_char_count = 0;
      Query OK, 0 rows affected (0.01 sec)

      mysql> SHOW VARIABLES LIKE 'validate_password%';
      +-------------------------------------------------+--------+
      | Variable_name                                   | Value  |
      +-------------------------------------------------+--------+
      | validate_password.changed_characters_percentage | 0      |
      | validate_password.check_user_name               | ON     |
      | validate_password.dictionary_file               |        |
      | validate_password.length                        | 8      |
      | validate_password.mixed_case_count              | 1      |
      | validate_password.number_count                  | 1      |
      | validate_password.policy                        | MEDIUM |
      | validate_password.special_char_count            | 0      |
      +-------------------------------------------------+--------+
      8 rows in set (0.01 sec)

#. Exit MySQL 

   .. code-block::

      exit

If the above does not resolve the issue, please `submit a ticket <https://appendix.interworx.com/current/nodeworx/general/support/interworx-support-information.html#how-to-submit-a-support-ticket>`__
to `support.interworx.com <https://support.interworx.com>`__ for further assistance.