MySQL Setup shows negative number of users
- Thread starter ros
- Start date
scsi
Verified User
- Joined
- Aug 19, 2008
- Messages
- 4,695
This is what was told to me when I had the problem.
Code:
Sent:
On CMD_DB it is listing "Number of Users" as 0. Before we added a user to them they were -1. Where does it get the number from?
Response:
Hello,
The system account is going to be on all databases, but it doesn't show up in the list.
If it's missing, and there are 0 user_dbuser accounts, then it will show -1.
If you delete the database, and create the whole thing again, then DA will add the system account to the mysql.db table, and you'll get a proper count (or manually add it through phpmyadmin without deleting the db)
Thank you,
JohnSo the reason that there are -1 account in the "number of users" column is that the accounts are created by the da_admin user, and did not include the account/domain owner user, or simply have no user created for it?
In the accounts with a valid "number of users" count, i can see there is a database-specific user, the account owner and the da_admin user.
In the accounts with the negative "number of users" or zero account i can see there is no database-specific user or account owner user.
The solution is to add a user to it (both account owner, and database-specific user.).
This can be done in the PHPmyAdmin section for the admin user, and in the:
account_user » domain.com » MySQL Setup » View account_user_database and add an new (or existing user).
Thanks!
In the accounts with a valid "number of users" count, i can see there is a database-specific user, the account owner and the da_admin user.
In the accounts with the negative "number of users" or zero account i can see there is no database-specific user or account owner user.
The solution is to add a user to it (both account owner, and database-specific user.).
This can be done in the PHPmyAdmin section for the admin user, and in the:
account_user » domain.com » MySQL Setup » View account_user_database and add an new (or existing user).
Thanks!