"Fossies" - the Fresh Open Source Software Archive

Member "phpMyAdmin-5.0.1-all-languages/doc/html/privileges.html" (7 Jan 2020, 9995 Bytes) of package /linux/www/phpMyAdmin-5.0.1-all-languages.zip:

The requested HTML page contains a <FORM> tag that is unusable on "Fossies" in "automatic" (rendered) mode so that page is shown as HTML source code syntax highlighting (style: standard) with prefixed line numbers. Alternatively you can here view or download the uninterpreted source code file.

    1 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
    2   "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    5 <html xmlns="http://www.w3.org/1999/xhtml">
    6   <head>
    7     <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    9     <title>User management &#8212; phpMyAdmin 5.0.1 documentation</title>
   11     <link rel="stylesheet" href="_static/classic.css" type="text/css" />
   12     <link rel="stylesheet" href="_static/pygments.css" type="text/css" />
   14     <script type="text/javascript">
   15       var DOCUMENTATION_OPTIONS = {
   16         URL_ROOT:    './',
   17         VERSION:     '5.0.1',
   18         COLLAPSE_INDEX: false,
   19         FILE_SUFFIX: '.html',
   20         HAS_SOURCE:  true
   21       };
   22     </script>
   23     <script type="text/javascript" src="_static/jquery.js"></script>
   24     <script type="text/javascript" src="_static/underscore.js"></script>
   25     <script type="text/javascript" src="_static/doctools.js"></script>
   26     <link rel="index" title="Index" href="genindex.html" />
   27     <link rel="search" title="Search" href="search.html" />
   28     <link rel="copyright" title="Copyright" href="copyright.html" />
   29     <link rel="top" title="phpMyAdmin 5.0.1 documentation" href="index.html" />
   30     <link rel="up" title="User Guide" href="user.html" />
   31     <link rel="next" title="Relations" href="relations.html" />
   32     <link rel="prev" title="Bookmarks" href="bookmarks.html" /> 
   33   </head>
   34   <body role="document">
   35     <div class="related" role="navigation" aria-label="related navigation">
   36       <h3>Navigation</h3>
   37       <ul>
   38         <li class="right" style="margin-right: 10px">
   39           <a href="genindex.html" title="General Index"
   40              accesskey="I">index</a></li>
   41         <li class="right" >
   42           <a href="relations.html" title="Relations"
   43              accesskey="N">next</a> |</li>
   44         <li class="right" >
   45           <a href="bookmarks.html" title="Bookmarks"
   46              accesskey="P">previous</a> |</li>
   47         <li class="nav-item nav-item-0"><a href="index.html">phpMyAdmin 5.0.1 documentation</a> &#187;</li>
   48           <li class="nav-item nav-item-1"><a href="user.html" accesskey="U">User Guide</a> &#187;</li> 
   49       </ul>
   50     </div>  
   52     <div class="document">
   53       <div class="documentwrapper">
   54         <div class="bodywrapper">
   55           <div class="body" role="main">
   57   <div class="section" id="user-management">
   58 <h1>User management<a class="headerlink" href="#user-management" title="Permalink to this headline"></a></h1>
   59 <p>User management is the process of controlling which users are allowed to
   60 connect to the MySQL server and what permissions they have on each database.
   61 phpMyAdmin does not handle user management, rather it passes the username and
   62 password on to MySQL, which then determines whether a user is permitted to
   63 perform a particular action. Within phpMyAdmin, administrators have full
   64 control over creating users, viewing and editing privileges for existing users,
   65 and removing users.</p>
   66 <p>Within phpMyAdmin, user management is controlled via the <span class="guilabel">Users</span> link
   67 from the main page. Users can be created, edited, and removed.</p>
   68 <div class="section" id="creating-a-new-user">
   69 <h2>Creating a new user<a class="headerlink" href="#creating-a-new-user" title="Permalink to this headline"></a></h2>
   70 <p>To create a new user, click the <span class="guilabel">Add a new user</span> link near the bottom
   71 of the <span class="guilabel">Users</span> page (you must be a &#8220;superuser&#8221;, e.g., user &#8220;root&#8221;).
   72 Use the textboxes and drop-downs to configure the user to your particular
   73 needs. You can then select whether to create a database for that user and grant
   74 specific global privileges. Once you&#8217;ve created the user (by clicking Go), you
   75 can define that user&#8217;s permissions on a specific database (don&#8217;t grant global
   76 privileges in that case). In general, users do not need any global privileges
   77 (other than USAGE), only permissions for their specific database.</p>
   78 </div>
   79 <div class="section" id="editing-an-existing-user">
   80 <h2>Editing an existing user<a class="headerlink" href="#editing-an-existing-user" title="Permalink to this headline"></a></h2>
   81 <p>To edit an existing user, simply click the pencil icon to the right of that
   82 user in the <span class="guilabel">Users</span> page. You can then edit their global- and
   83 database-specific privileges, change their password, or even copy those
   84 privileges to a new user.</p>
   85 </div>
   86 <div class="section" id="deleting-a-user">
   87 <h2>Deleting a user<a class="headerlink" href="#deleting-a-user" title="Permalink to this headline"></a></h2>
   88 <p>From the <span class="guilabel">Users</span> page, check the checkbox for the user you wish to
   89 remove, select whether or not to also remove any databases of the same name (if
   90 they exist), and click Go.</p>
   91 </div>
   92 <div class="section" id="assigning-privileges-to-user-for-a-specific-database">
   93 <h2>Assigning privileges to user for a specific database<a class="headerlink" href="#assigning-privileges-to-user-for-a-specific-database" title="Permalink to this headline"></a></h2>
   94 <p>Users are assigned to databases by editing the user record (from the
   95 <span class="guilabel">User accounts</span> link on the home page).
   96 If you are creating a user specifically for a given table
   97 you will have to create the user first (with no global privileges) and then go
   98 back and edit that user to add the table and privileges for the individual
   99 table.</p>
  100 </div>
  101 <div class="section" id="configurable-menus-and-user-groups">
  102 <span id="configurablemenus"></span><h2>Configurable menus and user groups<a class="headerlink" href="#configurable-menus-and-user-groups" title="Permalink to this headline"></a></h2>
  103 <p>By enabling <span class="target" id="index-0"></span><a class="reference internal" href="config.html#cfg_Servers_usergroups"><code class="xref config config-option docutils literal"><span class="pre">$cfg['Servers'][$i]['usergroups']</span></code></a> and
  104 <span class="target" id="index-1"></span><a class="reference internal" href="config.html#cfg_Servers_usergroups"><code class="xref config config-option docutils literal"><span class="pre">$cfg['Servers'][$i]['usergroups']</span></code></a> you can customize what users
  105 will see in the phpMyAdmin navigation.</p>
  106 <div class="admonition warning">
  107 <p class="first admonition-title">Warning</p>
  108 <p class="last">This feature only limits what a user sees, he is still able to use all the
  109 functions. So this can not be considered as a security limitation. Should
  110 you want to limit what users can do, use MySQL privileges to achieve that.</p>
  111 </div>
  112 <p>With this feature enabled, the <span class="guilabel">User accounts</span> management interface gains
  113 a second tab for managing <span class="guilabel">User groups</span>, where you can define what each
  114 group will view (see image below) and you can then assign each user to one of
  115 these groups. Users will be presented with a simplified user interface, which might be
  116 useful for inexperienced users who could be overwhelmed by all the features
  117 phpMyAdmin provides.</p>
  118 <img alt="_images/usergroups.png" src="_images/usergroups.png" />
  119 </div>
  120 </div>
  123           </div>
  124         </div>
  125       </div>
  126       <div class="sphinxsidebar" role="navigation" aria-label="main navigation">
  127         <div class="sphinxsidebarwrapper">
  128   <h3><a href="index.html">Table Of Contents</a></h3>
  129   <ul>
  130 <li><a class="reference internal" href="#">User management</a><ul>
  131 <li><a class="reference internal" href="#creating-a-new-user">Creating a new user</a></li>
  132 <li><a class="reference internal" href="#editing-an-existing-user">Editing an existing user</a></li>
  133 <li><a class="reference internal" href="#deleting-a-user">Deleting a user</a></li>
  134 <li><a class="reference internal" href="#assigning-privileges-to-user-for-a-specific-database">Assigning privileges to user for a specific database</a></li>
  135 <li><a class="reference internal" href="#configurable-menus-and-user-groups">Configurable menus and user groups</a></li>
  136 </ul>
  137 </li>
  138 </ul>
  140   <h4>Previous topic</h4>
  141   <p class="topless"><a href="bookmarks.html"
  142                         title="previous chapter">Bookmarks</a></p>
  143   <h4>Next topic</h4>
  144   <p class="topless"><a href="relations.html"
  145                         title="next chapter">Relations</a></p>
  146   <div role="note" aria-label="source link">
  147     <h3>This Page</h3>
  148     <ul class="this-page-menu">
  149       <li><a href="_sources/privileges.txt"
  150             rel="nofollow">Show Source</a></li>
  151     </ul>
  152    </div>
  153 <div id="searchbox" style="display: none" role="search">
  154   <h3>Quick search</h3>
  155     <form class="search" action="search.html" method="get">
  156       <div><input type="text" name="q" /></div>
  157       <div><input type="submit" value="Go" /></div>
  158       <input type="hidden" name="check_keywords" value="yes" />
  159       <input type="hidden" name="area" value="default" />
  160     </form>
  161 </div>
  162 <script type="text/javascript">$('#searchbox').show(0);</script>
  163         </div>
  164       </div>
  165       <div class="clearer"></div>
  166     </div>
  167     <div class="related" role="navigation" aria-label="related navigation">
  168       <h3>Navigation</h3>
  169       <ul>
  170         <li class="right" style="margin-right: 10px">
  171           <a href="genindex.html" title="General Index"
  172              >index</a></li>
  173         <li class="right" >
  174           <a href="relations.html" title="Relations"
  175              >next</a> |</li>
  176         <li class="right" >
  177           <a href="bookmarks.html" title="Bookmarks"
  178              >previous</a> |</li>
  179         <li class="nav-item nav-item-0"><a href="index.html">phpMyAdmin 5.0.1 documentation</a> &#187;</li>
  180           <li class="nav-item nav-item-1"><a href="user.html" >User Guide</a> &#187;</li> 
  181       </ul>
  182     </div>
  183     <div class="footer" role="contentinfo">
  184         &#169; <a href="copyright.html">Copyright</a> 2012 - 2018, The phpMyAdmin devel team.
  185       Created using <a href="http://sphinx-doc.org/">Sphinx</a> 1.4.9.
  186     </div>
  187   </body>
  188 </html>