€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!XT/usr/local/apache2/htdocs/phpmyadmin/release/phpMyAdmin-4.0.10.10/doc/privileges.rstq"…q#}q$bUtagnameq%Usectionq&U attributesq'}q((Udupnamesq)]q*Uclassesq+]q,Ubackrefsq-]q.Uidsq/]q0haUnamesq1]q2hauUlineq3KUdocumentq4hh]q5(cdocutils.nodes title q6)q7}q8(hXUser managementq9hhh h#h%Utitleq:h'}q;(h)]qh/]q?h1]q@uh3Kh4hh]qAcdocutils.nodes Text qBXUser managementqC…qD}qE(hh9hh7ubaubcdocutils.nodes paragraph qF)qG}qH(hXÛUser 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.qIhhh h#h%U paragraphqJh'}qK(h)]qLh+]qMh-]qNh/]qOh1]qPuh3Kh4hh]qQhBXÛUser 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.qR…qS}qT(hhIhhGubaubhF)qU}qV(hXŽWithin phpMyAdmin, user management is controlled via the :guilabel:`Users` link from the main page. Users can be created, edited, and removed.qWhhh h#h%hJh'}qX(h)]qYh+]qZh-]q[h/]q\h1]q]uh3K h4hh]q^(hBX9Within phpMyAdmin, user management is controlled via the q_…q`}qa(hX9Within phpMyAdmin, user management is controlled via the qbhhUubcdocutils.nodes emphasis qc)qd}qe(hUh'}qf(UrawtextqgX:guilabel:`Users`qhh/]qih-]qjh)]qkh+]qlXguilabelqmah1]qnuhhUh]qohBXUsersqp…qq}qr(hUhhdubah%UemphasisqsubhBXD link from the main page. Users can be created, edited, and removed.qt…qu}qv(hXD link from the main page. Users can be created, edited, and removed.qwhhUubeubh)qx}qy(hUhhh h#h%h&h'}qz(h)]q{h+]q|h-]q}h/]q~hah1]qhauh3Kh4hh]q€(h6)q}q‚(hXCreating a new userqƒhhxh h#h%h:h'}q„(h)]q…h+]q†h-]q‡h/]qˆh1]q‰uh3Kh4hh]qŠhBXCreating a new userq‹…qŒ}q(hhƒhhubaubhF)qŽ}q(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.qhhxh h#h%hJh'}q‘(h)]q’h+]q“h-]q”h/]q•h1]q–uh3Kh4hh]q—(hBX To create a new user, click the q˜…q™}qš(hX To create a new user, click the q›hhŽubhc)qœ}q(hUh'}qž(UrawtextqŸX:guilabel:`Add a new user`q h/]q¡h-]q¢h)]q£h+]q¤Xguilabelq¥ah1]q¦uhhŽh]q§hBXAdd a new userq¨…q©}qª(hUhhœubah%hsubhBX link near the bottom of the q«…q¬}q­(hX link near the bottom of the q®hhŽubhc)q¯}q°(hUh'}q±(Urawtextq²X:guilabel:`Users`q³h/]q´h-]qµh)]q¶h+]q·Xguilabelq¸ah1]q¹uhhŽh]qºhBXUsersq»…q¼}q½(hUhh¯ubah%hsubhBXü 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.q¾…q¿}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.qÁhhŽubeubeubh)qÂ}qÃ(hUhhh h#h%h&h'}qÄ(h)]qÅh+]qÆh-]qÇh/]qÈhah1]qÉh auh3Kh4hh]qÊ(h6)qË}qÌ(hXEditing an existing userqÍhhÂh h#h%h:h'}qÎ(h)]qÏh+]qÐh-]qÑh/]qÒh1]qÓuh3Kh4hh]qÔhBXEditing an existing userqÕ…qÖ}q×(hhÍhhËubaubhF)qØ}qÙ(hXõTo 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.qÚhhÂh h#h%hJh'}qÛ(h)]qÜh+]qÝh-]qÞh/]qßh1]qàuh3Kh4hh]qá(hBXXTo edit an existing user, simply click the pencil icon to the right of that user in the qâ…qã}qä(hXXTo edit an existing user, simply click the pencil icon to the right of that user in the qåhhØubhc)qæ}qç(hUh'}qè(UrawtextqéX:guilabel:`Users`qêh/]qëh-]qìh)]qíh+]qîXguilabelqïah1]qðuhhØh]qñhBXUsersqò…qó}qô(hUhhæubah%hsubhBXŒ page. You can then edit their global- and database-specific privileges, change their password, or even copy those privileges to a new user.qõ…qö}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.qøhhØubeubeubh)qù}qú(hUhhh h#h%h&h'}qû(h)]qüh+]qýh-]qþh/]qÿhah1]rh auh3K$h4hh]r(h6)r}r(hXDeleting a userrhhùh h#h%h:h'}r(h)]rh+]rh-]rh/]r h1]r uh3K$h4hh]r hBXDeleting a userr …r }r(hjhjubaubhF)r}r(hX·From 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.rhhùh h#h%hJh'}r(h)]rh+]rh-]rh/]rh1]ruh3K&h4hh]r(hBX From the r…r}r(hX From the rhjubhc)r}r(hUh'}r(Urawtextr X:guilabel:`Users`r!h/]r"h-]r#h)]r$h+]r%Xguilabelr&ah1]r'uhjh]r(hBXUsersr)…r*}r+(hUhjubah%hsubhBX 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.r,…r-}r.(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.r/hjubeubeubh)r0}r1(hUhhh h#h%h&h'}r2(h)]r3h+]r4h-]r5h/]r6hah1]r7hauh3K+h4hh]r8(h6)r9}r:(hX4Assigning privileges to user for a specific databaser;hj0h h#h%h:h'}r<(h)]r=h+]r>h-]r?h/]r@h1]rAuh3K+h4hh]rBhBX4Assigning privileges to user for a specific databaserC…rD}rE(hj;hj9ubaubhF)rF}rG(hX„Users 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.rHhj0h h#h%hJh'}rI(h)]rJh+]rKh-]rLh/]rMh1]rNuh3K-h4hh]rO(hBXEUsers are assigned to databases by editing the user record (from the rP…rQ}rR(hXEUsers are assigned to databases by editing the user record (from the rShjFubhc)rT}rU(hUh'}rV(UrawtextrWX:guilabel:`Users`rXh/]rYh-]rZh)]r[h+]r\Xguilabelr]ah1]r^uhjFh]r_hBXUsersr`…ra}rb(hUhjTubah%hsubhBX, link on the home page) not from within the rc…rd}re(hX, link on the home page) not from within the rfhjFubhc)rg}rh(hUh'}ri(UrawtextrjX:guilabel:`Users`rkh/]rlh-]rmh)]rnh+]roXguilabelrpah1]rquhjFh]rrhBXUsersrs…rt}ru(hUhjgubah%hsubhBXñ 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.rv…rw}rx(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.ryhjFubeubeubeubahUU transformerrzNU footnote_refsr{}r|Urefnamesr}}r~Usymbol_footnotesr]r€Uautofootnote_refsr]r‚Usymbol_footnote_refsrƒ]r„U citationsr…]r†h4hU current_liner‡NUtransform_messagesrˆ]r‰UreporterrŠNUid_startr‹KU autofootnotesrŒ]rU citation_refsrŽ}rUindirect_targetsr]r‘Usettingsr’(cdocutils.frontend Values r“or”}r•(Ufootnote_backlinksr–KUrecord_dependenciesr—NU rfc_base_urlr˜Uhttp://tools.ietf.org/html/r™U tracebackršˆUpep_referencesr›NUstrip_commentsrœNU toc_backlinksrUentryržU language_coderŸUenr U datestampr¡NU report_levelr¢KU _destinationr£NU halt_levelr¤KU strip_classesr¥Nh:NUerror_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-%04dr±Uexit_status_levelr²KUconfigr³NUstrict_visitorr´NUcloak_email_addressesrµˆUtrim_footnote_reference_spacer¶‰Uenvr·NUdump_pseudo_xmlr¸NUexpose_internalsr¹NUsectsubtitle_xformrº‰U source_linkr»NUrfc_referencesr¼NUoutput_encodingr½Uutf-8r¾U source_urlr¿NUinput_encodingrÀU utf-8-sigrÁU_disable_configrÂNU id_prefixrÃUU tab_widthrÄKUerror_encodingrÅUANSI_X3.4-1968rÆU_sourcerÇUT/usr/local/apache2/htdocs/phpmyadmin/release/phpMyAdmin-4.0.10.10/doc/privileges.rstrÈUgettext_compactrɈU generatorrÊNUdump_internalsrËNU smart_quotesr̉U pep_base_urlrÍUhttp://www.python.org/dev/peps/rÎUsyntax_highlightrÏUlongrÐUinput_encoding_error_handlerrÑj«Uauto_id_prefixrÒUidrÓUdoctitle_xformrÔ‰Ustrip_elements_with_classesrÕNU _config_filesrÖ]r×Ufile_insertion_enabledrØKU raw_enabledrÙKU dump_settingsrÚNubUsymbol_footnote_startrÛKUidsrÜ}rÝ(hhxhhhhùhhÂhj0uUsubstitution_namesrÞ}rßh%h4h'}rà(h)]ráh/]râh-]rãUsourceräh#h+]råh1]ræuU footnotesrç]rèUrefidsré}rêub.