Cannot login to 7.5x or 8.0x software install


Webtrends Analytics 8.1x
Webtrends Analytics 8.0x
Webtrends Enterprise 7.5x
Webtrends Professional 7.5x
Webtrends Small Business 7.5x


An administrator of a Webtrends installation is unable to log into their administrator account and there are either no other administrators available or no other administrator accounts on the system.


Execute the attached “Webtrends_80x-81x_insert_admin.txt” script for Webtrends Analytics installations 8.0x – 8.1x or “Webtrends_75_insert_admin.txt” for Webtrends 7.5x installations.The scripts will create an administrator-level account with the user name “wtsupport” and the password “admin”.

Perform the following steps before running the script:
1. Stop all Webtrends services, stopping the “Webtrends – MySQL” service last.

2. Back up the MySQL database, found in the following location:


3. Start the “Webtrends – MySQL” service.

4. Examine the wt_user table in the wtmaster database. Make note of the last number used in the “UserID” column.

5. Replace each occurrence of “999” in the applicable script to be the next incremented value from the current UserID value from step 4.

Execute the queries in the script, then log in and confirm the application is accessible with administrative rights.

It is recommended the user changes the account user name and password immediately after logging in.