|For a User, the "MySQL Management" page listing the databases has a column called "Number of Users" which represents the number of mysql accounts setup to use it. When you click the DB, you can see these accounts.|
However, DA does not show the fact that the DA system User account (that User's DA login name) is also able to access this database (as it's highly discouraged to use it in scripts, etc.)
So if there is 1 username_dbuser on username_db, there is also username on username_db. So the true count is 2.
When DA counts the Users in mysql, it sutracts 1 from this count to show the total number in the "Number of Users" column.
IssueIf you're seeing a total count of -1 on a given database, this would mean that:
SolutionThe solution is to simply add the username account onto username_db.
To do this, we need to login to /phpMyAdmin.
© 2018 JBMC Software, Suite 173 3-11 Bellerose Drive, St Albert, AB T8N 1P7 Canada. Mon-Fri 9AM-5PM MST