Adding MySql Users

3 posts / 0 new
Last post
#1 Tue, 09/11/2007 - 22:19
Lorne

Adding MySql Users

How do you add more MySQL users in virtualmin?

I understand you can add a mail user who has database access. And you can also create an FTP user that has database access.

When creating a new mysql user for a database is there one that's better than the other?

Is it possible to create a MySql user that doesn't have a mailbox or FTP access?

I have been trying both options, but I don't understand the 'right' way to do it.

Also, I noticed that if a create a new database then delete it a record remains for the domain user in the MySql global database permissions table.

Wed, 09/12/2007 - 09:15
Joe
Joe's picture

Hey Lorne,

The FTP access user has more privileges than a mail user (it has access to the website content), so a regular mail user would be the way to go to get least privilege. You can actually disable mail for such a user, and enable just database access--that works fine. Note that the link to create this user type is just "Add a user to this server." as it isn't intended to just be for mail.

The label on the left menu and user management page is perhaps misleading, by calling it Mail and FTP Users, because it refers to all types of users, including those just intended for database or Subversion usage. It's a somewhat tricky usability problem, because only very advanced users ever want an extra database user, but everybody wants Mail and FTP users. (When this page has been called just "Virtual server users" or "User accounts" in usability testing, non-technical users couldn't figure out how to create mailboxes even after quite a lot of searching.)

--

Check out the forum guidelines!

Wed, 09/12/2007 - 10:01 (Reply to #2)
Lorne

Here's an answer to my question:

1. If you don't want to use the Virtualmin domain owners username and password to access databases then you need to change this under the tabs in Virtualmin/Edit Databases/ that say 'Usernames' and 'Passwords'. By changing these values all databases that have already been created, or that will be created in the future using Virtualmin will now use this new username and password.

Note: I think these should be on the main Databases page since they are global to all your databases.

2. If you want to add other database user accounts then its best to use Webmin and the global options under Webmin/Servers/MySQL Database Server/

Note: MySql users do not need to have a unix account on the server to work.

Note: Any databases you create in Webmin will not show up in the Virtualmin control panel. If you want to see databases in Virtualmin then you must create them there and then change user privileges via Webmin.

Topic locked