리눅스, 자료실, 성경검색, 추억의게임, 고전게임, 오락실게임, rootman, http://www.rootman.co.kr
* 54.161.118.57 *
| Home | Profile | Linux | 자료실 | zabbix | Mysql 5.6 | 갤러리 | 성경검색 | 해피니스 | 자유게시판 | 게시물검색 | L | O | R |    

 
[innodb] mysql> SHOW PRIVILEGES\\G;
 작성자 : rootman
Date : 2009-06-04 19:17  |  Hit : 4,661  
mysql> SHOW PRIVILEGES\\G;
*************************** 1. row ***************************
Privilege: Alter
Context: Tables
Comment: To alter the table
*************************** 2. row ***************************
Privilege: Alter routine
Context: Functions,Procedures
Comment: To alter or drop stored functions/procedures
*************************** 3. row ***************************
Privilege: Create
Context: Databases,Tables,Indexes
Comment: To create new databases and tables
*************************** 4. row ***************************
Privilege: Create routine
Context: Functions,Procedures
Comment: To use CREATE FUNCTION/PROCEDURE
*************************** 5. row ***************************
Privilege: Create temporary tables
Context: Databases
Comment: To use CREATE TEMPORARY TABLE
*************************** 6. row ***************************
Privilege: Create view
Context: Tables
Comment: To create new views
*************************** 7. row ***************************
Privilege: Create user
Context: Server Admin
Comment: To create new users
*************************** 8. row ***************************
Privilege: Delete
Context: Tables
Comment: To delete existing rows
*************************** 9. row ***************************
Privilege: Drop
Context: Databases,Tables
Comment: To drop databases, tables, and views
*************************** 10. row ***************************
Privilege: Execute
Context: Functions,Procedures
Comment: To execute stored routines
*************************** 11. row ***************************
Privilege: File
Context: File access on server
Comment: To read and write files on the server
*************************** 12. row ***************************
Privilege: Grant option
Context: Databases,Tables,Functions,Procedures
Comment: To give to other users those privileges you possess
*************************** 13. row ***************************
Privilege: Index
Context: Tables
Comment: To create or drop indexes
*************************** 14. row ***************************
Privilege: Insert
Context: Tables
Comment: To insert data into tables
*************************** 15. row ***************************
Privilege: Lock tables
Context: Databases
Comment: To use LOCK TABLES (together with SELECT privilege)
*************************** 16. row ***************************
Privilege: Process
Context: Server Admin
Comment: To view the plain text of currently executing queries
*************************** 17. row ***************************
Privilege: References
Context: Databases,Tables
Comment: To have references on tables
*************************** 18. row ***************************
Privilege: Reload
Context: Server Admin
Comment: To reload or refresh tables, logs and privileges
*************************** 19. row ***************************
Privilege: Replication client
Context: Server Admin
Comment: To ask where the slave or master servers are
*************************** 20. row ***************************
Privilege: Replication slave
Context: Server Admin
Comment: To read binary log events from the master
*************************** 21. row ***************************
Privilege: Select
Context: Tables
Comment: To retrieve rows from table
*************************** 22. row ***************************
Privilege: Show databases
Context: Server Admin
Comment: To see all databases with SHOW DATABASES
*************************** 23. row ***************************
Privilege: Show view
Context: Tables
Comment: To see views with SHOW CREATE VIEW
*************************** 24. row ***************************
Privilege: Shutdown
Context: Server Admin
Comment: To shut down the server
*************************** 25. row ***************************
Privilege: Super
Context: Server Admin
Comment: To use KILL thread, SET GLOBAL, CHANGE MASTER, etc.
*************************** 26. row ***************************
Privilege: Update
Context: Tables
Comment: To update existing rows
*************************** 27. row ***************************
Privilege: Usage
Context: Server Admin
Comment: No privileges - allow connect only
27 rows in set (0.00 sec)

ERROR:
No query specified

 
 

Total. 645
번호 분류 제목 작성자 등록일 조회수
495 innodb mysql> SHOW WARNINGS; rootman 06-04 11555
494 innodb mysql> SHOW TABLE STATUS\\G; rootman 06-04 6691
493 innodb mysql> SHOW PRIVILEGES\\G; rootman 06-04 4662
492 innodb mysql> SHOW OPEN TABLES; rootman 06-04 5088
491 innodb mysql> SHOW MASTER STATUS; rootman 06-04 4758
490 innodb mysql> SHOW LOGS; rootman 06-04 4644
489 innodb mysql> SHOW INNODB STATUS\\G; rootman 06-04 6129
488 innodb mysql> SHOW ERRORS; rootman 06-04 4710
487 innodb mysql> SHOW TABLE TYPES; rootman 06-04 4758
486 innodb mysql> SHOW ENGINES\\G rootman 06-04 4548
485 RAID [INTEL] LSI ONBOARD rootman 06-02 3527
484 javascript [프린트] 현재페이지를 인쇄할때 출력용지에 아무 내용도 안찍히… rootman 05-20 5739
483 javascript    [프린트] <div>로 지정된 영역만 출력합니다. rootman 05-20 3627
482 javascript [프린트] 버튼 클릭으로 현재페이지 프린트 1 rootman 05-20 4809
481 javascript [프린트] 버튼 클릭으로 현재페이지 프린트 3 rootman 05-20 4579
   11  12  13  14  15  16  17  18  19  20    
AND OR