cdocutils.nodes document q)q}q(U nametypesq}q(Xcreating a new userqNXuser managementqNX4assigning privileges to user for a specific databaseqNXdeleting a userq NXediting an existing userq NuUsubstitution_defsq }q Uparse_messagesq ]qUcurrent_sourceqNU decorationqNUautofootnote_startqKUnameidsq}q(hUcreating-a-new-userqhUuser-managementqhU4assigning-privileges-to-user-for-a-specific-databaseqh Udeleting-a-userqh Uediting-an-existing-userquUchildrenq]qcdocutils.nodes section q)q}q(U rawsourceqUUparentqhUsourceq cdocutils.nodes reprunicode q!XB/var/www/phpmyadmin/release/phpMyAdmin-4.1.14.3/doc/privileges.rstq"q#}q$bUtagnameq%Usectionq&U attributesq'}q((Udupnamesq)]Uclassesq*]Ubackrefsq+]Uidsq,]q-haUnamesq.]q/hauUlineq0KUdocumentq1hh]q2(cdocutils.nodes title q3)q4}q5(hXUser managementq6hhh h#h%Utitleq7h'}q8(h)]h*]h+]h,]h.]uh0Kh1hh]q9cdocutils.nodes Text q:XUser managementq;q<}q=(hh6hh4ubaubcdocutils.nodes paragraph q>)q?}q@(hXUser management is the process of controlling which users are allowed to connect to the MySQL server and what permissions they have on each database. phpMyAdmin does not handle user management, rather it passes the username and password on to MySQL, which then determines whether a user is permitted to perform a particular action. Within phpMyAdmin, administrators have full control over creating users, viewing and editing privileges for existing users, and removing users.qAhhh h#h%U paragraphqBh'}qC(h)]h*]h+]h,]h.]uh0Kh1hh]qDh:XUser management is the process of controlling which users are allowed to connect to the MySQL server and what permissions they have on each database. phpMyAdmin does not handle user management, rather it passes the username and password on to MySQL, which then determines whether a user is permitted to perform a particular action. Within phpMyAdmin, administrators have full control over creating users, viewing and editing privileges for existing users, and removing users.qEqF}qG(hhAhh?ubaubh>)qH}qI(hXWithin phpMyAdmin, user management is controlled via the :guilabel:`Users` link from the main page. Users can be created, edited, and removed.hhh h#h%hBh'}qJ(h)]h*]h+]h,]h.]uh0K h1hh]qK(h:X9Within phpMyAdmin, user management is controlled via the qLqM}qN(hX9Within phpMyAdmin, user management is controlled via the hhHubcdocutils.nodes emphasis qO)qP}qQ(hUh'}qR(UrawtextX:guilabel:`Users`h,]h+]h)]h*]qSXguilabelqTah.]uhhHh]qUh:XUsersqVqW}qX(hUhhPubah%UemphasisqYubh:XD link from the main page. Users can be created, edited, and removed.qZq[}q\(hXD link from the main page. Users can be created, edited, and removed.hhHubeubh)q]}q^(hUhhh h#h%h&h'}q_(h)]h*]h+]h,]q`hah.]qahauh0Kh1hh]qb(h3)qc}qd(hXCreating a new userqehh]h h#h%h7h'}qf(h)]h*]h+]h,]h.]uh0Kh1hh]qgh:XCreating a new userqhqi}qj(hhehhcubaubh>)qk}ql(hXdTo create a new user, click the :guilabel:`Add a new user` link near the bottom of the :guilabel:`Users` page (you must be a "superuser", e.g., user "root"). Use the textboxes and drop-downs to configure the user to your particular needs. You can then select whether to create a database for that user and grant specific global privileges. Once you've created the user (by clicking Go), you can define that user's permissions on a specific database (don't grant global privileges in that case). In general, users do not need any global privileges (other than USAGE), only permissions for their specific database.hh]h h#h%hBh'}qm(h)]h*]h+]h,]h.]uh0Kh1hh]qn(h:X To create a new user, click the qoqp}qq(hX To create a new user, click the hhkubhO)qr}qs(hUh'}qt(UrawtextX:guilabel:`Add a new user`h,]h+]h)]h*]quXguilabelqvah.]uhhkh]qwh:XAdd a new userqxqy}qz(hUhhrubah%hYubh:X link near the bottom of the q{q|}q}(hX link near the bottom of the hhkubhO)q~}q(hUh'}q(UrawtextX:guilabel:`Users`h,]h+]h)]h*]qXguilabelqah.]uhhkh]qh:XUsersqq}q(hUhh~ubah%hYubh:X page (you must be a "superuser", e.g., user "root"). Use the textboxes and drop-downs to configure the user to your particular needs. You can then select whether to create a database for that user and grant specific global privileges. Once you've created the user (by clicking Go), you can define that user's permissions on a specific database (don't grant global privileges in that case). In general, users do not need any global privileges (other than USAGE), only permissions for their specific database.qq}q(hX page (you must be a "superuser", e.g., user "root"). Use the textboxes and drop-downs to configure the user to your particular needs. You can then select whether to create a database for that user and grant specific global privileges. Once you've created the user (by clicking Go), you can define that user's permissions on a specific database (don't grant global privileges in that case). In general, users do not need any global privileges (other than USAGE), only permissions for their specific database.hhkubeubeubh)q}q(hUhhh h#h%h&h'}q(h)]h*]h+]h,]qhah.]qh auh0Kh1hh]q(h3)q}q(hXEditing an existing userqhhh h#h%h7h'}q(h)]h*]h+]h,]h.]uh0Kh1hh]qh:XEditing an existing userqq}q(hhhhubaubh>)q}q(hXTo edit an existing user, simply click the pencil icon to the right of that user in the :guilabel:`Users` page. You can then edit their global- and database-specific privileges, change their password, or even copy those privileges to a new user.hhh h#h%hBh'}q(h)]h*]h+]h,]h.]uh0Kh1hh]q(h:XXTo edit an existing user, simply click the pencil icon to the right of that user in the qq}q(hXXTo edit an existing user, simply click the pencil icon to the right of that user in the hhubhO)q}q(hUh'}q(UrawtextX:guilabel:`Users`h,]h+]h)]h*]qXguilabelqah.]uhhh]qh:XUsersqq}q(hUhhubah%hYubh:X page. You can then edit their global- and database-specific privileges, change their password, or even copy those privileges to a new user.qq}q(hX page. You can then edit their global- and database-specific privileges, change their password, or even copy those privileges to a new user.hhubeubeubh)q}q(hUhhh h#h%h&h'}q(h)]h*]h+]h,]qhah.]qh auh0K$h1hh]q(h3)q}q(hXDeleting a userqhhh h#h%h7h'}q(h)]h*]h+]h,]h.]uh0K$h1hh]qh:XDeleting a userqq}q(hhhhubaubh>)q}q(hXFrom the :guilabel:`Users` page, check the checkbox for the user you wish to remove, select whether or not to also remove any databases of the same name (if they exist), and click Go.hhh h#h%hBh'}q(h)]h*]h+]h,]h.]uh0K&h1hh]q(h:X From the qq}q(hX From the hhubhO)q}q(hUh'}q(UrawtextX:guilabel:`Users`h,]h+]h)]h*]qXguilabelqah.]uhhh]qh:XUsersqƅq}q(hUhhubah%hYubh:X page, check the checkbox for the user you wish to remove, select whether or not to also remove any databases of the same name (if they exist), and click Go.qɅq}q(hX page, check the checkbox for the user you wish to remove, select whether or not to also remove any databases of the same name (if they exist), and click Go.hhubeubeubh)q}q(hUhhh h#h%h&h'}q(h)]h*]h+]h,]qhah.]qhauh0K+h1hh]q(h3)q}q(hX4Assigning privileges to user for a specific databaseqhhh h#h%h7h'}q(h)]h*]h+]h,]h.]uh0K+h1hh]qh:X4Assigning privileges to user for a specific databaseqׅq}q(hhhhubaubh>)q}q(hXUsers are assigned to databases by editing the user record (from the :guilabel:`Users` link on the home page) not from within the :guilabel:`Users` link under the table. If you are creating a user specifically for a given table you will have to create the user first (with no global privileges) and then go back and edit that user to add the table and privileges for the individual table.hhh h#h%hBh'}q(h)]h*]h+]h,]h.]uh0K-h1hh]q(h:XEUsers are assigned to databases by editing the user record (from the qޅq}q(hXEUsers are assigned to databases by editing the user record (from the hhubhO)q}q(hUh'}q(UrawtextX:guilabel:`Users`h,]h+]h)]h*]qXguilabelqah.]uhhh]qh:XUsersq煁q}q(hUhhubah%hYubh:X, link on the home page) not from within the qꅁq}q(hX, link on the home page) not from within the hhubhO)q}q(hUh'}q(UrawtextX:guilabel:`Users`h,]h+]h)]h*]qXguilabelqah.]uhhh]qh:XUsersqq}q(hUhhubah%hYubh:X link under the table. If you are creating a user specifically for a given table you will have to create the user first (with no global privileges) and then go back and edit that user to add the table and privileges for the individual table.qq}q(hX link under the table. If you are creating a user specifically for a given table you will have to create the user first (with no global privileges) and then go back and edit that user to add the table and privileges for the individual table.hhubeubeubeubahUU transformerqNU footnote_refsq}qUrefnamesq}qUsymbol_footnotesq]qUautofootnote_refsr]rUsymbol_footnote_refsr]rU citationsr]rh1hU current_linerNUtransform_messagesr]rUreporterr NUid_startr KU autofootnotesr ]r U citation_refsr }rUindirect_targetsr]rUsettingsr(cdocutils.frontend Values ror}r(Ufootnote_backlinksrKUrecord_dependenciesrNU rfc_base_urlrUhttp://tools.ietf.org/html/rU tracebackrKUpep_referencesrNUstrip_commentsrNU toc_backlinksrUentryrU language_coderUenrU datestampr NU report_levelr!KU _destinationr"NU halt_levelr#KU strip_classesr$Nh7NUerror_encoding_error_handlerr%Ubackslashreplacer&Udebugr'NUembed_stylesheetr(Uoutput_encoding_error_handlerr)Ustrictr*U sectnum_xformr+KUdump_transformsr,NU docinfo_xformr-KUwarning_streamr.NUpep_file_url_templater/Upep-%04dr0Uexit_status_levelr1KUconfigr2NUstrict_visitorr3NUcloak_email_addressesr4Utrim_footnote_reference_spacer5Uenvr6NUdump_pseudo_xmlr7NUexpose_internalsr8NUsectsubtitle_xformr9U source_linkr:NUrfc_referencesr;NUoutput_encodingr<Uutf-8r=U source_urlr>NUinput_encodingr?U utf-8-sigr@U_disable_configrANU id_prefixrBUU tab_widthrCKUerror_encodingrDUANSI_X3.4-1968rEU_sourcerFUB/var/www/phpmyadmin/release/phpMyAdmin-4.1.14.3/doc/privileges.rstrGUgettext_compactrHU generatorrINUdump_internalsrJNU pep_base_urlrKUhttp://www.python.org/dev/peps/rLUinput_encoding_error_handlerrMj*Uauto_id_prefixrNUidrOUdoctitle_xformrPUstrip_elements_with_classesrQNU _config_filesrR]Ufile_insertion_enabledrSKU raw_enabledrTKU dump_settingsrUNubUsymbol_footnote_startrVKUidsrW}rX(hh]hhhhhhhhuUsubstitution_namesrY}rZh%h1h'}r[(h)]h,]h+]Usourceh#h*]h.]uU footnotesr\]r]Urefidsr^}r_ub.