VNA upgrade fails - unable to login to MySQL

Products

• Network Observability
• Virtual Network Assurance

Issue/Introduction

When running the VNA installer to upgrade a current installation, it fails when attempting to authenticate to MySql, showing the following:

Please enter the existing password for root@localhost account in MysQL>
Please re-enter the existing password for root@localhost account in MySQL>
[attempt : 1/5] ine password you entered tor root@localhost appears to be invalid. Please try again

 

When attempting to login to MySql after the installer is first run, it fails to login to MySql at all with error:

ERROR 1524(H·000) : Plugin 'mysql_native_password' not loaded

Environment

DX NetOps Virtual Network Assurance (VNA) 25.4.8 and later

Cause

This error affects MySQL 8.4 or later, where the old mysql_native_password plugin is turned off by default, but the DB user account still tries to use it.

Resolution

Manually edit the /etc/my.cnf file and add the following Line to the [mysqld] section:

mysql_native_password=ON

Then restart MySql:

systemctl stop mysql
systemctl start mysql