Guest User

Untitled

a guest
Aug 20th, 2018
181
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.12 KB | None | 0 0
  1. Root account wont work in MySQL
  2. mysql> GRANT ALL ON *.* TO 'root'@'%'
  3. -> IDENTIFIED BY '[password]'
  4. -> WITH GRANT OPTION;
  5. ERROR 1045 (28000): Access denied for user 'root'@'%' (using password: YES)
  6. mysql>
  7.  
  8. mysql> show grants for root
  9. -> ;
  10. +-----------------------------------------------------------------------------------------------------+
  11. | Grants for root@% |
  12. +-----------------------------------------------------------------------------------------------------+
  13. | GRANT USAGE ON *.* TO 'root'@'%' IDENTIFIED BY PASSWORD '*738393F115A47ACE272D98F4719B8491A2B8296F' |
  14. | GRANT ALL PRIVILEGES ON `sometable`.* TO 'root'@'%' WITH GRANT OPTION |
  15. | GRANT ALL PRIVILEGES ON `Test`.* TO 'root'@'%' WITH GRANT OPTION |
  16. +-----------------------------------------------------------------------------------------------------+
  17. 3 rows in set (0.00 sec)
  18.  
  19. mysql> select user();
  20.  
  21. mysql> select * from mysql.userG
  22.  
  23. mysql> select * from mysql.userG
  24. *************************** 1. row ***************************
  25. Host: localhost
  26. User: root
  27. Password: xxxxxxxxxxxxxxx
  28. Select_priv: Y
  29. Insert_priv: Y
  30. Update_priv: Y
  31. Delete_priv: Y
  32. Create_priv: Y
  33. Drop_priv: Y
  34. Reload_priv: Y
  35. Shutdown_priv: Y
  36. Process_priv: Y
  37. File_priv: Y
  38. Grant_priv: Y
  39. References_priv: Y
  40. Index_priv: Y
  41. Alter_priv: Y
  42. Show_db_priv: Y
  43. Super_priv: Y
  44. Create_tmp_table_priv: Y
  45. Lock_tables_priv: Y
  46. Execute_priv: Y
  47. Repl_slave_priv: Y
  48. Repl_client_priv: Y
  49. Create_view_priv: Y
  50. Show_view_priv: Y
  51. Create_routine_priv: Y
  52. Alter_routine_priv: Y
  53. Create_user_priv: Y
  54. Event_priv: Y
  55. Trigger_priv: Y
  56. ssl_type:
  57. ssl_cipher:
  58. x509_issuer:
  59. x509_subject:
  60. max_questions: 0
  61. max_updates: 0
  62. max_connections: 0
  63. max_user_connections: 0
Add Comment
Please, Sign In to add comment