List of mysql users, how?

[Richard G]

In DA you can see a list of mysql databases.
If you create a new mysql database, you can choose from exising users if you want.

In Cpanel, you also get a list of mysql users, same way you see the mysql databases you made.

Is there an option in DA to display the mysql users? If possible (like with Cpanel) displayed to which databases they are connected?
This would be nice if you want to delete mysql uses you don't need anymore.

 

[zEitEr]

You can use either Directadmin API (CMD_API_DATABASES) or queries to MySQL server.

 

[Richard G]

Thanks, then it might be a good idea for a suggestion to put it in DA next to the databases like cpanel has.

 

[NoBaloney2]

Moved; this is now a feature request.

Jeff

 

[Richard G]

Thank you Jeff!

 

[DirectAdmin Support]

Is there an option in DA to display the mysql users? If possible (like with Cpanel) displayed to which databases they are connected?

You can already see which Users on are a DB by clicking on the database.

If a User is removed from a database, DA will check to see if it's on any other database, and if it's not on any other DB, then DA will delete that User.
With this (already in place), it should prevent any Users from existing if it's not assigned to a DB.

John

 

[Richard G]

Still it would be nicer to have it displayed like Cpanel does.
That way, there is an option for example to easily change the password of a mysql user.

 

[zEitEr]

Have a screen-shot? I personally do not know how does it look like.

 

[Richard G]

Ofcourse, that's no problem.

This is a screen on which you see the database, which user is connected to it (I like that a lot better).



This is the screen with the list of users.




When you click on a mysql usernaam, you get this screen:


I blanked out some info, but I think you can get the general idea. The screenshots are from different accounts, for security reasons.

 

[zEitEr]

So, you've got to select a DB, and only then you'll see a list of all users for the selected DB? Do I understand it correctly?

 

[Richard G]

No it's different.
1.) You login to your control panel, like DA. Then you have a list of possible database options. You click mysql, like you do in DA.
2.) Now you see picture msuser3.jpg and msuser1.jpg (together they are in fact 1 screenshot), so a complete oversight of your databases (like in DA) and below that, the option to create a new user, and the option to add a user to a database and the list of users. So really everything on 1 page, which is much more clearer and ofcourse easyer to use.
3.) If you click on a db-username in that part, you get a new screen (msuser2.jpg) in which you can change the password of that user.

If you want I can send you a complete screenshot, without blanked parts, but not on the public forum.

 

[Richard G]

@Zeiter: Did you understood my last explanation?
As it is easy this way to not only administer your databases but also your users and passwords, all from within 1 screen (except changing mysql user passwords which is linked to a new screen).

 

[zEitEr]

Yes, it is more or less clear. And I guess it can be easily done with current features:

+ you need modify skin, or create a new one
+ and a little bit scripting with API.

So, if you want, I'm ready to do it for you as a commerce service. If not, then feel free to tell me how else I can help you.

 

[Richard G]

Thank you. But it was just a feature suggestion. It doesn't have to look the same by layout as in cpanel. The current DA skin would also to the trick, my suggestion was only that these options and display would be added to the current DA page.
So it's a feature request, no commerce request. But thanks for the offer.

I just asked you because you stated in the previous reply you didn't understand, and I did not knew if my explanation to you was good enough.