This article is also available in our new Knowlege Base: Cannot Login (Empty Users List In Login Screen)
Zend Server 7, 8 (reinstall / upgrade)
Admin UI Login Screen
In normal Zend Server workflows, once a new setup has been launched successfully, a new Administrator user is generated with an initial password and login is enabled.
This article should help in case the users list in the Zend Server Admin UI becomes empty or malformed, most probably after a version upgrade / downgrade to Zend Server (or reinstall of the same version after problems).
As a result of an empty users table, you cannot select a user (Admin / Developer) and normal login is not possible.
Solution (validated on Linux)
Open root console, or run the following with 'sudo <command>'.
1. Backup GUI DB
2. Check Existing Users
Important! Record any output which is NOT EMPTY for reference!
3. Insert Admin User (password: zend)
4. If you need a Developer user (password: zend)
5. Extra Step securing passwords!!!
This is critical if Zend Server is not private or local, and users can try to access it without permissions.
You can also modify the passwords once you login to the Admin UI, under Administration -> Users (you need to provide existing password and the new password).
TBD (we don't have reports yet on Windows missing GUI users, however the flow is exactly the same, without using SQLite3 but some other SQLite v.3 client editor for Windows)
Related KB: How can I add new users to Zend Server UI