Guest User

Untitled

a guest
Mar 5th, 2013
171
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. mysql> select * from user where user = 'root'\G
  2. *************************** 1. row ***************************
  3. Host: localhost
  4. User: root
  5. Select_priv: Y
  6. Insert_priv: Y
  7. Update_priv: Y
  8. Delete_priv: Y
  9. Create_priv: Y
  10. Drop_priv: Y
  11. Reload_priv: Y
  12. Shutdown_priv: Y
  13. Process_priv: Y
  14. File_priv: Y
  15. Grant_priv: Y
  16. References_priv: Y
  17. Index_priv: Y
  18. Alter_priv: Y
  19. Show_db_priv: Y
  20. Super_priv: Y
  21. Create_tmp_table_priv: Y
  22. Lock_tables_priv: Y
  23. Execute_priv: Y
  24. Repl_slave_priv: Y
  25. Repl_client_priv: Y
  26. Create_view_priv: Y
  27. Show_view_priv: Y
  28. Create_routine_priv: Y
  29. Alter_routine_priv: Y
  30. Create_user_priv: Y
  31. Event_priv: Y
  32. Trigger_priv: Y
  33. ssl_type:
  34. ssl_cipher:
  35. x509_issuer:
  36. x509_subject:
  37. max_questions: 0
  38. max_updates: 0
  39. max_connections: 0
  40. max_user_connections: 0
  41. *************************** 2. row ***************************
  42. Host: 127.0.0.1
  43. User: root
  44. Select_priv: Y
  45. Insert_priv: Y
  46. Update_priv: Y
  47. Delete_priv: Y
  48. Create_priv: Y
  49. Drop_priv: Y
  50. Reload_priv: Y
  51. Shutdown_priv: Y
  52. Process_priv: Y
  53. File_priv: Y
  54. Grant_priv: Y
  55. References_priv: Y
  56. Index_priv: Y
  57. Alter_priv: Y
  58. Show_db_priv: Y
  59. Super_priv: Y
  60. Create_tmp_table_priv: Y
  61. Lock_tables_priv: Y
  62. Execute_priv: Y
  63. Repl_slave_priv: Y
  64. Repl_client_priv: Y
  65. Create_view_priv: Y
  66. Show_view_priv: Y
  67. Create_routine_priv: Y
  68. Alter_routine_priv: Y
  69. Create_user_priv: Y
  70. Event_priv: N
  71. Trigger_priv: N
  72. ssl_type:
  73. ssl_cipher:
  74. x509_issuer:
  75. x509_subject:
  76. max_questions: 0
  77. max_updates: 0
  78. max_connections: 0
  79. max_user_connections: 0
  80. 2 rows in set (0.00 sec)
RAW Paste Data