Better MySQL User Management

2 posts / 0 new
Last post
#1 Tue, 08/27/2013 - 19:07

Better MySQL User Management

Not sure if anyone else is having the same issue, but the current method of managing the MySQL users and database permissions is a little confusing and non-intuitive. Not only to the server admin but to the end user as well.

The way it is now

  • You first click on "Edit Users" - OKAY
  • Then it takes you to a screen that is entitled "Mail and FTP Users" - CONFUSING
  • You only have two choices "Add a user to this server." or "Add a website FTP access user." - Hmm.. I am not exactly sure what to tell the customer.
  • You are taken to a screen that appears to give the impression that you are in the wrong place. All I want is a MySQL user created, most of the fields refer to either mailbox settings or FTP settings. Turns out you are creating a Unix user account for MySQL access. - VERY BAD
  • Hidden away at the bottom is a section "Other user permissions".
  • Now you must choose from either "Email, or Email and FTP, or FTP Only" depending on which link you clicked. - HUH?
  • Underneath that, you have the first mention of MySQL. A box that lets you assign MySQL database permissions to the user you created.
  • The way it should be

  • You first click on "Edit Users"
  • A screen that is entitled "Mail, Database, and FTP Users"
  • Click "Add MySQL user"
  • A screen that asks for a username and password
  • A box that lets you assign MySQL database permissions to the user you created.
  • Done, no Unix user account needed.

    Fri, 10/31/2014 - 12:09

    I agree that the manage users screen is highly confusing at times. I believe if that screen was reorganized/relabeled then it would potentially solve the MySQL user management issue as well. You, as root at least (unsure of other users access and ability) , can create users on the MySQL Webmin module.


    Topic locked