Better MySQL User Management

2 posts / 0 new

Topic locked

#1 Tue, 08/27/2013 - 19:07

tuaris

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.

#2 Fri, 10/31/2014 - 12:09

ReArmedHalo

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.

-Dustin

Topic locked