Yesterday, I ran my first attempt at Migrating a MySQL 8.0 jail to a new MySQL 8.4 jail – it went better than I expected. However, I spent more time with MySQL than either the data transfer or the MySQL upgrade itself. Today, that should go faster because I already know the fix and have saved the password updates.
Today, I’m going to try again, and hopefully this time will be the last time.
This it the current plan:
- sudo service jail stop mysql02
- sudo zfs rename data02/jails/mysql02 data02/jails/mysql02.old
- sudo zfs snapshot data02/jails/mysql01@mysql80-part2
- sudo zfs clone data02/jails/mysql01@mysql80-part2 data02/jails/mysql02
- sudo service jail start mysql02
- repeat the password fixing stuff from ERROR 1524 (HY000): Plugin ‘mysql_native_password’ is not loaded
In this post:
- FreeBSD 14.3
- MySQL 8.0.44
- MySQL 8.4.7
Let’s get started. This post brought to you by Winter Storm Fern, my morning coffee, and the world’s biggest blankie.
Saving the old new-jail away
This is me turning off and saving my current work.
[12:26 r730-01 dvl ~] % sudo service jail stop mysql02 Stopping jails: mysql02. [12:26 r730-01 dvl ~] % sudo zfs rename data02/jails/mysql02 data02/jails/mysql02.old.DELETE.after.2026.02.01 cannot unmount '/jails/mysql02': pool or dataset is busy [12:26 r730-01 dvl ~] % sudo zfs umount data02/jails/mysql02 cannot unmount '/jails/mysql02': pool or dataset is busy
Now that’s got me stumped. I’m the only one on this host. It’s not like someone is cd‘d into that directory.
Here we go, force it:
[12:31 r730-01 dvl ~] % sudo zfs rename -f data02/jails/mysql02 data02/jails/mysql02.old.DELETE.after.2026.02.01 [12:31 r730-01 dvl ~] %
Create the new jail dataset
Snapshot and clone:
[12:32 r730-01 dvl ~] % sudo zfs snapshot data02/jails/mysql01@mysql80-part2 [12:32 r730-01 dvl ~] % sudo zfs clone data02/jails/mysql01@mysql80-part2 data02/jails/mysql02 [12:32 r730-01 dvl ~] %
Customize the new jail
These are the changes I made to the newly created jail dataset. I modified these files from the jail host before starting the jail.
- set mysql_enable=”NO” in /etc/rc.conf
- set the new IP address in /usr/local/etc/{snmpd.conf,nrpe.cfg}
- Remove the old log files: sudo rm /jails/mysql02/var/db/mysql/mysql01.int.unixathome.org.*
- Temporarily add mysql_native_password=ON to /usr/local/etc/mysql/my.cnf so I can manually update the password hashing – see ERROR 1524 (HY000): Plugin ‘mysql_native_password’ is not loaded
Adjust things for the presence of a new host
Not shown in this post, but stuff I need to do:
- Add mysql02 to Nagios
- Add mysql02 to LibreNMS
- Add mysql02 to ~rsyncer/.ssh/authorized_keys in the dbclone jail.
- On mysql02, alter /usr/home/rsyncer/bin/backup.sh to refer to mysql02, not the old mysql01
Start the jail
[12:46 r730-01 dvl ~] % sudo service jail start mysql02 Starting jails: mysql02.
What’s up?
[12:49 mysql02 dvl ~] % ps auwwx USER PID %CPU %MEM VSZ RSS TT STAT STARTED TIME COMMAND dvl 4749 0.5 0.0 16108 5400 2 SsJ 12:49 0:00.04 -zsh (zsh) dvl 4747 0.3 0.0 24068 10844 - SJ 12:49 0:00.01 sshd-session: dvl@pts/2 (sshd-session) snmpd 3579 0.2 0.0 36128 17724 - SJ 12:49 0:00.01 /usr/local/sbin/snmpd -p /var/run/net_snmpd.pid -u snmpd -g snmpd -c /usr/local/etc/snmpd.conf -a -r root 4743 0.2 0.0 24068 10560 - SsJ 12:49 0:00.02 sshd-session: dvl [priv] (sshd-session) root 3649 0.1 0.0 23508 9880 - SsJ 12:49 0:00.00 sshd: /usr/sbin/sshd [listener] 0 of 10-100 startups (sshd) root 3550 0.0 0.0 13904 2720 - SsJ 12:49 0:00.00 /usr/sbin/syslogd -s root 3596 0.0 0.0 13944 2544 - SsJ 12:49 0:00.00 /usr/sbin/cron -s nagios 3677 0.0 0.0 19596 7520 - SsJ 12:49 0:00.00 /usr/local/sbin/nrpe -c /usr/local/etc/nrpe.cfg -d dvl 4998 0.0 0.0 14484 2992 2 R+J 12:49 0:00.00 ps auwwx [12:49 mysql02 dvl ~] %
That looks OK. Good start.
Update and start mysql
For me, I had to change repo sources (i.e. /usr/local/etc/pkg/repos/local.conf) to one which built nrpe with MySQL 8.4 support.
[12:52 mysql02 dvl ~] % sudo pkg install mysql84-server Updating local repository catalogue... [mysql02.int.unixathome.org] Fetching meta.conf: 100% 179 B 0.2 k/s 00:01 [mysql02.int.unixathome.org] Fetching data: 100% 409 KiB 418.4 k/s 00:01 Processing entries: 100% local repository update completed. 1305 packages processed. All repositories are up to date. The following 2 package(s) will be affected (of 0 checked): New packages to be INSTALLED: mysql84-client: 8.4.7 mysql84-server: 8.4.7 Number of packages to be installed: 2 The process will require 314 MiB more space. 32 MiB to be downloaded. Proceed with this action? [y/N]: y [mysql02.int.unixathome.org] [1/2] Fetching mysql84-client-8.4.7: 100% 6 MiB 6.2 M/s 00:01 [mysql02.int.unixathome.org] [2/2] Fetching mysql84-server-8.4.7: 100% 26 MiB 27.6 M/s 00:01 Checking integrity... done (3 conflicting) - mysql84-client-8.4.7 conflicts with mysql80-client-8.0.44 on /usr/local/bin/comp_err - mysql84-client-8.4.7 conflicts with mysql80-client-8.0.44 on /usr/local/bin/comp_err - mysql84-server-8.4.7 conflicts with mysql80-server-8.0.44 on /usr/local/LICENSE.router Checking integrity... done (0 conflicting) Conflicts with the existing packages have been found. One more solver iteration is needed to resolve them. The following 7 package(s) will be affected (of 0 checked): New packages to be INSTALLED: mysql84-client: 8.4.7 mysql84-server: 8.4.7 Installed packages to be REINSTALLED: pkg-2.5.1 Installed packages to be REMOVED: mysql80-client: 8.0.44 mysql80-server: 8.0.44 nagios-plugins: 2.4.4,1 nrpe: 4.1.3 Number of packages to be removed: 4 Number of packages to be installed: 2 Number of packages to be reinstalled: 1 The process will require 1 MiB more space. Proceed with this action? [y/N]: y Checking integrity... done (0 conflicting) [mysql02.int.unixathome.org] [1/7] Deinstalling mysql80-server-8.0.44... [mysql02.int.unixathome.org] [1/7] Deleting files for mysql80-server-8.0.44: 100% ==> You should manually remove the "mysql" user ==> You should manually remove the "mysql" group [mysql02.int.unixathome.org] [2/7] Deinstalling nrpe-4.1.3... [mysql02.int.unixathome.org] [2/7] Deleting files for nrpe-4.1.3: 100% ==> You should manually remove the "nagios" user ==> You should manually remove the "nagios" group [mysql02.int.unixathome.org] [3/7] Deinstalling nagios-plugins-2.4.4,1... [mysql02.int.unixathome.org] [3/7] Deleting files for nagios-plugins-2.4.4,1: 100% [mysql02.int.unixathome.org] [4/7] Deinstalling mysql80-client-8.0.44... [mysql02.int.unixathome.org] [4/7] Deleting files for mysql80-client-8.0.44: 100% [mysql02.int.unixathome.org] [5/7] Installing mysql84-client-8.4.7... [mysql02.int.unixathome.org] [5/7] Extracting mysql84-client-8.4.7: 100% [mysql02.int.unixathome.org] [6/7] Installing mysql84-server-8.4.7... ===> Creating groups Using existing group 'mysql' ===> Creating users Using existing user 'mysql' ===> Creating homedir(s) [mysql02.int.unixathome.org] [6/7] Extracting mysql84-server-8.4.7: 100% [mysql02.int.unixathome.org] [7/7] Reinstalling pkg-2.5.1... [mysql02.int.unixathome.org] [7/7] Extracting pkg-2.5.1: 100% You may need to manually remove /usr/local/etc/mysql/my.cnf if it is no longer needed. You may need to manually remove /usr/local/etc/nrpe.cfg if it is no longer needed. ===== Message from mysql84-client-8.4.7: -- This is the mysql CLIENT without the server. for complete server and client, please install databases/mysql84-server ===== Message from mysql84-server-8.4.7: -- There is no initial password for first time use of MySQL. Keep in mind to reset it to a secure password. MySQL 8.4 has a default /usr/local/etc/mysql/my.cnf, remember to replace it with your own or set `mysql_optfile="$YOUR_CNF_FILE` in rc.conf. You may need to manually remove /usr/local/etc/pkg.conf if it is no longer needed.
OH WAIT, DID YOU SEE THAT ON LINE 56:
[mysql02.int.unixathome.org] [2/7] Deinstalling nrpe-4.1.3...
That happened yesterday, but I didn’t notice it.
Why does it get removed? nrpe is built against a specific version of MySQL. In this case, MySQL 8.0; as I type this, I’m building new packages against MySQL 8.4. Perhaps I’ll need to run this process a third time.
Enable mysql:
[13:03 mysql02 dvl ~] % sudo sysrc mysql_enable="YES" mysql_enable: NO -> YES
Start:
[13:04 mysql02 dvl ~] % sudo service mysql-server start Starting mysql.
That took about 20 seconds to run. What was it doing? An upgrade in place:
[13:05 mysql02 dvl /var/db/mysql] % sudo cat mysql02.int.unixathome.org.err 2026-01-25T13:04:39.6NZ mysqld_safe Logging to '/var/db/mysql/mysql02.int.unixathome.org.err'. 2026-01-25T13:04:39.6NZ mysqld_safe Starting mysqld daemon with databases from /var/db/mysql 2026-01-25T13:04:39.967460Z 0 [System] [MY-015015] [Server] MySQL Server - start. 2026-01-25T13:04:40.234465Z 0 [System] [MY-010116] [Server] /usr/local/libexec/mysqld (mysqld 8.4.7) starting as process 50543 2026-01-25T13:04:40.254156Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2026-01-25T13:04:41.108366Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2026-01-25T13:04:41.125322Z 1 [System] [MY-011090] [Server] Data dictionary upgrading from version '80023' to '80300'. 2026-01-25T13:04:42.111377Z 1 [System] [MY-013413] [Server] Data dictionary upgrade from version '80023' to '80300' completed. 2026-01-25T13:04:46.918844Z 4 [System] [MY-013381] [Server] Server upgrade from '80044' to '80407' started. 2026-01-25T13:04:59.595070Z 4 [System] [MY-013381] [Server] Server upgrade from '80044' to '80407' completed. 2026-01-25T13:05:00.670478Z 0 [System] [MY-010229] [Server] Starting XA crash recovery... 2026-01-25T13:05:00.682472Z 0 [System] [MY-010232] [Server] XA crash recovery finished. 2026-01-25T13:05:01.217670Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2026-01-25T13:05:01.217720Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. 2026-01-25T13:05:01.226666Z 0 [ERROR] [MY-000067] [Server] unknown variable 'add mysql_native_password=ON'. 2026-01-25T13:05:01.227590Z 0 [ERROR] [MY-010119] [Server] Aborting 2026-01-25T13:05:02.160319Z 0 [System] [MY-010910] [Server] /usr/local/libexec/mysqld: Shutdown complete (mysqld 8.4.7) Source distribution. 2026-01-25T13:05:02.160385Z 0 [System] [MY-015016] [Server] MySQL Server - end. 2026-01-25T13:05:02.6NZ mysqld_safe mysqld from pid file /var/db/mysql/mysql02.int.unixathome.org.pid ended
See line 16 too, I typoed that line, including “add” in my copy/paste. Fixing that, we start up this way:
2026-01-25T13:08:34.6NZ mysqld_safe Logging to '/var/db/mysql/mysql02.int.unixathome.org.err'. 2026-01-25T13:08:34.6NZ mysqld_safe Starting mysqld daemon with databases from /var/db/mysql 2026-01-25T13:08:34.809127Z 0 [System] [MY-015015] [Server] MySQL Server - start. 2026-01-25T13:08:35.081781Z 0 [System] [MY-010116] [Server] /usr/local/libexec/mysqld (mysqld 8.4.7) starting as process 45863 2026-01-25T13:08:35.094231Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2026-01-25T13:08:35.573195Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2026-01-25T13:08:35.914229Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2026-01-25T13:08:35.914294Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. 2026-01-25T13:08:35.974135Z 0 [System] [MY-010931] [Server] /usr/local/libexec/mysqld: ready for connections. Version: '8.4.7' socket: '/tmp/mysql.sock' port: 3306 Source distribution. 2026-01-25T13:08:35.974139Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '0.0.0.0' port: 33060, socket: /tmp/mysqlx.sock 2026-01-25T13:09:00.014207Z 8 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
We see this running:
[13:10 mysql02 dvl ~] % ps auwwx USER PID %CPU %MEM VSZ RSS TT STAT STARTED TIME COMMAND mysql 45863 0.2 0.1 1239816 563220 - IJ 13:08 0:02.01 /usr/local/libexec/mysqld --defaults-extra-file=/usr/local/etc/mysql/my.cnf --basedir=/usr/local --datadir=/var/db/mysql --plugin-dir=/usr/local/lib/mysql/plugin --log-error=mysql02.int.unixathome.org.err --pid-file=/var/db/mysql/mysql02.int.unixathome.org.pid root 3550 0.0 0.0 13904 2720 - SsJ 12:49 0:00.01 /usr/sbin/syslogd -s snmpd 3579 0.0 0.0 36128 17728 - SJ 12:49 0:00.58 /usr/local/sbin/snmpd -p /var/run/net_snmpd.pid -u snmpd -g snmpd -c /usr/local/etc/snmpd.conf -a -r root 3596 0.0 0.0 13944 2544 - IsJ 12:49 0:00.01 /usr/sbin/cron -s root 3649 0.0 0.0 23508 9880 - IsJ 12:49 0:00.01 sshd: /usr/sbin/sshd [listener] 0 of 10-100 startups (sshd) nagios 3677 0.0 0.0 19596 7520 - IsJ 12:49 0:00.00 /usr/local/sbin/nrpe -c /usr/local/etc/nrpe.cfg -d root 4743 0.0 0.0 24068 10560 - IsJ 12:49 0:00.02 sshd-session: dvl [priv] (sshd-session) dvl 4747 0.0 0.0 24068 10880 - SJ 12:49 0:00.41 sshd-session: dvl@pts/2 (sshd-session) root 6482 0.0 0.0 24068 10740 - IsJ 13:02 0:00.03 sshd-session: dvl [priv] (sshd-session) dvl 13540 0.0 0.0 24068 11064 - SJ 13:02 0:00.28 sshd-session: dvl@pts/6 (sshd-session) mysql 45394 0.0 0.0 14404 3076 - IsJ 13:08 0:00.02 /bin/sh /usr/local/bin/mysqld_safe --defaults-extra-file=/usr/local/etc/mysql/my.cnf --basedir=/usr/local --datadir=/var/db/mysql --pid-file=/var/db/mysql/mysql02.int.unixathome.org.pid --user=mysql dvl 4749 0.0 0.0 19064 6212 2 SsJ 12:49 0:00.10 -zsh (zsh) dvl 9950 0.0 0.0 14484 3056 2 R+J 13:10 0:00.00 ps auwwx dvl 14015 0.0 0.0 19064 6132 6 Ss+J 13:02 0:00.10 -zsh (zsh)
Fixing the password hashing
Following on from what I learned in ERROR 1524 (HY000): Plugin ‘mysql_native_password’ is not loaded, I’m doing the following steps:
mysql> SELECT user, host, plugin from mysql.user order by plugin, user, host; +------------------+-------------------------------+-----------------------+ | user | host | plugin | +------------------+-------------------------------+-----------------------+ | mysql.infoschema | localhost | caching_sha2_password | | mysql.session | localhost | caching_sha2_password | | mysql.sys | localhost | caching_sha2_password | | | localhost | mysql_native_password | | fruityext | fruit-ext.int.unixathome.org | mysql_native_password | | fruityext | fruity-ext.int.unixathome.org | mysql_native_password | | fruityint | fruit-int.int.unixathome.org | mysql_native_password | | fruityint | fruity-int.int.unixathome.org | mysql_native_password | | librenms | 10.55.0.27 | mysql_native_password | | librenms | besser.int.unixathome.org | mysql_native_password | | librenms_dvl | 10.55.0.31 | mysql_native_password | | nagiosql_user | 10.55.0.116 | mysql_native_password | | nagiosql_user | 10.55.0.116'; | mysql_native_password | | root | % | mysql_native_password | | root | 127.0.0.1 | mysql_native_password | | root | ::1 | mysql_native_password | | root | localhost | mysql_native_password | | rsyncer | % | mysql_native_password | | rsyncer | localhost | mysql_native_password | +------------------+-------------------------------+-----------------------+ 19 rows in set (0.00 sec)
The following paste has been slightly modified for your viewing pleasure:
mysql> alter user 'librenms'@'10.55.0.27' IDENTIFIED WITH caching_sha2_password BY 'foo'; Query OK, 0 rows affected (0.02 sec) mysql> alter user 'librenms'@'besser.int.unixathome.org' IDENTIFIED WITH caching_sha2_password BY 'foo'; Query OK, 0 rows affected (0.02 sec) mysql> alter user 'root'@'%' IDENTIFIED WITH caching_sha2_password BY 'foo'; Query OK, 0 rows affected (0.02 sec) mysql> alter user 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'foo'; Query OK, 0 rows affected (0.02 sec) mysql> alter user 'nagiosql_user'@'10.55.0.116' IDENTIFIED WITH caching_sha2_password BY 'foo'; Query OK, 0 rows affected (0.02 sec) mysql> alter user 'rsyncer'@'%' IDENTIFIED WITH caching_sha2_password BY 'foo'; Query OK, 0 rows affected (0.02 sec) mysql> alter user 'rsyncer'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'foo'; Query OK, 0 rows affected (0.02 sec) mysql> alter user 'librenms_dvl'@'10.55.0.31' IDENTIFIED WITH caching_sha2_password BY 'foo'; Query OK, 0 rows affected (0.02 sec) mysql> alter user 'root'@'127.0.0.1' IDENTIFIED WITH caching_sha2_password BY 'foo'; Query OK, 0 rows affected (0.02 sec) mysql> alter user 'root'@'::1' IDENTIFIED WITH caching_sha2_password BY 'foo'; Query OK, 0 rows affected (0.02 sec) mysql> alter user 'fruityint'@'fruity-int.int.unixathome.org' IDENTIFIED WITH caching_sha2_password BY 'foo'; Query OK, 0 rows affected (0.02 sec) mysql> drop user 'fruityext'@'fruit-ext.int.unixathome.org'; Query OK, 0 rows affected (0.02 sec) mysql> drop user 'fruityint'@'fruit-int.int.unixathome.org'; Query OK, 0 rows affected (0.01 sec) mysql> drop user 'fruityext'@'fruity-ext.int.unixathome.org'; Query OK, 0 rows affected (0.01 sec) mysql> drop user ''@'localhost'; Query OK, 0 rows affected (0.01 sec) mysql> drop user 'nagiosql_user'@'10.55.0.116\';'; Query OK, 0 rows affected (0.02 sec) mysql>
With those commands issued:
mysql> SELECT user, host, plugin from mysql.user order by plugin, user, host; +------------------+-------------------------------+-----------------------+ | user | host | plugin | +------------------+-------------------------------+-----------------------+ | fruityint | fruity-int.int.unixathome.org | caching_sha2_password | | librenms | 10.55.0.27 | caching_sha2_password | | librenms | besser.int.unixathome.org | caching_sha2_password | | librenms_dvl | 10.55.0.31 | caching_sha2_password | | mysql.infoschema | localhost | caching_sha2_password | | mysql.session | localhost | caching_sha2_password | | mysql.sys | localhost | caching_sha2_password | | nagiosql_user | 10.55.0.116 | caching_sha2_password | | root | % | caching_sha2_password | | root | 127.0.0.1 | caching_sha2_password | | root | ::1 | caching_sha2_password | | root | localhost | caching_sha2_password | | rsyncer | % | caching_sha2_password | | rsyncer | localhost | caching_sha2_password | +------------------+-------------------------------+-----------------------+ 14 rows in set (0.00 sec) mysql>
All the users are now on the caching_sha2_password hashing algorithm. The spurious users have been deleted.
Reverting the temporary mysql configuration change
Not shown here: removal of mysql_native_password=ON from /usr/local/etc/mysql/my.cnf. Then a restart:
File /var/tmp/mye45TdAoR.cnf saved [13:19 mysql02 dvl ~] % sudo service mysql-server restart Stopping mysql. Waiting for PIDS: 45863. Starting mysql.
The logs indicate:
2026-01-25T13:19:29.410798Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user. Shutting down mysqld (Version: 8.4.7). 2026-01-25T13:19:30.502667Z 0 [System] [MY-010910] [Server] /usr/local/libexec/mysqld: Shutdown complete (mysqld 8.4.7) Source distribution. 2026-01-25T13:19:30.502735Z 0 [System] [MY-015016] [Server] MySQL Server - end. 2026-01-25T13:19:30.6NZ mysqld_safe mysqld from pid file /var/db/mysql/mysql02.int.unixathome.org.pid ended 2026-01-25T13:19:30.6NZ mysqld_safe Logging to '/var/db/mysql/mysql02.int.unixathome.org.err'. 2026-01-25T13:19:30.6NZ mysqld_safe Starting mysqld daemon with databases from /var/db/mysql 2026-01-25T13:19:30.824101Z 0 [System] [MY-015015] [Server] MySQL Server - start. 2026-01-25T13:19:31.140111Z 0 [System] [MY-010116] [Server] /usr/local/libexec/mysqld (mysqld 8.4.7) starting as process 54894 2026-01-25T13:19:31.157425Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2026-01-25T13:19:31.684710Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2026-01-25T13:19:32.025095Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2026-01-25T13:19:32.025167Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. 2026-01-25T13:19:32.088489Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '0.0.0.0' port: 33060, socket: /tmp/mysqlx.sock 2026-01-25T13:19:32.088577Z 0 [System] [MY-010931] [Server] /usr/local/libexec/mysqld: ready for connections. Version: '8.4.7' socket: '/tmp/mysql.sock' port: 3306 Source distribution.
And, I can get into MySQL just fine, thank you very much:
[13:19 mysql02 dvl ~] % mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 8 Server version: 8.4.7 Source distribution Copyright (c) 2000, 2025, 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>
So far, so good
This run has been good. The only remaining issue is buildina a new nrpe compatible with MySQL 8.4 – that is in progress.
If you are using the FreeBSD supplied packages, you won’t be able to do that. You’ll need to wait until the default MySQL version moves to MySQL 8.4 – I’m running poudriere, and I build my own packages.
I will be running the above steps one more time. I will decide later if a new post is justified.
18:45 UTC – I did have to create ~nagios/.my.cnf containing the user name and password for my Nagios check:
[18:46 mysql02 dvl ~] % sudo cat ~nagios/.my.cnf
[client]
user=nagios
password=foo
Now it works. Well, after setting that password in MySQL too:
mysql> alter USER 'nagios'@'localhost' identified by 'foo'; Query OK, 0 rows affected (0.02 sec)
I’m not sure why it worked on mysql01.
