verona$ sudo cp  /usr/pkg/share/examples/rc.d/mysqld /etc/rc.d

verona$ sudo /etc/rc.d/mysqld onestart
Initializing MySQL database system tables.
2021-02-22T12:28:45.462202Z 0 [Warning] Changed limits: max_open_files: 3404 (requested 5000)
2021-02-22T12:28:45.463521Z 0 [Warning] Changed limits: table_open_cache: 1621 (requested 2000)
2021-02-22T12:28:45.465766Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. 
   Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2021-02-22T12:28:45.490278Z 0 [ERROR] Failed to create event (errno= 22).
2021-02-22T12:28:45.490315Z 0 [ERROR] Failed to start timer notify thread.
2021-02-22T12:28:45.490328Z 0 [ERROR] Failed to initialize timer component (errno 22).
2021-02-22T12:28:46.930297Z 0 [Warning] InnoDB: New log files created, LSN=45790
2021-02-22T12:28:47.166900Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2021-02-22T12:28:47.557911Z 0 [Warning] No existing UUID has been found, so we assume that 
   this is the first time that this server has been started. 
   Generating a new UUID: 82dc89b0-7509-11eb-a463-36709083ddcc.
2021-02-22T12:28:47.561035Z 0 [Warning] Gtid table is not ready to be used. 
  Table 'mysql.gtid_executed' cannot be opened.
2021-02-22T12:28:48.923248Z 0 [Warning] CA certificate ca.pem is self signed.
2021-02-22T12:28:49.295404Z 1 [Note] A temporary password is generated for root@localhost: vByqEo:BA0I_
Starting mysqld.

verona$ pkg_info -D mysql-server

Information for mysql-server-5.7.33:

Install notice:
===========================================================================
$NetBSD: MESSAGE,v 1.1 2016/09/16 06:49:12 adam Exp $

After the tables are set up and the MySQL server is running,
please remember to set a password for the MySQL root user!
This is done by running both:

  /usr/pkg/bin/mysqladmin -u root -p password 'new-password'
  /usr/pkg/bin/mysqladmin -h `hostname` -u root -p password 'new-password'

The "Enter password:" prompt is asking for the existing password.
As there is no existing password, just press the Return key.

There is a script distributed with MySQL that can help you lock down
an installation.  This script has been installed to

  /usr/pkg/bin/mysql_secure_installation.

Please see the manual and the MySQL web site for more instructions.

===========================================================================

I don't figure out what 'both' means:

verona$  /usr/pkg/bin/mysqladmin -u root -p password 'new-password'
Enter password: 
mysqladmin: [Warning] Using a password on the command line interface can be insecure.
Warning: Since password will be sent to server in plain text, use ssl connection to ensure password safety.
verona$ 

above will set the password literaly to new-password.

and I understand 'both' means one of both is OK. One of each can be used.

mysql> SELECT user, host FROM mysql.user;
+---------------+-----------+
| user          | host      |
+---------------+-----------+
| mysql.session | localhost |
| mysql.sys     | localhost |
| root          | localhost |
+---------------+-----------+
3 rows in set (0.00 sec)

mysql> 

mysql> create user 'www'@'localhost'  identified by 'real_password_here';
Query OK, 0 rows affected (0.00 sec)

mysql> SELECT user, host FROM mysql.user;
+---------------+-----------+
| user          | host      |
+---------------+-----------+
| mysql.session | localhost |
| mysql.sys     | localhost |
| root          | localhost |
| www           | localhost |
+---------------+-----------+
4 rows in set (0.00 sec)

mysql> 

CF-SX2@makoto 08:30:01/210220(..git-work/ja-wordpress)% mysql wordpress -p -u www -h localhost
Enter password: 
ERROR 1044 (42000): Access denied for user 'www'@'localhost' to database 'wordpress'

mysql> SHOW GRANTS FOR 'www'@'localhost';
+-----------------------------------------+
| Grants for www@localhost                |
+-----------------------------------------+
| GRANT USAGE ON *.* TO 'www'@'localhost' |
+-----------------------------------------+
1 row in set (0.00 sec)

mysql> 

set ALL GRANTS

mysql> GRANT ALL on wordpress.* to www@localhost;
Query OK, 0 rows affected (0.00 sec)

mysql> SHOW GRANTS FOR 'www'@'localhost';
+------------------------------------------------------------+
| Grants for www@localhost                                   |
+------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'www'@'localhost'                    |
| GRANT ALL PRIVILEGES ON `wordpress`.* TO 'www'@'localhost' |
+------------------------------------------------------------+
2 rows in set (0.00 sec)

mysql>