it now shows
Warning: MariaDB version [‘10.11’, ‘2’] is more than 10.8 which is not yet tested with Frappe Framework.
For key character_set_server. Expected value utf8mb4, found value latin1
For key collation_server. Expected value utf8mb4_unicode_ci, found value latin1_swedish_ci
Creation of your site - library.test failed because MariaDB is not properly
configured.
Please verify the above settings in MariaDB’s my.cnf. Restart MariaDB.
And then run bench new-site library.test again.
Database settings do not match expected values; stopping database setup.
this error