What are the mysql databases used by NFA and what are the default usernames and passwords?
The NFA Console has 1 database called 'reporter' which runs on port 3308.
The username/password for the reporter database is netqos/netqos
The Harvester has several databases listed below, along with the usernames and passwords, that run on port 3308 that hold inventory and configuration information:
harvester - harvest/harvest
poller - netqos/netqos
data_retention - netqos/netqos
The Harvester also has 2 databases on port 3307, which are custom mysql storage engines, in which the data is accessed through:
archive - archive/archive
archive15 - archive/archive
-If you are attempting to login to mysql remotely you will need to use one of the username/passwords above in the format below:
-To connect to the 'reporter' database on the NFA Console server run the command:
mysql -D reporter -h <host IP address> -u netqos -p
Then enter the password 'netqos' when prompted.
-To connect to a database running on the non default port of 3307 you must specific the port using -P in the mysql syntax, for example below is how to connect to the archive15 database on a Harvester:
mysql -P3307 -D archive15 -h <host IP Address> -u archive -p
Then enter the password 'archive' when prompted.
-If you are attempting to login to mysql locally on one of the NFA servers, you will not need to enter a user or password by default, below is an example of how to login to mysql locally on a server.
-Below is how to login to a database on port 3307 locally on the server:
mysql -P3307 archive
-If you wish to login as root, root has no password but is only available locally on each server. Remote connections will not allow root access. To login locally to a database using root credentials, use the syntax below:
mysql reporter -u root
**Note we do not recommend changing the default mysql usernames as passwords, as this can cause issues with Support gathering database information via the CA RemoteEngineer, as well as it causing issues with upgrades and other product functionality.**