phpmyadmin/doc/html/privileges.html

   1
   2
   3 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
   4   "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
   5
   6
   7 <html xmlns="http://www.w3.org/1999/xhtml">
   8   <head>
   9     <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  10
  11     <title>User management &mdash; phpMyAdmin 4.0.4 documentation</title>
  12
  13     <link rel="stylesheet" href="_static/default.css" type="text/css" />
  14     <link rel="stylesheet" href="_static/pygments.css" type="text/css" />
  15
  16     <script type="text/javascript">
  17       var DOCUMENTATION_OPTIONS = {
  18         URL_ROOT:    '',
  19         VERSION:     '4.0.4',
  20         COLLAPSE_INDEX: false,
  21         FILE_SUFFIX: '.html',
  22         HAS_SOURCE:  true
  23       };
  24     </script>
  25     <script type="text/javascript" src="_static/jquery.js"></script>
  26     <script type="text/javascript" src="_static/underscore.js"></script>
  27     <script type="text/javascript" src="_static/doctools.js"></script>
  28     <link rel="copyright" title="Copyright" href="copyright.html" />
  29     <link rel="top" title="phpMyAdmin 4.0.4 documentation" href="index.html" />
  30     <link rel="up" title="User Guide" href="user.html" />
  31     <link rel="next" title="Other sources of information" href="other.html" />
  32     <link rel="prev" title="Transformations" href="transformations.html" />
  33   </head>
  34   <body>
  35     <div class="related">
  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="other.html" title="Other sources of information"
  43              accesskey="N">next</a> |</li>
  44         <li class="right" >
  45           <a href="transformations.html" title="Transformations"
  46              accesskey="P">previous</a> |</li>
  47         <li><a href="index.html">phpMyAdmin 4.0.4 documentation</a> &raquo;</li>
  48           <li><a href="user.html" accesskey="U">User Guide</a> &raquo;</li>
  49       </ul>
  50     </div>
  51
  52     <div class="document">
  53       <div class="documentwrapper">
  54         <div class="bodywrapper">
  55           <div class="body">
  56
  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 <em class="guilabel">Users</em> 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 <em class="guilabel">Add a new user</em> link near the bottom
  71 of the <em class="guilabel">Users</em> 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 <em class="guilabel">Users</em> 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 <em class="guilabel">Users</em> 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 <em class="guilabel">Users</em> link on the home page) not from within the <em class="guilabel">Users</em>
  96 link under the table. 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>
 102
 103
 104           </div>
 105         </div>
 106       </div>
 107       <div class="sphinxsidebar">
 108         <div class="sphinxsidebarwrapper">
 109   <h3><a href="index.html">Table Of Contents</a></h3>
 110   <ul>
 111 <li><a class="reference internal" href="#">User management</a><ul>
 112 <li><a class="reference internal" href="#creating-a-new-user">Creating a new user</a></li>
 113 <li><a class="reference internal" href="#editing-an-existing-user">Editing an existing user</a></li>
 114 <li><a class="reference internal" href="#deleting-a-user">Deleting a user</a></li>
 115 <li><a class="reference internal" href="#assigning-privileges-to-user-for-a-specific-database">Assigning privileges to user for a specific database</a></li>
 116 </ul>
 117 </li>
 118 </ul>
 119
 120   <h4>Previous topic</h4>
 121   <p class="topless"><a href="transformations.html"
 122                         title="previous chapter">Transformations</a></p>
 123   <h4>Next topic</h4>
 124   <p class="topless"><a href="other.html"
 125                         title="next chapter">Other sources of information</a></p>
 126   <h3>This Page</h3>
 127   <ul class="this-page-menu">
 128     <li><a href="_sources/privileges.txt"
 129            rel="nofollow">Show Source</a></li>
 130   </ul>
 131 <div id="searchbox" style="display: none">
 132   <h3>Quick search</h3>
 133     <form class="search" action="search.html" method="get">
 134       <input type="text" name="q" />
 135       <input type="submit" value="Go" />
 136       <input type="hidden" name="check_keywords" value="yes" />
 137       <input type="hidden" name="area" value="default" />
 138     </form>
 139     <p class="searchtip" style="font-size: 90%">
 140     Enter search terms or a module, class or function name.
 141     </p>
 142 </div>
 143 <script type="text/javascript">$('#searchbox').show(0);</script>
 144         </div>
 145       </div>
 146       <div class="clearer"></div>
 147     </div>
 148     <div class="related">
 149       <h3>Navigation</h3>
 150       <ul>
 151         <li class="right" style="margin-right: 10px">
 152           <a href="genindex.html" title="General Index"
 153              >index</a></li>
 154         <li class="right" >
 155           <a href="other.html" title="Other sources of information"
 156              >next</a> |</li>
 157         <li class="right" >
 158           <a href="transformations.html" title="Transformations"
 159              >previous</a> |</li>
 160         <li><a href="index.html">phpMyAdmin 4.0.4 documentation</a> &raquo;</li>
 161           <li><a href="user.html" >User Guide</a> &raquo;</li>
 162       </ul>
 163     </div>
 164     <div class="footer">
 165         &copy; <a href="copyright.html">Copyright</a> 2012 - 2013, The phpMyAdmin devel team.
 166       Created using <a href="http://sphinx.pocoo.org/">Sphinx</a> 1.1.3.
 167     </div>
 168   </body>
 169 </html>