| Server IP : 180.180.241.3 / Your IP : 216.73.216.252 Web Server : Microsoft-IIS/7.5 System : Windows NT NETWORK-NHRC 6.1 build 7601 (Windows Server 2008 R2 Standard Edition Service Pack 1) i586 User : IUSR ( 0) PHP Version : 5.3.28 Disable Function : NONE MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/AppServ/www/app/webroot/phpMyAdmin/a/doc/doctrees/ |
Upload File : |
€cdocutils.nodes
document
q)q}q(U nametypesq}q(X creating a new userqNX user managementqNX4 assigning privileges to user for a specific databaseqNX deleting a userq NX editing 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 rawsourceq U Uparentq hUsourceq cdocutils.nodes
reprunicode
q!XD /opt/pma-git/phpmyadmin/release/phpMyAdmin-4.0.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(h X User managementq9h h h h#h%Utitleq:h'}q;(h)]q<h+]q=h-]q>h/]q?h1]q@uh3Kh4hh]qAcdocutils.nodes
Text
qBX User managementqC…qD}qE(h h9h h7ubaubcdocutils.nodes
paragraph
qF)qG}qH(h XÛ 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.qIh h h 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(h hIh hGubaubhF)qU}qV(h XŽ Within phpMyAdmin, user management is controlled via the :guilabel:`Users` link
from the main page. Users can be created, edited, and removed.qWh h h h#h%hJh'}qX(h)]qYh+]qZh-]q[h/]q\h1]q]uh3K h4hh]q^(hBX9 Within phpMyAdmin, user management is controlled via the q_…q`}qa(h X9 Within phpMyAdmin, user management is controlled via the qbh hUubcdocutils.nodes
emphasis
qc)qd}qe(h U h'}qf(UrawtextqgX :guilabel:`Users`qhh/]qih-]qjh)]qkh+]qlX guilabelqmah1]qnuh hUh]qohBX Usersqp…qq}qr(h U h hdubah%UemphasisqsubhBXD link
from the main page. Users can be created, edited, and removed.qt…qu}qv(h XD link
from the main page. Users can be created, edited, and removed.qwh hUubeubh)qx}qy(h U h h h h#h%h&h'}qz(h)]q{h+]q|h-]q}h/]q~hah1]qhauh3Kh4hh]q€(h6)q}q‚(h X Creating a new userqƒh hxh h#h%h:h'}q„(h)]q…h+]q†h-]q‡h/]qˆh1]q‰uh3Kh4hh]qŠhBX Creating a new userq‹…qŒ}q(h hƒh hubaubhF)qŽ}q(h Xd To 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.qh hxh 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š(h X To create a new user, click the q›h hŽubhc)qœ}q(h U h'}qž(UrawtextqŸX :guilabel:`Add a new user`q h/]q¡h-]q¢h)]q£h+]q¤X guilabelq¥ah1]q¦uh hŽh]q§hBX Add a new userq¨…q©}qª(h U h hœubah%hsubhBX link near the bottom
of the q«…q¬}q(h X link near the bottom
of the q®h hŽubhc)q¯}q°(h U h'}q±(Urawtextq²X :guilabel:`Users`q³h/]q´h-]qµh)]q¶h+]q·X guilabelq¸ah1]q¹uh hŽh]qºhBX Usersq»…q¼}q½(h U h h¯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À(h 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.qÁh hŽubeubeubh)qÂ}qÃ(h U h h h h#h%h&h'}qÄ(h)]qÅh+]qÆh-]qÇh/]qÈhah1]qÉh
auh3K h4hh]qÊ(h6)qË}qÌ(h X Editing an existing userqÍh hÂh h#h%h:h'}qÎ(h)]qÏh+]qÐh-]qÑh/]qÒh1]qÓuh3K h4hh]qÔhBX Editing an existing userqÕ…qÖ}q×(h hÍh hËubaubhF)qØ}qÙ(h Xõ 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Úh hÂh h#h%hJh'}qÛ(h)]qÜh+]qÝh-]qÞh/]qßh1]qàuh3K h4hh]qá(hBXX To edit an existing user, simply click the pencil icon to the right of that
user in the qâ…qã}qä(h XX To edit an existing user, simply click the pencil icon to the right of that
user in the qåh hØubhc)qæ}qç(h U h'}qè(UrawtextqéX :guilabel:`Users`qêh/]qëh-]qìh)]qíh+]qîX guilabelqïah1]qðuh hØh]qñhBX Usersqò…qó}qô(h U h hæ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÷(h XŒ page. You can then edit their global- and
database-specific privileges, change their password, or even copy those
privileges to a new user.qøh hØubeubeubh)qù}qú(h U h h h h#h%h&h'}qû(h)]qüh+]qýh-]qþh/]qÿhah1]r h auh3K$h4hh]r (h6)r }r (h X Deleting a userr h hùh h#h%h:h'}r (h)]r h+]r h-]r h/]r h1]r
uh3K$h4hh]r hBX Deleting a userr …r
}r (h j h j ubaubhF)r }r (h X· 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.r h hùh h#h%hJh'}r (h)]r h+]r h-]r h/]r h1]r uh3K&h4hh]r (hBX From the r …r }r (h X From the r h j ubhc)r }r (h U h'}r (Urawtextr X :guilabel:`Users`r! h/]r" h-]r# h)]r$ h+]r% X guilabelr& ah1]r' uh j h]r( hBX Usersr) …r* }r+ (h U h j ubah%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. (h 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.r/ h j ubeubeubh)r0 }r1 (h U h h h h#h%h&h'}r2 (h)]r3 h+]r4 h-]r5 h/]r6 hah1]r7 hauh3K+h4hh]r8 (h6)r9 }r: (h X4 Assigning privileges to user for a specific databaser; h j0 h h#h%h:h'}r< (h)]r= h+]r> h-]r? h/]r@ h1]rA uh3K+h4hh]rB hBX4 Assigning privileges to user for a specific databaserC …rD }rE (h j; h j9 ubaubhF)rF }rG (h X„ 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.rH h j0 h h#h%hJh'}rI (h)]rJ h+]rK h-]rL h/]rM h1]rN uh3K-h4hh]rO (hBXE Users are assigned to databases by editing the user record (from the
rP …rQ }rR (h XE Users are assigned to databases by editing the user record (from the
rS h jF ubhc)rT }rU (h U h'}rV (UrawtextrW X :guilabel:`Users`rX h/]rY h-]rZ h)]r[ h+]r\ X guilabelr] ah1]r^ uh jF h]r_ hBX Usersr` …ra }rb (h U h jT ubah%hsubhBX, link on the home page) not from within the rc …rd }re (h X, link on the home page) not from within the rf h jF ubhc)rg }rh (h U h'}ri (Urawtextrj X :guilabel:`Users`rk h/]rl h-]rm h)]rn h+]ro X guilabelrp ah1]rq uh jF h]rr hBX Usersrs …rt }ru (h U h jg ubah%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 (h 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.ry h jF ubeubeubeubah U U transformerrz NU
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Π]r U
citation_refsrŽ }r Uindirect_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_backlinksr Uentryrž U
language_coderŸ Uenr U datestampr¡ NU report_levelr¢ KU _destinationr£ NU
halt_levelr¤ KU
strip_classesr¥ Nh:NU error_encoding_error_handlerr¦ Ubackslashreplacer§ Udebugr¨ NUembed_stylesheetr© ‰U output_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µ ˆU trim_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à U U tab_widthrÄ KUerror_encodingrÅ UANSI_X3.4-1968rÆ U_sourcerÇ UD/opt/pma-git/phpmyadmin/release/phpMyAdmin-4.0.10/doc/privileges.rstrÈ Ugettext_compactrÉ ˆU generatorrÊ NUdump_internalsrË NU smart_quotesrÌ ‰U pep_base_urlrÍ U http://www.python.org/dev/peps/rÎ Usyntax_highlightrÏ UlongrÐ U input_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Û K UidsrÜ }rÝ (hhxhh hhùhhÂhj0 uUsubstitution_namesrÞ }rß h%h4h'}rà (h)]rá h/]râ h-]rã Usourcerä h#h+]rå h1]ræ uU footnotesrç ]rè Urefidsré }rê ub.