Tests use NO db passwd while build recommends a secret one

[ballapete]

DBD::mysql version

5.013

MySQL client version

8.4.8

Server version

?

Operating system version

macOS Sonoma 14.8.5/Darwin 23.6.0

What happened?

When building I get informed:

PLEASE NOTE:

For 'make test' to run properly, you must ensure that the
database user 'root' can connect to your MySQL server
and has the proper privileges that these tests require such
as 'drop table', 'create table', 'drop procedure', 'create procedure'
as well as others.

mysql> CREATE USER 'root'@'localhost' IDENTIFIED BY 's3kr1t';
mysql> GRANT ALL PRIVILEGES ON test.* TO 'root'@'localhost';

But then almost all tests fail with NO password:

--->  Testing p5.34-dbd-mysql
Use of uninitialized value $line in substitution (s///) at /opt/local/lib/perl5/5.34/Text/ParseWords.pm line 20.
I will use the following settings for compiling and testing:

  cflags        (mysql_config ) = -I/opt/local/include/mysql8/mysql
  ldflags       (mysql_config ) = 
  libs          (mysql_config ) = -L/opt/local/lib/mysql8/mysql -lmysqlclient -lz -lzstd -lssl -lcrypto -lresolv
  mysql_config  (Users choice ) = /opt/local/lib/mysql8/bin/mysql_config
  nocatchstderr (default      ) = 0
  nofoundrows   (default      ) = 0
  testdb        (User's choice) = test
  testhost      (default      ) = 
  testpassword  (default      ) = 
  testport      (default      ) = 
  testsocket    (default      ) = 
  testuser      (User's choice) = root
  version       (mysql_config ) = 8.4.8

To change these settings, see 'perl Makefile.PL --help' and
'perldoc DBD::mysql::INSTALL'.

Checking if libs are available for compiling...
Looks good.

Using DBI 1.647 (for perl 5.034003 on darwin-thread-multi-2level) installed in /opt/local/lib/perl5/vendor_perl/5.34/darwin-thread-multi-2level/auto/DBI/
Generating a Unix-style Makefile
Writing Makefile for DBD::mysql
Writing MYMETA.yml and MYMETA.json
Executing:  cd "/opt/local/var/macports/build/p5.34-dbd-mysql-4653e422/work/DBD-mysql-5.013" && /usr/bin/make test 
Running Mkbootstrap for mysql ()
chmod 644 "mysql.bs"
...
# Driver version is 5.013
t/00base.t .............................. ok
# DBI connect(';mysql_ssl=1;mysql_get_server_pubkey=1','root',...) failed: Access denied for user 'root'@'localhost' (using password: NO) at t/01caching_sha2_prime.t line 21.
t/01caching_sha2_prime.t ................ skipped: no database connection
# DBI connect('','root',...) failed: Access denied for user 'root'@'localhost' (using password: NO) at t/05dbcreate.t line 16.
t/05dbcreate.t .......................... skipped: no database connection
# DBI connect('test','root',...) failed: Access denied for user 'root'@'localhost' (using password: NO) at t/10connect.t line 14.
t/10connect.t ........................... skipped: no database connection
t/15reconnect.t ......................... skipped: no database connection
t/16dbi-get_info.t ...................... skipped: no database connection
t/17quote.t ............................. skipped: no database connection
t/20createdrop.t ........................ skipped: no database connection
t/25lockunlock.t ........................ skipped: no database connection
t/29warnings.t .......................... skipped: no database connection
t/30insertfetch.t ....................... skipped: no database connection
t/31insertid.t .......................... skipped: no database connection
t/32insert_error.t ...................... skipped: no database connection
t/35limit.t ............................. skipped: no database connection
t/35prepare.t ........................... skipped: no database connection
t/40bindparam.t ......................... skipped: no database connection
t/40bindparam2.t ........................ skipped: no database connection
t/40bit.t ............................... skipped: no database connection
t/40blobs.t ............................. skipped: no database connection
t/40catalog.t ........................... skipped: no database connection
t/40keyinfo.t ........................... skipped: no database connection
t/40listfields.t ........................ skipped: no database connection
t/40nulls.t ............................. skipped: no database connection
t/40nulls_prepare.t ..................... skipped: no database connection
t/40numrows.t ........................... skipped: no database connection
t/40server_prepare.t .................... skipped: no database connection
t/40server_prepare_crash.t .............. skipped: no database connection
t/40server_prepare_error.t .............. skipped: no database connection
t/40types.t ............................. skipped: no database connection
t/41bindparam.t ......................... skipped: no database connection
t/41blobs_prepare.t ..................... skipped: no database connection
t/41int_min_max.t ....................... skipped: no database connection
t/42bindparam.t ......................... skipped: no database connection
t/43count_params.t ...................... skipped: no database connection
t/50chopblanks.t ........................ skipped: no database connection
t/50commit.t ............................ skipped: no database connection
t/51bind_type_guessing.t ................ skipped: no database connection
t/52comment.t ........................... skipped: no database connection
t/53comment.t ........................... skipped: no database connection
t/55utf8.t .............................. skipped: no database connection
t/55utf8_errors.t ....................... skipped: no database connection
t/55utf8_identifiers.t .................. skipped: no database connection
t/55utf8mb4.t ........................... skipped: no database connection
t/56connattr.t .......................... skipped: no database connection
t/57trackgtid.t ......................... skipped: no database connection
t/60leaks.t ............................. skipped: Skip $ENV{EXTENDED_TESTING} is not set
t/65segfault.t .......................... skipped: no database connection
t/65types.t ............................. skipped: no database connection
t/70takeimp.t ........................... skipped: no database connection
t/71impdata.t ........................... skipped: no database connection
t/75supported_sql.t ..................... skipped: no database connection
t/76multi_statement.t ................... skipped: no database connection
t/80procs.t ............................. skipped: no database connection
t/81procs.t ............................. skipped: no database connection
t/85init_command.t ...................... skipped: no database connection
t/86_bug_36972.t ........................ skipped: no database connection
t/87async.t ............................. skipped: no database connection
t/88async-multi-stmts.t ................. skipped: no database connection
t/89async-method-check.t ................ skipped: no database connection
t/91errcheck.t .......................... skipped: no database connection
t/92ssl_backronym_vulnerability.t ....... skipped: no database connection: DBI connect('test','root',...) failed: Access denied for user 'root'@'localhost' (using password: NO) at t/lib.pl line 57.
t/92ssl_optional.t ...................... skipped: no database connection: DBI connect('test','root',...) failed: Access denied for user 'root'@'localhost' (using password: NO) at t/lib.pl line 57.
t/92ssl_riddle_vulnerability.t .......... skipped: no database connection: DBI connect('test','root',...) failed: Access denied for user 'root'@'localhost' (using password: NO) at t/lib.pl line 57.
t/99_bug_server_prepare_blob_null.t ..... skipped: no database connection
# DBI connect('test','root',...) failed: Access denied for user 'root'@'localhost' (using password: NO) at t/99compression.t line 11.
t/99compression.t ....................... skipped: no database connection
# DBI connect('test','root',...) failed: Access denied for user 'root'@'localhost' (using password: NO) at t/gh352.t line 12.
t/gh352.t ............................... skipped: no database connection
# DBI connect('test;mysql_enable_utf8mb4=1','root',...) failed: Access denied for user 'root'@'localhost' (using password: NO) at t/gh360.t line 15.
t/gh360.t ............................... skipped: no database connection
t/gh447-paramvalues.t ................... skipped: no database connection
t/manifest.t ............................ skipped: these tests are for release testing
t/pod.t ................................. ok
t/rt110983-valid-mysqlfd.t .............. skipped: no database connection
t/rt118977-zerofill.t ................... skipped: no database connection
t/rt25389-bin-case.t .................... skipped: no database connection
t/rt50304-column_info_parentheses.t ..... skipped: no database connection
t/rt61849-bind-param-buffer-overflow.t .. skipped: no database connection
t/rt75353-innodb-lock-timeout.t ......... skipped: no database connection
t/rt83494-quotes-comments.t ............. skipped: no database connection
t/rt85919-fetch-lost-connection.t ....... skipped: no database connection
t/rt86153-reconnect-fail-memory.t ....... skipped: $ENV{EXTENDED_TESTING} is not set
t/rt88006-bit-prepare.t ................. skipped: no database connection
t/rt91715.t ............................. skipped: no database connection
# mysql_get_client_version: 80408
t/version.t ............................. ok
All tests successful.
Files=82, Tests=12, 11 wallclock secs ( 0.17 usr  0.15 sys +  8.03 cusr  1.73 csys = 10.08 CPU)
Result: PASS

Do I have to pass extra parameters to Makefile.PL at build time (testsocket, testport, testpassword)?

The hint See DBD::mysql::INSTALL for details. from perl5.34 Makefile.PL --help could be misleading: MetaCPAN propagates version 4.055…

Other information

No response

[dveeden]

Yes, you probably should use something like perl Makefile.PL --testpassword=s3kr1t

$ perl Makefile.PL --help 2>&1 | grep -A1 testpassword
  --testpassword=<pwd>   Use the password <pwd> for running the test suite;
                         defaults to no password

If your database isn't a throw-away container and/or is available on the network (instead of only localhost) setting a (random) password is recommended.

[dveeden]

diff --git a/Makefile.PL b/Makefile.PL
index 3d70723..b3bd65f 100644
--- a/Makefile.PL
+++ b/Makefile.PL
@@ -497,6 +497,10 @@ as well as others.
 mysql> CREATE USER '$user'\@'localhost' IDENTIFIED BY 's3kr1t';
 mysql> GRANT ALL PRIVILEGES ON test.* TO '$user'\@'localhost';
 
+To set the password that the test should use supply it like this:
+
+perl Makefile.PL --testpassword='s3kr1t'
+
 You can also optionally set the user to run 'make test' with:
 
 perl Makefile.PL --testuser=username

Maybe something like this could clear this up?
But then it is also a best practice to not use the s3kr1t password, but to use a random password instead. And for a local container not using a password is fine and probably easier. Not sure how far this should go.

[ballapete]

I already have a little success…

I am using the MacPorts package manager that is controlled by recipes in a Portfile. This is a bit complicated since it also wants to support MariaDB and a few versions of MySQL. Possibly before any "regular" test can be performed it has a pre-test statement:
perl Makefile.PL --testuser=root
Adding --testpassword=s3kr1t to this statement lets DBD::mysql access the running MySQL db. I am thinking of diving a bit deeper into this in order to understand what this pre-test is actually doing…

Outside MacPorts, which db user id would be used to access the db for testing? Maybe it's better when MacPorts would use that one…

[ballapete]

Yes, the proposed patch would help to understand…

OTOH installing MySQL with MacPorts gives a help to set up a first db:

    If this is a new install you might want to run:
    
    $ sudo /opt/local/lib/mysql8/bin/mysqld --initialize --user=_mysql
    $ sudo port load mysql8-server
    $ /opt/local/lib/mysql8/bin/mysql_secure_installation
    
    The first command creates the necessary files for the MySQL database service.
    (Remember to make a note of the auto-generated root password from this step.)
    The second command starts the MySQL service.
    The last command helps to improve the security of your running MySQL instance.
    
    Once enabled, the MySQL logs can be found in: 
    /opt/local/var/log/mysql8

mysql_secure_installation allows to change root's password, so maybe it should be expressed to use for testing that supplied password, or to express that for testing an extra argument has to be used that passes the password to Perl and the test routines, that testing with DBD::mysql is not 100 % automatic.

[dveeden]

Could be good go add a MacPorts section to https://metacpan.org/dist/DBD-mysql/view/lib/DBD/mysql/INSTALL.pod and/or update things on the MacPorts side.

Note that mysqld --initialize does set a random root password. There is also mysqld --initialize-insecure which doesn't.

When using a container there are container specific options for setting a password.

Note also that MySQL 8.0 is EOL, best to use MySQL 8.4 or 9.7.

[ballapete]

MacPorts supports many old versions of MySQL. Reason can be that these build on elder Macs.

MySQL 9 is not yet supported. The support for MySQL 8 is for version 8.4.8.

Until now MacPorts does not seem to use containers – it only provides the software.

I could try to give you a MacPorts specific addition for https://metacpan.org/dist/DBD-mysql/view/lib/DBD/mysql/INSTALL.pod – after things have been finally cleared.

The MacPorts Portfile for DBD::mysql also supports MariaDB and PerconaDB although a Portfile for MariaDB exists. The DBD::mysql Portfile has the disadvantage that the whole module is rebuilt when testing starts. It also provides some support for the "official" version of DBD::mysql as provided by MetaCPAN, 4.055. Why is MetaCPAN advertising this one? Is version 5.013 a development one?

I have an idea why MacPorts is rebuilding the module before testing and am going to check whether it holds…

[dveeden]

DBD::mysql v5.x supports MySQL 8.x and 9.x only (including Percona, VillageSQL, etc)

DBD::mysql v4.x supports MySQL (4.x, 5.x, ...), MariaDB. This is under maintenance, so no new features.

Note that there is DBD::MariaDB as well, but this isn't a drop-in replacement due to historical issues around UTF-8.

[ballapete]

In the original setup of DBD::mysql the system is asked to perform:

1. cd "/opt/local/var/macports/build/p5.34-dbd-mysql-4653e422/work/DBD-mysql-5.013" && /opt/local/bin/perl5.34 Makefile.PL INSTALLDIRS=vendor CC="/usr/bin/clang" LD="/usr/bin/clang" --mysql_config=/opt/local/lib/mysql8/bin/mysql_config
2. cd /opt/local/var/macports/build/p5.34-dbd-mysql-4653e422/work/DBD-mysql-5.013 && perl Makefile.PL --testuser=root

The latter creates a new Makefile which makes MacPorts, or make, think that the software has to be rebuilt. Same when perl Makefile.PL --testuser=root --testpassword=s3kr1t is used to test successfully. So let's try:

1. cd "/opt/local/var/macports/build/p5.34-dbd-mysql-4653e422/work/DBD-mysql-5.013" && /opt/local/bin/perl5.34 Makefile.PL INSTALLDIRS=vendor CC="/usr/bin/clang" LD="/usr/bin/clang" --mysql_config=/opt/local/lib/mysql8/bin/mysql_config --testuser=root --testpassword=s3kr1t
2. cd /opt/local/var/macports/build/p5.34-dbd-mysql-4653e422/work/DBD-mysql-5.013 && perl Makefile.PL --testuser=root --testpassword=s3kr1t

Again a new Makefile is created due to using pre-test – would it work as wished with a test.cmd make test?

1. cd "/opt/local/var/macports/build/p5.34-dbd-mysql-4653e422/work/DBD-mysql-5.013" && /opt/local/bin/perl5.34 Makefile.PL INSTALLDIRS=vendor CC="/usr/bin/clang" LD="/usr/bin/clang" --mysql_config=/opt/local/lib/mysql8/bin/mysql_config --testuser=root --testpassword=s3kr1t
2. cd "/opt/local/var/macports/build/p5.34-dbd-mysql-4653e422/work/DBD-mysql-5.013" && make test

This should be the solution – but neither testuser's nor testpassword's values are saved in Makefile or in some other file and DBD:mysql tries to test with:

# DBI connect(';mysql_ssl=1;mysql_get_server_pubkey=1','_mysql',...) failed: Access denied for user '_mysql'@'localhost' (using password: YES) at t/01caching_sha2_prime.t line 21.

How can this catch-22 situation be resolved? Extend Makefile.PL to save some test values in Makefile which in turn uses them for testing?

You are never testing with a testuser and its testpassword?

[ballapete]

I tried an "insecure" setup:

root 409 /\ mysqld --initialize-insecure --user=_mysql
2026-04-28T16:02:23.478926Z 0 [System] [MY-015017] [Server] MySQL Server Initialization - start.
2026-04-28T16:02:23.484640Z 0 [System] [MY-013169] [Server] /opt/local/lib/mysql8/bin/mysqld (mysqld 8.4.8) initializing of server in progress as process 40872
2026-04-28T16:02:23.511354Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2026-04-28T16:02:23.706089Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2026-04-28T16:02:24.643820Z 6 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
2026-04-28T16:02:25.634533Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.4.8).
2026-04-28T16:02:25.903168Z 0 [System] [MY-015018] [Server] MySQL Server Initialization - end.
root 410 /\ port load mysql8-server
--->  Loading startupitem 'mysql8-server' for mysql8-server
root 411 /\ top -l 1 | grep mysql
40899  mysqld           0.0  00:02.24 38     0    54     498M  0B    0B    40899 1     sleeping *0[1]        0.00000 0.00000    74  134692    987     518        252        187157     729        33904      40      15533     0.0   0      0      40     _mysql             N/A    N/A   N/A   N/A   N/A   N/A  

And DBD::mysql tried to test with:

# Driver version is 5.013
t/00base.t .............................. ok
# DBI connect(';mysql_ssl=1;mysql_get_server_pubkey=1','_mysql',...) failed: Access denied for user '_mysql'@'localhost' (using password: NO) at t/01caching_sha2_prime.t line 21.
t/01caching_sha2_prime.t ................ skipped: no database connection

Although previously it was recommended:

PLEASE NOTE:

For 'make test' to run properly, you must ensure that the
database user 'root' can connect to your MySQL server
and has the proper privileges that these tests require such
as 'drop table', 'create table', 'drop procedure', 'create procedure'
as well as others.

mysql> CREATE USER 'root'@'localhost' IDENTIFIED BY 's3kr1t';
mysql> GRANT ALL PRIVILEGES ON test.* TO 'root'@'localhost';

You can also optionally set the user to run 'make test' with:

perl Makefile.PL --testuser=username

I will use the following settings for compiling and testing:

  cflags        (mysql_config) = -I/opt/local/include/mysql8/mysql
  ldflags       (mysql_config) = 
  libs          (mysql_config) = -L/opt/local/lib/mysql8/mysql -lmysqlclient -lz -lzstd -lssl -lcrypto -lresolv
  mysql_config  (Users choice) = /opt/local/lib/mysql8/bin/mysql_config
  nocatchstderr (default     ) = 0
  nofoundrows   (default     ) = 0
  testdb        (default     ) = test
  testhost      (default     ) = 
  testpassword  (default     ) = 
  testport      (default     ) = 
  testsocket    (default     ) = 
  testuser      (guessed     ) = root
  version       (mysql_config) = 8.4.8

So the tests would be run with a different user ID, '_mysql'@'localhost', not the recommended one.

[ballapete]

Forgot to mention: the tests fail initially:

# Driver version is 5.013
t/00base.t .............................. ok
# DBI connect(';mysql_ssl=1;mysql_get_server_pubkey=1','_mysql',...) failed: Access denied for user '_mysql'@'localhost' (using password: NO) at t/01caching_sha2_prime.t line 21.
t/01caching_sha2_prime.t ................ skipped: no database connection
# DBI connect('','_mysql',...) failed: Access denied for user '_mysql'@'localhost' (using password: NO) at t/05dbcreate.t line 16.
t/05dbcreate.t .......................... skipped: no database connection
# DBI connect('test','_mysql',...) failed: Access denied for user '_mysql'@'localhost' (using password: NO) at t/10connect.t line 14.

Besides the root user cannot perform anything in the db, for example:

pete 280 /\ mysql -u root -p -P 3306
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 85
Server version: 8.4.8 Source distribution

Copyright (c) 2000, 2026, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> CREATE USER 'root'@'localhost' IDENTIFIED BY 's3kr1t';
ERROR 1396 (HY000): Operation CREATE USER failed for 'root'@'localhost'
�mysql>

The db's log file contains (using UTC instead of the legal local time):

2026-04-28T16:33:25.164916Z 0 [System] [MY-015015] [Server] MySQL Server - start.
2026-04-28T16:33:25.445728Z 0 [System] [MY-010116] [Server] /opt/local/lib/mysql8/bin/mysqld (mysqld 8.4.8) starting as process 43286
2026-04-28T16:33:25.455592Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2026-04-28T16:33:25.671562Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2026-04-28T16:33:25.942936Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2026-04-28T16:33:25.943001Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2026-04-28T16:33:25.965506Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: /opt/local/var/run/mysql8/mysqlx.sock
2026-04-28T16:33:25.965550Z 0 [System] [MY-010931] [Server] /opt/local/lib/mysql8/bin/mysqld: ready for connections. Version: '8.4.8'  socket: '/opt/local/var/run/mysql8/mysqld.sock'  port: 0  Source distribution.
2026-04-28T16:36:04.822254Z 9 [Warning] [MY-013360] [Server] Plugin sha256_password reported: ''sha256_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'

(The last line repeated almost endlessly.)

[ballapete]

I read some MySQL documentation and understand now a few more things. _mysql is the UNIX user account which will own the MySQL db, and it must be root that is performing the tests.

It works to

sudo mysqld --initialize-insecure --user=_mysql  –– create a setup for an insecure MySQL db
sudo port load mysql8-server                     –– start that db instance
mysql -u root -P 3306                            –– login to db instance
GRANT ALL PRIVILEGES ON test.* TO 'root'@'localhost'; –– make db user root@localhost to "super user"
^D                                               –– quit from db instance

The root user seems to already exist and can be used without change. Trying to CREATE it (again) without password is not allowed. With this setup tests succeed like this:

# Driver version is 5.013
t/00base.t .............................. ok
t/01caching_sha2_prime.t ................ ok
# Database 'test' accessible
t/05dbcreate.t .......................... ok
# mysql_clientinfo is: 8.4.8
# mysql_clientversion is: 80408
# mysql_serverversion is: 80408
# mysql_hostinfo is: Localhost via UNIX socket
# mysql_serverinfo is: 8.4.8
# mysql_stat is: Uptime: 542  Threads: 2  Questions: 17  Slow queries: 0  Opens: 141  Flush tables: 3  Open tables: 58  Queries per second avg: 0.031
# mysql_protoinfo is: 10
# SQL_DBMS_VER is 8.4.8
# Default storage engine is: InnoDB
t/10connect.t ........................... ok
t/15reconnect.t ......................... ok
t/16dbi-get_info.t ...................... ok
t/17quote.t ............................. ok
t/20createdrop.t ........................ ok
t/25lockunlock.t ........................ ok
t/29warnings.t .......................... ok
t/30insertfetch.t ....................... ok
t/31insertid.t .......................... ok
t/32insert_error.t ...................... ok
t/35limit.t ............................. ok
t/35prepare.t ........................... ok
t/40bindparam.t ......................... ok
t/40bindparam2.t ........................ ok
t/40bit.t ............................... ok
t/40blobs.t ............................. ok
t/40catalog.t ........................... ok
t/40keyinfo.t ........................... ok
t/40listfields.t ........................ ok
t/40nulls.t ............................. ok
t/40nulls_prepare.t ..................... ok
t/40numrows.t ........................... ok
t/40server_prepare.t .................... ok
t/40server_prepare_crash.t .............. ok
t/40server_prepare_error.t .............. ok
t/40types.t ............................. ok
t/41bindparam.t ......................... ok
t/41blobs_prepare.t ..................... ok
t/41int_min_max.t ....................... ok
t/42bindparam.t ......................... ok
t/43count_params.t ...................... ok
t/50chopblanks.t ........................ ok
t/50commit.t ............................ ok
DBD::mysql::st execute failed: Data truncated for column 'dd' at row 1 at t/51bind_type_guessing.t line 149.
DBD::mysql::st execute failed: Data truncated for column 'nn' at row 1 at t/51bind_type_guessing.t line 127.
DBD::mysql::st execute failed: Data truncated for column 'dd' at row 1 at t/51bind_type_guessing.t line 149.
DBD::mysql::st execute failed: Incorrect integer value: '+' for column 'nn' at row 1 at t/51bind_type_guessing.t line 127.
DBD::mysql::st execute failed: Data truncated for column 'dd' at row 1 at t/51bind_type_guessing.t line 149.
DBD::mysql::st execute failed: Incorrect integer value: '.' for column 'nn' at row 1 at t/51bind_type_guessing.t line 127.
DBD::mysql::st execute failed: Data truncated for column 'dd' at row 1 at t/51bind_type_guessing.t line 149.
DBD::mysql::st execute failed: Incorrect integer value: 'e5' for column 'nn' at row 1 at t/51bind_type_guessing.t line 127.
DBD::mysql::st execute failed: Data truncated for column 'dd' at row 1 at t/51bind_type_guessing.t line 149.
t/51bind_type_guessing.t ................ ok
t/52comment.t ........................... ok
t/53comment.t ........................... ok
t/55utf8.t .............................. ok
# Disabled mysql_enable_utf8.
# Enabled mysql_enable_utf8.
# Enabled mysql_enable_utf8mb4.
t/55utf8_errors.t ....................... ok
# Disabled mysql_enable_utf8.
# Enabled mysql_enable_utf8.
# Enabled mysql_enable_utf8mb4.
t/55utf8_identifiers.t .................. ok
t/55utf8mb4.t ........................... ok
t/56connattr.t .......................... ok
t/57trackgtid.t ......................... skipped: GTID tracking not enabled
t/60leaks.t ............................. skipped: Skip $ENV{EXTENDED_TESTING} is not set
t/65segfault.t .......................... ok
t/65types.t ............................. ok
t/70takeimp.t ........................... ok
t/71impdata.t ........................... ok
t/75supported_sql.t ..................... ok
t/76multi_statement.t ................... ok
t/80procs.t ............................. ok
t/81procs.t ............................. ok
t/85init_command.t ...................... ok
t/86_bug_36972.t ........................ ok
t/87async.t ............................. ok
t/88async-multi-stmts.t ................. ok
t/89async-method-check.t ................ ok
t/91errcheck.t .......................... ok
t/92ssl_backronym_vulnerability.t ....... skipped: Server might support SSL connections, cannot test false-positive enforcement
t/92ssl_optional.t ...................... skipped: Server might support SSL connections, cannot test false-positive enforcement
t/92ssl_riddle_vulnerability.t .......... skipped: Server might support SSL connections, cannot test false-positive enforcement
t/99_bug_server_prepare_blob_null.t ..... ok
t/99compression.t ....................... ok
DBD::mysql::db prepare failed: Statement not active at t/gh352.t line 27.
t/gh352.t ............................... ok
t/gh360.t ............................... ok
t/gh447-paramvalues.t ................... ok
t/manifest.t ............................ skipped: these tests are for release testing
t/pod.t ................................. ok
t/rt110983-valid-mysqlfd.t .............. ok
t/rt118977-zerofill.t ................... ok
t/rt25389-bin-case.t .................... ok
t/rt50304-column_info_parentheses.t ..... ok
t/rt61849-bind-param-buffer-overflow.t .. ok
t/rt75353-innodb-lock-timeout.t ......... ok
t/rt83494-quotes-comments.t ............. ok
t/rt85919-fetch-lost-connection.t ....... ok
t/rt86153-reconnect-fail-memory.t ....... skipped: $ENV{EXTENDED_TESTING} is not set
t/rt88006-bit-prepare.t ................. ok
t/rt91715.t ............................. ok
# mysql_get_client_version: 80408
t/version.t ............................. ok
All tests successful.
Files=82, Tests=2575, 44 wallclock secs ( 0.39 usr  0.19 sys +  8.05 cusr  1.77 csys = 10.40 CPU)
Result: PASS

And I found the cause why MacPorts built the module a second time for testing:

134     post-build {
135         reinplace -locale C "s|root|_mysql|" ${worksrcpath}/t/mysql.mtest
136     }

With this statement sed changes the first occurrence of the string "root" on any line in t/mysql.mtest to "_mysql". Possibly a misinterpretation as mine from failed testing. Therefore perl Makefile.PL has to be invoked again, now with arguments, resetting all that was achieved until now.

For safety reasons? Expecting an answer from the MacPorts folks…

[ballapete]

Stopping the MySQL db goes with
sudo launchctl bootout system/org.macports.mysql8-server
and removing quite all ≈200 MB data files works with
sudo rm -rf /opt/local/var/db/mysql8/*