| 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:/Program Files (x86)/MySQL/MySQL Workbench 6.1 CE/modules/ |
Upload File : |
,2Sc @ s d d l m Z m Z d d l m Z d d l Z d d l m Z d e f d YZ d Z
d Z d Z d
Z
d Z d Z d
Z d Z d Z d Z d Z d Z d Z d Z d Z d Z d Z d Z d Z d Z d Z d Z d Z d Z! d Z" d Z# d! Z$ d" Z% i d# d$ f d% 6d& d' f d( 6d) d* f d+ 6d, d- f d. 6d/ d0 f d1 6d2 d3 f d4 6d5 d6 f d7 6d8 d9 f d: 6d; d< f d= 6d> d? f d@ 6dA dB f dC 6dD dE f dF 6dG dH f dI 6dJ dK f dL 6d dM f dN 6dO dP f dQ 6dR dS f dT 6dU dV f dW 6dX dY f dZ 6d[ d\ f d] 6d^ d_ f d` 6da db f dc 6dd de f df 6dg dh f di 6dj dk f dl 6dm dn f do 6dp dq f dr 6ds dt f du 6dv dw f dx 6dy dz f d{ 6d| dz f d} 6Z& e' d~ e& j( D Z) i d d d d g d d d d g d d f d{ 6d d d d d d d g d d d d g d d f d} 6Z* d d e& j+ f d d dr d7 dN d: dQ g f d d d7 dQ g f d d do d7 g f d d dC do d7 dN d} g f d d d= g f d d d1 d4 dC dr dL d. dI d( d% d+ dT dW du dc df di dl dN g f d d d1 dL dI du dc df di dl dN d{ g
f d d d` d] dQ g f d d dr d% dW dN g f g
Z, d Z- d Z. d Z/ d e0 f d YZ1 d e0 f d YZ2 d e0 f d YZ3 d e0 f d YZ4 d S( i( t
QueryErrort escape_sql_string( t PermissionDeniedErrorN( t log_errort WBSecurityValidationErrorc B s e Z RS( ( t __name__t
__module__( ( ( sS C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_security_be.pyR s s/ SELECT User, Host FROM mysql.user ORDER BY Users SHOW DATABASESs SELECT d.User, d.Host, d.Db FROM mysql.db AS d LEFT JOIN mysql.user AS u ON d.User = u.user AND d.Host = u.Host WHERE u.User IS NULLs SELECT t.User, t.Host, t.Db, t.Table_name FROM mysql.tables_priv AS t LEFT JOIN mysql.user AS u ON t.User = u.user AND t.Host = u.Host WHERE u.User IS NULLs SELECT c.User, c.Host, c.Db, c.Table_name, c.Column_name FROM mysql.columns_priv AS c LEFT JOIN mysql.user AS u ON c.User = u.user AND c.Host = u.Host WHERE u.User IS NULLs SELECT p.User, p.Host, p.Db, p.Routine_name, p.Routine_type FROM mysql.procs_priv AS p LEFT JOIN mysql.user AS u ON p.User = u.user AND p.Host = u.Host WHERE u.User IS NULLsB DELETE FROM mysql.db WHERE User = '%(user)s' AND Host = '%(host)s'sK DELETE FROM mysql.tables_priv WHERE User = '%(user)s' AND Host = '%(host)s'sL DELETE FROM mysql.columns_priv WHERE User = '%(user)s' AND Host = '%(host)s'sJ DELETE FROM mysql.procs_priv WHERE User = '%(user)s' AND Host = '%(host)s'sV SELECT * FROM mysql.user WHERE User='%(user)s' AND Host='%(host)s' ORDER BY User, HostsL SELECT * FROM mysql.db WHERE User='%(user)s' AND Host='%(host)s' ORDER BY DbsX SELECT * FROM mysql.tables_priv WHERE Host='%(host)s' AND User='%(user)s' AND Db='mysql's> CREATE USER '%(user)s'@'%(host)s' IDENTIFIED BY '%(password)s'sM CREATE USER '%(user)s' IDENTIFIED WITH '%(auth_plugin)s' AS '%(auth_string)s's8 CREATE USER '%(user)s' IDENTIFIED WITH '%(auth_plugin)s's7 GRANT %(granted_privs)s ON *.* TO '%(user)s'@'%(host)s's: REVOKE %(revoked_privs)s ON *.* FROM '%(user)s'@'%(host)s's: GRANT USAGE ON *.* TO '%(user)s'@'%(host)s' WITH %(limit)ssB RENAME USER '%(old_user)s'@'%(old_host)s' TO '%(user)s'@'%(host)s'sA SET PASSWORD FOR '%(user)s'@'%(host)s' = PASSWORD('%(password)s')s+ SET PASSWORD FOR '%(user)s'@'%(host)s' = ''sA REVOKE %(revoked_privs)s ON `%(db)s`.* FROM '%(user)s'@'%(host)s's> GRANT %(granted_privs)s ON `%(db)s`.* TO '%(user)s'@'%(host)s's0 ALTER USER '%(user)s'@'%(host)s' PASSWORD EXPIREs FLUSH PRIVILEGESs> REVOKE ALL PRIVILEGES, GRANT OPTION FROM '%(user)s'@'%(host)s's DROP USER '%(user)s'@'%(host)s't SELECTs The SELECT privilege enables you to select rows from tables in a database.
SELECT statements require the SELECT privilege only if they actually retrieve rows from a table. Some SELECT statements do not access tables and can be executed without permission for any databaset Select_privt INSERTs The INSERT privilege enables rows to be inserted into tables in a database.
INSERT is also required for the ANALYZE TABLE, OPTIMIZE TABLE, and REPAIR TABLE table-maintenance statements.t Insert_privt UPDATEsH The UPDATE privilege enables rows to be updated in tables in a database.t Update_privt DELETEsJ The DELETE privilege enables rows to be deleted from tables in a database.t Delete_privt CREATEsB The CREATE privilege enables creation of new databases and tables.t Create_privt DROPs The DROP privilege enables you to drop (remove) existing databases, tables, and views.
Beginning with MySQL 5.1.10, the DROP privilege is also required in order to use the statement ALTER TABLE ... DROP PARTITION on a partitioned table.
Beginning with MySQL 5.1.16, the DROP privilege is required for TRUNCATE TABLE (before that, TRUNCATE TABLE requires the DELETE privilege).
If you grant the DROP privilege for the mysql database to a user, that user can drop the database in which the MySQL access privileges are stored.t Drop_privt RELOADs The RELOAD privilege enables use of the FLUSH statement.
It also enables mysqladmin commands that are equivalent to FLUSH operations:
flush-hosts, flush-logs, flush-privileges, flush-status, flush-tables, flush-threads, refresh, and reload.t Reload_privt SHUTDOWNso The SHUTDOWN privilege enables use of the mysqladmin shutdown command. There is no corresponding SQL statement.t
Shutdown_privt PROCESSsG The PROCESS privilege pertains to display of information about the threads executing within the server
(that is, information about the statements being executed by sessions).
The privilege enables use of SHOW PROCESSLIST or mysqladmin processlist to see threads belonging to other accounts; you can always see your own threads.t Process_privt FILEsk The FILE privilege gives you permission to read and write files on the server host using the
LOAD DATA INFILE and SELECT ... INTO OUTFILE statements and the LOAD_FILE() function. A user who has the FILE privilege
can read any file on the server host that is either world-readable or readable by the MySQL server.
(This implies the user can read any file in any database directory, because the server can access any of those files.)
The FILE privilege also enables the user to create new files in any directory where the MySQL server has write access.
As a security measure, the server will not overwrite existing files.t File_privs GRANT OPTIONs The GRANT OPTION privilege enables you to give to other users or remove from other users those privileges that you yourself possess.t
Grant_privt
REFERENCESs- The REFERENCES privilege currently is unused.t References_privt INDEXs The INDEX privilege enables you to create or drop (remove) indexes.
INDEX applies to existing tables. If you have the CREATE privilege for a table, you can include index definitions in the CREATE TABLE statement.t
Index_privt ALTERs The ALTER privilege enables use of ALTER TABLE to change the structure of or rename tables.
(ALTER TABLE also requires the INSERT and CREATE privileges.)t
Alter_privss The SHOW DATABASES privilege enables the account to see database names by issuing the
SHOW DATABASE statement. Accounts that do not have this privilege see only databases for which
they have some privileges, and cannot use the statement at all if the server was started with
the --skip-show-database option. Note that any global privilege is a privilege for the database.t Show_db_privt SUPERs8 The SUPER privilege enables an account to use CHANGE MASTER TO, KILL or
mysqladmin kill to kill threads belonging to other accounts (you can always kill your own threads),
PURGE BINARY LOGS, configuration changes via SET GLOBAL to modify global system variables,
the mysqladmin debug command, enabling or disabling logging, performing updates even if the read_only
system variable is enabled, starting and stopping replication on slave servers, and allows you to
connect (once) even if the connection limit controlled by the max_connections system variable is reached.t
Super_privs CREATE TEMPORARY TABLESsj The CREATE TEMPORARY TABLES privilege enables the use of the keyword TEMPORARY in CREATE TABLE statements.t Create_tmp_table_privs LOCK TABLESs The LOCK TABLES privilege enables the use of explicit LOCK TABLES statements to lock tables for which you have the SELECT privilege.
This includes the use of write locks, which prevents other sessions from reading the locked table.t Lock_tables_privt EXECUTEsX The EXECUTE privilege is required to execute stored routines (procedures and functions).t Execute_privs REPLICATION SLAVEs The REPLICATION SLAVE privilege should be granted to accounts that are used
by slave servers to connect to the current server as their master.
Without this privilege, the slave cannot request updates that have been made to databases on the master server.t Repl_slave_privs REPLICATION CLIENTs\ The REPLICATION CLIENT privilege enables the use of SHOW MASTER STATUS and SHOW SLAVE STATUSt Repl_client_privs CREATE VIEWs5 The CREATE VIEW privilege enables use of CREATE VIEW.t Create_view_privs SHOW VIEWs8 The SHOW VIEW privilege enables use of SHOW CREATE VIEW.t Show_view_privs CREATE ROUTINEs\ The CREATE ROUTINE privilege is needed to create stored routines (procedures and functions).t Create_routine_privs
ALTER ROUTINEsb The ALTER ROUTINE privilege is needed to alter or drop stored routines (procedures and functions).t Alter_routine_privs CREATE USERsh The CREATE USER privilege enables use of CREATE USER, DROP USER, RENAME USER, and REVOKE ALL PRIVILEGES.t Create_user_privt EVENTs The EVENT privilege is required to create, alter, or drop events for the Event Scheduler. This privilege was added in MySQL 5.1.6.t
Event_privt TRIGGERs The TRIGGER privilege enables you to create and drop triggers.
You must have this privilege for a table to create or drop triggers for that table. This privilege was added in MySQL 5.1.6. (Prior to MySQL 5.1.6, trigger operations required the SUPER privilege.)t Trigger_privs CREATE TABLESPACEsd The CREATE TABLESPACE privilege is needed to create, alter, or drop tablespaces and log file groups.t Create_tablespace_privs * Modify Routinest t Routine_manage_attrs * Modify Access Controlt User_manage_attrc c s% | ] \ } } | d | f Vq d S( i N( ( t .0t keyt val( ( sS C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_security_be.pys <genexpr> s t mysqlt proct funct eventt Insertt Selectt Updatet DeletesX GRANT INSERT, SELECT, UPDATE, DELETE ON TABLE mysql.`%(table)s` TO '%(user)s'@'%(host)s's[ REVOKE INSERT, SELECT, UPDATE, DELETE ON TABLE mysql.`%(table)s` FROM '%(user)s'@'%(host)s't columns_privt dbt hostt
procs_privt tables_privt usert DBAs& grants the rights to perform all taskst MaintenanceAdmins' grants rights needed to maintain servert ProcessAdminsM rights needed to assess, monitor, and kill any user process running in servert UserAdmins8 grants rights to create users logins and reset passwordst
SecurityAdminsQ rights to manage logins and grant and revoke server and database level permissiont MonitorAdmins. minimum set of rights needed to monitor servert DBManagers# grants full rights on all databasest
DBDesigners9 rights to create and reverse engineer any database schemat ReplicationAdmins- rights needed to setup and manage replicationt BackupAdmins, minimal rights needed to backup any databasec C s t | t k r | f } n d } d } d } x | D] } t | t k rU q7 n x[ t t | D]G } | | } | d k r n" | d k s | d k r | } Pn d } qh W| d >| r t | d p | } q7 W| S( Ni s \t %t _i i i ( t typet strt ranget lent min( t tupt ordert wild_post charst tt it c( ( sS C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_security_be.pyt get_acl_sort s$
'c C s t | t | S( N( Ra ( t t1t t2( ( sS C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_security_be.pyt acl_compare s c C s( | j d d j d d j d d S( Ns \s \\RT s \_RS s \%( t replace( t s( ( sS C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_security_be.pyt escape_schema_name s t
AdminSecurityc B s e Z d Z d Z d Z e d Z e d Z e d Z d Z d Z
d Z d Z d
Z
d Z d Z d
Z d Z RS( c C sy | | _ g | _ g | _ i | _ i | _ i | _ t | _ t | _ t | _ t | _
g | _ g | _ g | _
d S( N( t ctrl_bet _accountst
_schema_namest
_zombie_privst _account_info_cachet _schema_privileges_cachet Falset
has_plugint has_authentication_stringt has_max_user_connectionst has_password_expiredt schema_privilege_namest global_privilege_namest user_table_fields( t selfRi ( ( sS C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_security_be.pyt __init__ s c C sL g } x? | j D]4 } t j | d \ } } | r | j | q q W| S( N( NN( Ru t
PrivilegeInfot gett Nonet append( Rw t privst namet privt desc( ( sS C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_security_be.pyt get_valid_privileges s c s4 j s y j j d } Wn; t k
r\ } | j d k rS t d | n | n X| d k r xD | j r | j d } | j d rl j j
| ql ql Wq n j sy j j d } Wn; t k
r} | j d k rt d | n | n X| d k rx | j r| j d } j j
| | j d rl j j
| q | d k rt
_ q | d k rt
_ q | d k rt
_ q | d
k r t
_ q q Wqn g } y j j t } Wn] t k
r/} | j d k r&t d | n | n# t k
rQ} t d | n X| d k rx/ | j r| j d } | j
| qaWn | j | _ g } y j j t } Wn# t k
r} t d | n X| r2xD | j r.| j d
} | j d } | j
| | f qWn f d }
|
t d g } | |
t d d g 7} | |
t d d d g 7} | |
t d d g 7} i } x> | D]6 \ }
} |
| k rg | |
<n | |
j
| qW| _ | | j 7} | j t | _ i _ i _ | d S( Ns DESCRIBE mysql.dbiv sJ Please make sure the used account has rights to the MySQL grant tables.
%st Fieldt _privs DESCRIBE mysql.usert max_user_connectionst plugint authentication_stringt password_expireds( Error querying privilege information: %st Databaset Usert Hostc s y j j | } Wn( t k
r@ } t d | | f g SXg } xx | r | j r | j d } | j d } g | D] } | j | ^ q } | j | | f d j | f qJ W| S( Ns2 Could not get list of invalid privs: %s
Query: %s
R R t .( Ri t
exec_queryt ExceptionR t nextRowt stringByNameR| t join( t queryt fieldst resultt eR} RH RE t ft parts( Rw ( sS C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_security_be.pyt get_zombiesL s "&t Dbt
Table_namet Column_namet Routine_name(! Rt Ri R R t errorR R{ R R t endswithR| Rv Ru t TrueRr Rp Rq Rs t LIST_SCHEMAS_QUERYR t sortRk t LIST_ACCOUNTS_QUERYt ZOMBIE_SCHEMA_PRIVS_QUERYt ZOMBIE_TABLE_PRIVS_QUERYt ZOMBIE_COLUMN_PRIVS_QUERYt ZOMBIE_PROCS_PRIVS_QUERYRl t keysRd Rj Rm t _schema_privileges_by_user( Rw t callbackR R t fieldt schema_namesR~ t accountsRH RE R R} t zombiest accountR ( ( Rw sS C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_security_be.pyt
async_refresh s
c C s | j S( N( Rk ( Rw ( ( sS C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_security_be.pyR r s c C s g | j D] } t | ^ q
S( N( Rk Rg ( Rw Rf ( ( sS C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_security_be.pyt escaped_schema_namesv s c C s | j S( N( Rj ( Rw ( ( sS C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_security_be.pyt
account_namesz s c C s | j r t i t | j d 6t | j d 6} y$ | j j d | j j | Wq t k
r } | j d k r t d | j | j f d q q Xn | j
| j d | j =| j | j f | j k r | j j | j | j f n d S( NRH RE s use mysqli s" Error removing the account %s@%s:s] You must have the global CREATE USER privilege or the DELETE privilege for the mysql databaset @(
t is_commitedt REMOVE_USERR t usernameRE Ri t exec_sqlR R R Rm Rj t remove( Rw R R R ( ( sS C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_security_be.pyt delete_account s *c C s y" | j j | j | j f } Wn t k
r5 nR X| j | j f | j | <| j d | j | j k r | j | j d | j =n | | j | j d | j <| S( NR ( Rj t indexR RE t
ValueErrorRm ( Rw R t backupR_ ( ( sS C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_security_be.pyt revert_account s "
c C s_ | j } t | _ | j d 7_ | | j | j d | j <| j j | j | j f | S( Nt _copyR ( t copyRo R R Rm RE Rj R| ( Rw R R ( ( sS C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_security_be.pyt copy_account s c sz d f d t } d | _ d | j | _ | j | j d | j < j j | j | j f | S( Nc sc | | r t | n d } | | f j k r_ | | t | t rS | d n d } n | S( NR5 i ( RV Rj t
isinstancet int( RH RE t counterR~ ( t unique_nameRw ( sS C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_security_be.pyR s .RS t newuserR ( R{ t AdminAccountRE R Rm Rj R| ( Rw t acct( ( Rw R sS C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_security_be.pyt create_account s c C s | j j | | f S( N( Rl t has_key( Rw RH RE ( ( sS C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_security_be.pyt is_zombie s c C s | j j | | f d S( N( Rl Rz R{ ( Rw RH RE ( ( sS C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_security_be.pyt get_zombie_privs s c C s y2 | j j t i t | d 6t | d 6 Wn* t k
r^ } t d | | | f n Xy2 | j j t i t | d 6t | d 6 Wn* t k
r } t d | | | f n Xy2 | j j t i t | d 6t | d 6 Wn* t k
r } t d | | | f n Xy2 | j j t i t | d 6t | d 6 Wn* t k
r{} t d | | | f n Xd S( NRH RE s1 Could not delete schema privileges for %s@%s: %s
s0 Could not delete table privileges for %s@%s: %s
s1 Could not delete column privileges for %s@%s: %s
s0 Could not delete procs privileges for %s@%s: %s
( Ri R t DROP_ZOMBIE_SCHEMA_PRIVS_QUERYR R R t DROP_ZOMBIE_TABLE_PRIVS_QUERYt DROP_ZOMBIE_COLUMN_PRIVS_QUERYt DROP_ZOMBIE_PROCS_PRIVS_QUERY( Rw RH RE R ( ( sS C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_security_be.pyt wipe_zombie s 2222c C s yl | d | } | j j | r8 | | j | d St | } | j | | | | j | <| | Wn t j j n Xd S( NR ( Rm R R t loadt mformst Utilitiest driver_shutdown( Rw R R~ RE R9 R ( ( sS C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_security_be.pyt async_get_account s
c C s6 | j | j k r" | j | j =n | | j | j <| S( N( R Rn ( Rw R} R ( ( sS C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_security_be.pyt revert_user_schema_privs s ( R R Rx R R t propertyR R R R R R R R R R R R ( ( ( sS C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_security_be.pyRh s o t AdminUserDbPrivEntryc B s) e Z d Z e Z d Z d Z RS( c C s. t | t k s t | | _ | | _ d S( N( RU t sett AssertionErrorRD t
privileges( Rw RD R ( ( sS C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_security_be.pyRx s c C s t | j | j j S( N( R RD R R ( Rw ( ( sS C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_security_be.pyR s N( R R R{ RD R R Rx R ( ( ( sS C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_security_be.pyR s t AdminUserDbPrivsc B sS e Z d Z d Z e d Z d Z d Z d Z d Z
d Z RS( c C s | | _ g | _ g | _ d S( N( t _ownert entriest _deleted_entries( Rw t owner( ( sS C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_security_be.pyRx s c C s
| j j j S( N( R Rt ( Rw ( ( sS C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_security_be.pyRt s c C sE t | j } g | j D] } | j ^ q | _ | j | _ | S( N( R R R R R ( Rw R R ( ( sS C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_security_be.pyR
s %
c C s# t | | } | j j | | S( N( R R R| ( Rw RD R t entry( ( sS C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_security_be.pyt add_entry s c C s% | j j | j | | j | =d S( N( R R| R ( Rw R ( ( sS C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_security_be.pyt del_entry s c C s t i t | j j d 6t | j j d 6} y | j j j | } Wn# t k
rn } t d | n Xg | _ x | j r t
} x< | j D]1 } | j | } | d k r | j
| q q W| j d } | j j t | | q{ W| j j d g | _ d S( NRH RE s' Error querying security information: %st YR c S s t | j | j S( N( Rd RD ( t at b( ( sS C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_security_be.pyt <lambda>4 s ( t GET_ACCOUNT_SCHEMA_PRIVS_QUERYR R R RE Ri R R R R R Rt R t addR| R R R ( Rw R R R R} R t valuet schema( ( sS C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_security_be.pyR s 0 c
C s# | j j j d x g | j D] } t | f ^ q g | j D] } t | f ^ q? D]\ } } i t | j j d 6t | j j d 6| j
d k r | j
n d d 6} g } g } xh | j D]] } t j
| d \ } } | s q n | r| | j k r| j | q | j | q W| r| rd j | | d <y | j j j t | Wqt k
r} | j d k rt d
| d n | qXn | rV d j | | d <y | j j j t | Wqt k
r} | j d
k rt d | d n | qXqV qV Wd S( Ns use mysqlRH RE RS t *RD s , t
granted_privsi sA Error assigning privileges for %(user)s@%(host)s in schema %(db)ss` You must have the GRANT OPTION privilege, and you must have the privileges that you are grantingt
revoked_privsi s@ Error revoking privileges for %(user)s@%(host)s in schema %(db)ss` You must have the GRANT OPTION privilege, and you must have the privileges that you are revoking( NN( R Ri R R R R Ro R R RE RD Rt Ry Rz R{ R R| R t GRANT_SCHEMA_PRIVILEGES_QUERYR R R t REVOKE_SCHEMA_PRIVILEGES_QUERY(
Rw R t deletedR R R R R t priv_namet description( ( sS C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_security_be.pyt save8 s@ O"
N( R R R{ R Rx R Rt R R R R R ( ( ( sS C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_security_be.pyR s R c B sR e Z d Z d Z d Z d Z d Z d Z d Z d Z
e Z d Z
d Z d Z d Z d Z d Z d Z d Z e Z e Z e Z e Z e Z e Z i Z e Z d Z e d Z d Z! d Z" d Z# d Z$ e d Z% d Z& d Z' e d
Z( e d Z) d Z* d
Z+ d Z, d Z- d Z. RS( i c C s | | _ t | | _ d S( N( R R t schema_privs( Rw R ( ( sS C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_security_be.pyRx s c C s
| j j S( N( R Ri ( Rw ( ( sS C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_security_be.pyRi s c C s. | j d k r# d | j | j f S| j Sd S( Ns %s@%s( RE R{ R ( Rw ( ( sS C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_security_be.pyt formatted_name s c C s t | j } | j j | _ | j | _ | j | _ | j | _ | j | _ | j | _ | j | _ | j
| _
| j | _ | j | _ | j
| _
| j | _ | j | _ | j j | _ | j j | _ | S( N( R R R R R t passwordt confirm_passwordR RE t
max_questionst max_updatest max_connectionsR t auth_plugint auth_stringR t
_global_privst _custom_checked_privs( Rw R ( ( sS C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_security_be.pyR s" c C s@ | j } | j | _ | j | _ | j | _ | j | _ | S( N( R t _orig_usernamet _orig_passwordt _orig_auth_stringt
_orig_host( Rw R ( ( sS C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_security_be.pyt snapshot_for_revert s c C sF | r | j j | g n& | j j | g | j j | g d S( N( R t updatet difference_updatet _remembered_custom_privs( Rw R t flag( ( sS C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_security_be.pyt toggle_priv s c C s t | j p | j S( N( t boolR R ( Rw ( ( sS C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_security_be.pyt is_custom_role_needed s c C s t | _ d S( N( R R ( Rw ( ( sS C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_security_be.pyt forget_custom_privs s c sQ f d } | | } | rM | r: j j | qM j j | n d S( Nc sY | d k r j Sx< t D]4 \ } } } | | k r t | j j j Sq Wt S( Nt Custom( R t SecurityAdminRolesR t intersectionR Ru ( t rolet rnamet rdesct rprivs( Rw ( sS C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_security_be.pyt privs_for_role s ( R R R ( Rw R R R R} ( ( Rw sS C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_security_be.pyt toggle_role s c C s g } t } x[ t D]S \ } } } t | j | j j j | j r | j | | j | q q W| j | | _ | j r | j d | j
j | j n | S( NR ( R R R
R Ru t issubsetR R| R R R ( Rw t rolest privs_from_rolesR R R ( ( sS C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_security_be.pyt admin_roles s '
c C s- g | j D] } t j | | g d ^ q
S( Ni ( R Ry Rz ( Rw t p( ( sS C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_security_be.pyt raw_privilege_names s c C s t i t | j d 6| j d 6} y* | j j j d | j j j | WnG t k
r } | j d k r t d | j | j f d q n Xd S( NRH RE s use mysqli s1 Error revoking privileges for the account %s@%s:s] You must have the global CREATE USER privilege or the UPDATE privilege for the mysql database(
t
REVOKE_ALLR R RE R Ri R R R R ( Rw t commandR ( ( sS C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_security_be.pyt
revoke_all s $ c C s t i t | j d 6| j d 6} y* | j j j d | j j j | Wn2 t k
r } t d | j | j | f n Xt | _
d S( NRH RE s use mysqls. Error expiring password for account %s@%s: %s( t EXPIRE_PASSWORDR R RE R Ri R R R R R ( Rw R R ( ( sS C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_security_be.pyt expire_password s $#c s; g } j j k r' t d n | j d j sL t d n j r j j k sy j j k r j j f j j
k r t d j q nL j s j j
j j j f d k r t d j q n i j rt
j n j d 6 j r<t
j n j d 6t
j pXd d 6t
j pnd
d 6t
j pd
d 6 j rt
j n d d
6 j rt
j n d d 6} t } j s1 j r j d k r j d k rt } q t } n t } t } | | g | d *n\ j d k rO j d k sUt j j k sy j j k rt | g | d *n d d d g j j rd g pg } g j j j g j j r j g pg D] } t | ^ q} t t | | } | j k } d t! f d j j" D }
j# j$ |
@} |
j$ } |
j# | }
| s| rd | k rd | d <| j% d n |
| t! d g k rd g } n! g | D] } t& | d ^ q} d j' | p
d | d <t( | } d
} xX | j) D]J \ } } | j j* | k r1| sdd } n | d | | f 7} q1q1W| j | | n |
r|
|
rg |
D] } t& | d ^ q} d j' | | d <| j t+ | q| j t, | n j j- k rv| rv j d! k r7| j d" n
| j d# | d rb| j t. | qv| j t/ | n j rd$ n d% } x | D] } y j j0 j1 | Wqt2 k
r } | j3 d& k rt4 d' | j j f qUt4 d( | j j | j5 p| f qt4 k
rT} t4 d( | j j | f qXqWt! g j# D] } | j6 d) rf| ^ qf } t! g j$ D] } | j6 d) r| ^ q } f d* } f d+ } x! | j7 | D] } | | qWx! | j7 | D] } | | q
Wt _ j8 j9 d S(, NsH The new password and its confirmation don't match. Please re-enter them.s use mysqls Host name must not be blanks4 The '%s' account already exists and cannot be saved.i t old_usert old_hostt NULLRH R5 RE R R R t mysql_native_passwordi t MAX_QUERIES_PER_HOURt MAX_UPDATES_PER_HOURt MAX_CONNECTIONS_PER_HOURt MAX_USER_CONNECTIONSc S s4 t j | d d o3 t j | d d d d k S( Ni R ( NN( NN( Ry Rz R{ ( R ( ( sS C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_security_be.pyR / s c 3 s! | ] } | r | Vq d S( N( ( R8 R ( t is_normal_priv( sS C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_security_be.pys <genexpr>3 s R t OPTIONt GRANTs ALL PRIVILEGESs , t USAGER s WITH s %s %s R t sha256_passwords SET old_passwords = 2s SET old_passwords = 0t changingt creatingiv s@ Error %s account %s@%s: Insufficient rights to perform operations Error %s account %s@%s: %st _attrc s t | \ } } } } } d | k rq x | D]> } | i | d 6 j d 6 j d 6} j j j | q, Wn8 | i | d 6 j d 6 j d 6} j j j | d S( Ns %(table)st tableRH RE ( t AdminAttributesR RE R Ri R ( R RD t tablesR} t grantt revokeR/ R ( Rw ( sS C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_security_be.pyt
grant_specialn s
%%c s t | \ } } } } } d | k rq x | D]> } | i | d 6 j d 6 j d 6} j j j | q, Wn8 | i | d 6 j d 6 j d 6} j j j | d S( Ns %(table)sR/ RH RE ( R0 R RE R Ri R ( R RD R1 R} R2 R3 R/ R ( Rw ( sS C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_security_be.pyt revoke_specialx s
%%(: R R R R| RE R R R R R R R t countR R R{ R Ro t CREATE_USER_QUERY_PLUGINt$ CREATE_USER_QUERY_PLUGIN_AUTH_STRINGt CREATE_USER_QUERYR R t RENAME_USER_QUERYRr R R R R RV t dictt zipt _orig_account_limitsR Ru R t _orig_global_privsR Ry R t GRANT_GLOBAL_PRIVILEGES_QUERYt iteritemsRz t REVOKE_GLOBAL_PRIVILEGES_QUERYR R t CHANGE_PASSWORD_QUERYt BLANK_PASSWORD_QUERYRi R R R R t errortextR t
differenceR R ( Rw t queriesR t password_already_sett create_queryt namesRf t valuest account_limitst limits_changedt all_normal_privst new_granted_privst orig_revoked_privst new_revoked_privst priv_listR t grant_queryt with_clauseR9 R t actionR R R t new_attrst old_attrsR4 R5 ( ( Rw R' sS C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_security_be.pyR s
- ' "" " $$(M "
!
!
".*11
c C s t | _ t i t | d 6t | d 6} y | j j j | } Wn# t k
rk } t d | n X| j s t d | | f n | j d | _
| j d | _ d | _ | j | _
| j
| _ | j | _ | j | _ | j d | _ | j d | _ | j d
| _ i t | j d 6t | j d 6t | j d
6| _ | j j r| j d | _ t | j | j d <n | j j r| j d | _ n | j j r| j d | _ n t | _ | j j r| j d d k | _ n t | j d d k | _! t | j d d k | _" t# | _$ x< | j j% D]. } | j | d k r[| j$ j& | q[q[W| j' t( i t | d 6t | d 6} y | j j j | } Wn# t k
r} t d | n Xi } xM | j rO| j d } | j d } | rB| j) d pEg | | <qWx t* j+ D] \ }
\ } } }
} } | d k r]t } xP | D]H } | j, | st } Pn t# |
j- t# | | st } PqqW| r| j$ j& |
qq]q]W| j$ j. | _/ | j0 j1 d S( NRH RE s' Error querying security information: %ss, Could not load account information for %s@%sR R s UnchangedPassword R R R R# R$ R% R R& R R R R R i i s Error querying mysql table: %sR t
Table_privt ,R; (2 R R t GET_ACCOUNT_QUERYR R Ri R R R R R RE R R R R R R t intByNameR R R RV R= Rr R Rp R Rq Ro R Rs RX t old_authenticationt blank_passwordR R Ru R R
t# GET_ACCOUNT_MYSQL_TABLE_PRIVS_QUERYt splitR0 t itemsR R R R> R R ( Rw R t hostnameR R R R t mysql_privsR/ t table_privsR~ RD R1 t required_privsR2 R3 t ok( ( sS C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_security_be.pyR s~ $
$#(
c C s g } | j | j k r' t d n | j d | j sL t d n i t | j pa d d 6t | j pw d d 6t | j p d d 6} | j d | j j j r | j j j j
d
d
d r | j d | n | j d
| j d | | j d
d } x | D] } y | j j j | Wqt k
r} | j
d k rzt d | | j | j f qt d | | j | j | j p| f qt k
r} t d | | j | j | f qXqWd S( NsH The new password and its confirmation don't match. Please re-enter them.s use mysqls Host name must not be blankR! RH R5 RE R s SET old_passwords = 0i i sd UPDATE mysql.user SET plugin = 'mysql_native_password' WHERE user = '%(user)s' AND host = '%(host)s's FLUSH PRIVILEGESsA SET PASSWORD FOR '%(user)s'@'%(host)s' = PASSWORD('%(password)s')R, iv s@ Error %s account %s@%s: Insufficient rights to perform operations Error %s account %s@%s: %s( R R R R| RE R R R Ri t target_versiont# is_supported_mysql_version_at_leastR R R R RD ( Rw RF R RT R R ( ( sS C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_security_be.pyt upgrade_password_format s4
-
".N(/ R R R{ R R R R R R R R Ro R RE R R R R R R R R[ R\ R R R R R> R= R Rx R Ri R R R R R R
R R R R R R R Rg ( ( ( sS C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_security_be.pyR b sR
a(5 t workbench.db_utilsR R t wb_commonR R t
workbench.logR R R R R R R R R R R R R RY R R] R9 R8 R7 R? RA t GRANT_LIMITS_QUERYR: RB RC R R R t FLUSH_PRIVILEGESR R Ry R; R@ t PrivilegeReverseDictR0 R R Ra Rd Rg t objectRh R R R ( ( ( sS C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_security_be.pyt <module> s
a