[...]

as 'drop table', 'create table', 'drop procedure', 'create procedure'
as well as others.
mysql> grant all privileges on test.* to 'builder'@'localhost' identified by 's3kr1t';
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        (User's choice) = -I/usr/include/mysql  -O2 -fwrapv -pipe -Wformat -Werror=format-security -Wp,-D_FORTIFY_SOURCE=2 -fstack-protector-strong --param=ssp-buffer-size=4 -Werror=trampolines -fomit-frame-pointer -march=i686 -fasynchronous-unwind-tables -mtune=pentium4  -Werror=implicit-function-declaration
  embedded      (guessed      ) = 
  ldflags       (guessed      ) = 
  libs          (mysql_config ) = -L/usr/lib -lmysqlclient -lzlib -lssl -lcrypto -lresolv -lm
  mysql_config  (guessed      ) = mysql_config
  nocatchstderr (default      ) = 0
  nofoundrows   (default      ) = 0
  nossl         (default      ) = 0
  testdb        (default      ) = test
  testhost      (default      ) = 
  testpassword  (default      ) = 
  testport      (default      ) = 
  testsocket    (default      ) = 
  testuser      (guessed      ) = builder
To change these settings, see 'perl Makefile.PL --help' and
'perldoc DBD::mysql::INSTALL'.
Checking if libs are available for compiling...
Can't link/include C library 'zlib', aborting.
error: Bad exit status from /tmp/B.8va9Hb/BUILD/tmp/rpm-tmp.tgpv3V (%build)
RPM build warnings:
    line 45: It's not recommended to have unversioned Obsoletes: Obsoletes:	perl-DBD-MySQL
    line 46: It's not recommended to have unversioned Obsoletes: Obsoletes:	perl-DBD-Mysql
    line 47: It's not recommended to have unversioned Obsoletes: Obsoletes:	perl-Msql-Mysql-modules
    Could not canonicalize hostname: tld-x86
RPM build errors:
    Bad exit status from /tmp/B.8va9Hb/BUILD/tmp/rpm-tmp.tgpv3V (%build)
ended at: Fri Mar 29 00:34:36 2024, done in 0:00:00.339956
error: No files produced.
+ chmod -R u+rwX /tmp/B.8va9Hb/BUILD
+ rm -rf /tmp/B.8va9Hb/tmp /tmp/B.8va9Hb/BUILD
+ rm -rf /tmp/B.8va9Hb
Begin-TLD-Builder-Info
Build-Time: user:0.42s sys:0.20s real:0.76s (faults io:1 non-io:68419)
End-TLD-Builder-Info