C.0 Using MySQL 8 and Later with Vibe

MySQL 8 and later has password complexity enabled by default, which Vibe doesn’t support.

The sections that follow replace Step 7 in Configuring MySQL/MariaDB and provide basic help for disabling password complexity and setting a non-complex password.

For complete MySQL information, including download and installation instructions, see the MySQL web site.

Disabling Password Complexity in MySQL 8

On the server running MySQL 8, do the following:

  1. Access a terminal prompt as the root user and enter the commands in the following steps.

  2. View the temporary MySQL root password that the installation process set in the mysqld.log file, by entering the following command:

    grep 'temporary password' /var/log/mysql/mysqld.log

  3. Log in to MySQL.

    mysql -uroot -p temporary-password

    where temporary-password is the password obtained in Step 2.

  4. Change the system-generated temporary password to another password that satisfies the password-complexity requirements, such as MyNewPass4!.

    ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';

  5. Remove the password-complexity requirement.

    UNINSTALL COMPONENT 'file://component_validate_password';

  6. Change the password to a non-complex password.

    ALTER USER 'root'@'localhost' IDENTIFIED BY 'new-password';

  7. Change the MySQL Native Password as well.

    ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'new-password';

Adding Access to a Separate MySQL 8 Database

If your MySQL 8 database is on a separate server from Vibe, you must also do the following:

  1. Add access to the Database using the following commands:

    CREATE USER 'root'@'%' IDENTIFIED BY 'new-password';

    GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;

    ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'new-password';

Where to Go from Here

When you complete the application instructions in this section, continue with Learning More about MySQL/MariaDB.