NFA "access denied for user" errors accessing MySQL

Products

• Network Flow Analysis

Issue/Introduction

Starting in Network Flow Analysis 21.2.8, we no longer ship the MySQL with the anonymous use enabled.

When accessing Mysql without a password you now get the following error:

 

ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO)

Environment

NFA 21.2.8+

Cause

Access to MySQL now requires a password.

This was done for security reasons.

Resolution

When accessing Network Flow Analysis you need to specify the user and password now.

 

For example you can use the 'netqos' user for situations where you don't need root access:

mysql -unetqos -p <databaseName>

(default password is 'netqos')

 

If you need root access, you can access the databases with the 'root' user:

mysql -uroot -p <databaseName>

(default password is 'root@123')

 

If you want to change the default password you could:

Configure the MySQL User Password

Please note that the password for a user should be the same in both the NFA Harvester and the NFA Console servers.

Additional Information

If you have any scripts running, ensure that they utilize the above resolutions up top.

Passwords for scripts could be included inline if you want like this:

mysql -unetqos -pnetqos  <databaseName>......