Configure mysql 8.4 with "mysql_native_password"

[RPotkowaVegasystems]

I need to use the "mysql_native_password", how can i configure ddev to use it?

[stasadev]

Hi @RPotkowaVegasystems,

DDEV projects using PHP 5.6-7.3 with MySQL 8.0 and 8.4 default to mysql_native_password.
DDEV projects using PHP 7.4+ with MySQL 8.0 or 8.4 default to caching_sha2_password.

To enforce mysql_native_password for all PHP versions, create .ddev/config.mysql.yaml:

hooks:
  post-start:
    - exec: mysql -e "ALTER USER 'db'@'%' IDENTIFIED WITH mysql_native_password BY 'db';"
      service: db
    - exec: mysql -e "ALTER USER 'db'@'localhost' IDENTIFIED WITH mysql_native_password BY 'db';"
      service: db
    - exec: mysql -e "ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'root';"
      service: db
    - exec: mysql -e "ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';"
      service: db

Run ddev restart and verify with:

$ ddev mysql -e 'SELECT user, host, plugin FROM mysql.user;'
+------------------+-----------+-----------------------+
| user             | host      | plugin                |
+------------------+-----------+-----------------------+
| db               | %         | mysql_native_password |
| root             | %         | mysql_native_password |
| db               | localhost | mysql_native_password |
| mysql.infoschema | localhost | caching_sha2_password |
| mysql.session    | localhost | caching_sha2_password |
| mysql.sys        | localhost | caching_sha2_password |
| root             | localhost | mysql_native_password |
+------------------+-----------+-----------------------+

Note: mysql_native_password will be removed in MySQL 9.0.

[stasadev]

If you're using PHP 5.6-7.3, it should work without any changes.

Just ensure you're running the latest stable DDEV version (v1.24.6 as of now).

Use ddev_version_constraint in your project configuration to enforce version compatibility.

[RPotkowaVegasystems]

I have the current version 1.24.6. but i cant get it to run with php 7.0. When i switch to 7.2 it works.

[stasadev]

I can reproduce the error:

ddev config --php-version=7.0 --database=mysql:8.4

<?php
$mysqli = new mysqli("db","db","db","db");

if ($mysqli->connect_errno) {
    echo "Failed to connect to MySQL: " . $mysqli->connect_error;
    exit();
}

$ ddev launch

Warning: mysqli::__construct(): The server requested authentication method unknown to the client [caching_sha2_password] in /var/www/html/index.php on line 2

[stasadev]

Not sure what's going on with PHP 7.0 and MySQL 8.4 - it's a rare combo.

Good to hear it's working for you with PHP 7.2.

[rfay]

@RPotkowaVegasystems it's really unusual that you'd want to use the latest MySQL 8.4 with a PHP version which was EOL 10 years before 8.4 even came out. Could you say a bit about why you'd do that? DDEV supports MariaDB and MySQL versions that were available when PHP was young...