API tools faq
paste
Guest User

Untitled

a guest
May 28th, 2018
157
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.72 KB | None | 0 0
raw download clone embed print report
  1. > select * from mysql.user where user='admin'G;
  2. *************************** 1. row ***************************
  3. Host: %
  4. User: admin
  5. Password: *C58D6BEE46C829269E211EB77AA2005DECC89CF1
  6. Select_priv: Y
  7. Insert_priv: Y
  8. Update_priv: Y
  9. Delete_priv: Y
  10. Create_priv: Y
  11. Drop_priv: Y
  12. Reload_priv: Y
  13. Shutdown_priv: N
  14. Process_priv: Y
  15. File_priv: N
  16. Grant_priv: Y
  17. References_priv: Y
  18. Index_priv: Y
  19. Alter_priv: Y
  20. Show_db_priv: Y
  21. Super_priv: N
  22. Create_tmp_table_priv: Y
  23. Lock_tables_priv: Y
  24. Execute_priv: Y
  25. Repl_slave_priv: Y
  26. Repl_client_priv: Y
  27. Create_view_priv: Y
  28. Show_view_priv: Y
  29. Create_routine_priv: Y
  30. Alter_routine_priv: Y
  31. Create_user_priv: Y
  32. Event_priv: Y
  33. Trigger_priv: Y
  34. Create_tablespace_priv: N
  35. ssl_type:
  36. ssl_cipher:
  37. x509_issuer:
  38. x509_subject:
  39. max_questions: 0
  40. max_updates: 0
  41. max_connections: 0
  42. max_user_connections: 0
  43. plugin: mysql_native_password
  44. authentication_string:
  45. password_expired: N
  46.  
  47. > select * from mysql.user where user='admin'G;
  48. *************************** 1. row ***************************
  49. Host: %
  50. User: admin
  51. Select_priv: Y
  52. Insert_priv: Y
  53. Update_priv: Y
  54. Delete_priv: Y
  55. Create_priv: Y
  56. Drop_priv: Y
  57. Reload_priv: Y
  58. Shutdown_priv: N
  59. Process_priv: Y
  60. File_priv: N
  61. Grant_priv: Y
  62. References_priv: Y
  63. Index_priv: Y
  64. Alter_priv: Y
  65. Show_db_priv: Y
  66. Super_priv: N
  67. Create_tmp_table_priv: Y
  68. Lock_tables_priv: Y
  69. Execute_priv: Y
  70. Repl_slave_priv: Y
  71. Repl_client_priv: Y
  72. Create_view_priv: Y
  73. Show_view_priv: Y
  74. Create_routine_priv: Y
  75. Alter_routine_priv: Y
  76. Create_user_priv: Y
  77. Event_priv: Y
  78. Trigger_priv: Y
  79. Create_tablespace_priv: N
  80. ssl_type:
  81. ssl_cipher:
  82. x509_issuer:
  83. x509_subject:
  84. max_questions: 0
  85. max_updates: 0
  86. max_connections: 0
  87. max_user_connections: 0
  88. plugin: mysql_native_password
  89. authentication_string: *9E88C5A2B9C165CCF2599545998EDA0B3704AE53
  90. password_expired: N
  91. password_last_changed: 2018-05-18 13:52:35
  92. password_lifetime: NULL
  93. account_locked: N
  94.  
  95. > GRANT ALL PRIVILEGES ON *.* TO 'randomroot'@'localhost' IDENTIFIED BY '<pwd>' WITH GRANT OPTION;
  96. ERROR: 1045 (28000): Access denied for user 'admin'@'%' (using password: YES)
  97.  
  98. > GRANT ALL PRIVILEGES ON *.* TO 'randomroot'@'localhost' IDENTIFIED BY '<pwd>' WITH GRANT OPTION;
  99. ERROR: 1045 (28000): Access denied for user 'admin'@'%' (using password: YES)
  100.  
  101. > select * from mysql.user where user = 'rdsadmin'G;
  102. *************************** 1. row ***************************
  103. Host: localhost
  104. User: rdsadmin
  105. Password: *0679641C78FA0E03C1E8F152B87FA2F8CC8F72E7
  106. Select_priv: Y
  107. Insert_priv: Y
  108. Update_priv: Y
  109. Delete_priv: Y
  110. Create_priv: Y
  111. Drop_priv: Y
  112. Reload_priv: Y
  113. Shutdown_priv: Y
  114. Process_priv: Y
  115. File_priv: Y
  116. Grant_priv: Y
  117. References_priv: Y
  118. Index_priv: Y
  119. Alter_priv: Y
  120. Show_db_priv: Y
  121. Super_priv: Y
  122. Create_tmp_table_priv: Y
  123. Lock_tables_priv: Y
  124. Execute_priv: Y
  125. Repl_slave_priv: Y
  126. Repl_client_priv: Y
  127. Create_view_priv: Y
  128. Show_view_priv: Y
  129. Create_routine_priv: Y
  130. Alter_routine_priv: Y
  131. Create_user_priv: Y
  132. Event_priv: Y
  133. Trigger_priv: Y
  134. Create_tablespace_priv: Y
  135. ssl_type:
  136. ssl_cipher:
  137. x509_issuer:
  138. x509_subject:
  139. max_questions: 0
  140. max_updates: 0
  141. max_connections: 0
  142. max_user_connections: 0
  143. plugin: mysql_native_password
  144. authentication_string:
  145. password_expired: N
  146.  
  147. SET PASSWORD FOR 'rdsadmin'@'localhost' = PASSWORD('<pwd>');
  148. ERROR: 1396 (HY000): Operation SET PASSWORD failed for rdsadmin@localhost
  149.  
  150. > select * from mysql.user where user = 'randomroot'G;
  151. *************************** 1. row ***************************
  152. Host: localhost
  153. User: randomroot
  154. Select_priv: Y
  155. Insert_priv: Y
  156. Update_priv: Y
  157. Delete_priv: Y
  158. Create_priv: Y
  159. Drop_priv: Y
  160. Reload_priv: Y
  161. Shutdown_priv: Y
  162. Process_priv: Y
  163. File_priv: Y
  164. Grant_priv: Y
  165. References_priv: Y
  166. Index_priv: Y
  167. Alter_priv: Y
  168. Show_db_priv: Y
  169. Super_priv: Y
  170. Create_tmp_table_priv: Y
  171. Lock_tables_priv: Y
  172. Execute_priv: Y
  173. Repl_slave_priv: Y
  174. Repl_client_priv: Y
  175. Create_view_priv: Y
  176. Show_view_priv: Y
  177. Create_routine_priv: Y
  178. Alter_routine_priv: Y
  179. Create_user_priv: Y
  180. Event_priv: Y
  181. Trigger_priv: Y
  182. Create_tablespace_priv: Y
  183. ssl_type:
  184. ssl_cipher:
  185. x509_issuer:
  186. x509_subject:
  187. max_questions: 0
  188. max_updates: 0
  189. max_connections: 0
  190. max_user_connections: 0
  191. plugin: mysql_native_password
  192. authentication_string: *C2AD957A98109BD742F98E4D97E69634578C82E0
  193. password_expired: N
  194. password_last_changed: 2018-05-28 14:21:59
  195. password_lifetime: NULL
  196. account_locked: N
  197.  
  198. > SET PASSWORD FOR 'randomroot'@'localhost' = '<newpwd>';
  199. Query OK, 0 rows affected (0.2871 sec)
  200.  
  201. > SHOW GRANTS FOR adminG;
  202. *************************** 1. row ***************************
  203. Grants for admin@%: GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, PROCESS, REFERENCES, INDEX, ALTER, SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER ON *.* TO 'admin'@'%' IDENTIFIED BY PASSWORD <secret> WITH GRANT OPTION
  204. 1 row in set (0.2238 sec)
  205.  
  206. > SHOW GRANTS for adminG;
  207. *************************** 1. row ***************************
  208. Grants for admin@%: GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, PROCESS, REFERENCES, INDEX, ALTER, SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER ON *.* TO 'admin'@'%' WITH GRANT OPTION
  209. 1 row in set (0.2538 sec)
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!