Ralph J. Smit
It would be very handy to allow editing database users. For example, allowing remote access or resetting the password. Thanks!
Xenia Loyalty
Besides just allowing select only i would like to see it having all the options when it comes to MySQL/MariaDB permissions.
Alex Brindley
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.
Paul
Experiencing this same issue.
Setting localhost as default would be ideal.
Dennis
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
3 months ago -
Dennis moved item to board In progress
7 months ago -
Dennis moved item to board Planned
2 years ago -
Ralph J. Smit moved item to project Panel Requests
2 years ago -
Ralph J. Smit created the item
2 years ago