It would be very handy to allow editing database users. For example, allowing remote access or resetting the password. Thanks!
Besides just allowing select only i would like to see it having all the options when it comes to MySQL/MariaDB permissions.
Would also be nice to set a default host for users. 127.0.0.1 is weird considering localhost is common, and I have to manually go in and change the host to make things work like normal.
Edditting users is going to be tricky, there are a few reasons for this:
- For database users, changing the username is effectively creating a new user, as MySQL/PostgreSQL treats this as a completely different entity with different permissions.
- The current feature set already has a separate "Reset Password" functionality that handles password changes specifically.
- In database systems, renaming users is often not a simple operation - it typically requires dropping and recreating the user with new permissions, which is risky.
For now, I'd recommend creating a "fresh" user and dropping the old user if you're migrated over with your application.
Allow editing database users
-
Dennis moved item to board Closed
8 months ago -
Dennis moved item to board In progress
11 months ago -
Dennis moved item to board Planned
3 years ago -
Ralph J. Smit moved item to project Panel Requests
3 years ago -
Ralph J. Smit created the item
3 years ago