Read Only MySQL User How To

From Swivel Knowledgebase
Revision as of 15:07, 14 October 2011 by Admin (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search



Overview

This article describes the process of creating a Read Only MySQL user on High Availability PINsafe appliances.


Prerequisites

  • High Availability Active/Active appliances
  • MySQL as the configured database


Solution

  • Login to Webmin on the appliance you intend to query (see Webmin How To Guide if you are unfamiliar with this);
  • Select the Servers -> MySQL Database Server menu option;

Webmin servers menu.PNG


  • Click the "User Permissions" icon;

Webmin MySQL User Permissions Icon.PNG


  • Click the "Create new user" link towards the top of the page.

Webmin MySQL User Permissions Create.PNG


You should then be able to create a new user and provide it with "Select" privileges from the list as a minimum, to provide Read Only access.

Webmin MySQL User Permissions Create User.PNG


Related Articles

No doubt you may now wish to query the database using this new Read Only user. See the MySQL Queries How To Guide to see some example queries.