Weird things.. Database related

[jet1972]

Found out that DA claims that some databaseses have more Users associated to a database than there actually are specified database users in total...

What is going on here?

 

[zEitEr]

Hello,

Do you see unknown usernames associated with a database? Do you have ine-click access to phpmyadmin enabled? If the both are true, then that's the explanation.

 

[jet1972]

Hey.

That is maybe it.

But why does DA not remove those "One-click access" users automatically after a period?

And how do I look in to a database from shell and see all usernames associated with a database?

 

[zEitEr]

But why does DA not remove those "One-click access" users automatically after a period?

Normally it does at least on logout.

The logout will redirect to /phpMyAdmin/direct_login/logout.php, which destroys all SignonSession cookies, so a normal user/pass login can happen if /phpMyAdmin is accessed manually.

...DA goes out of it's way to hide them from counts and listings, even though the are there.

The /usr/local/directadmin/data/admin/phpmyadmin_sso.conf lists all allow users.

The nightly tally will clear any accounts when they expire after 16 hours.

Any da_sso_* user found in mysql that is NOT in the phpmyadmin_sso.conf will be removed for the database.

Any account in phpmyadmin_sso.conf that has a creation time greater than 16 hours, will be removed from both phpmyadmin_sso.conf and the database.

- https://docs.directadmin.com/change...ny-phpmyadmin-database-from-directadmin-skins

And how do I look in to a database from shell and see all usernames associated with a database?

Check MySQL documentaion on the matter. That's standard