Ralph J. Smit

Ralph J. Smit

Closed

It would be very handy to allow editing database users. For example, allowing remote access or resetting the password. Thanks!

Xenia Loyalty

Xenia Loyalty

· · Edited

Besides just allowing select only i would like to see it having all the options when it comes to MySQL/MariaDB permissions.

no votes yet
Alex Brindley

Alex Brindley

· · Edited

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.

2 total votes
Paul Jure Topolak
Paul

Paul

·

Experiencing this same issue.

Setting localhost as default would be ideal.

no votes yet
Dennis

Dennis

·

Edditting users is going to be tricky, there are a few reasons for this:

  1. 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.
  2. The current feature set already has a separate "Reset Password" functionality that handles password changes specifically.
  3. 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.

no votes yet

Allow editing database users

32 total votes
  • Dennis moved item to board Closed

    5 days ago
  • Dennis moved item to board In progress

    3 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