API tools faq
paste
Guest User

Untitled

a guest
Sep 1st, 2018
169
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.26 KB | None | 0 0
raw download clone embed print report
  1. +---------------+------------------+
  2. | host | user |
  3. +---------------+------------------+
  4. | % | user1 |
  5. | % | user2 |
  6. | 10.x.x.x | user1 |
  7. | 10.x.x.x | user2 |
  8.  
  9. mysql -u user2 -p -h 10.x.x.x
  10. Enter password:
  11. ERROR 1045 (28000): Access denied for user 'user2'@'10.x.x.x' (using password: YES)
  12.  
  13. mysql -u user1 -p -h 10.x.x.x
  14.  
  15. +--------------------+
  16. | Database |
  17. +--------------------+
  18. | information_schema |
  19. | database1 |
  20. +--------------------+
  21. use database2;
  22. ERROR 1044 (42000): Access denied for user 'database2'@'%' to database 'consumeitall'
  23.  
  24. Grants for consumeitallwp@% |
  25. +------------------------------------------------------------------+
  26. | GRANT USAGE ON *.* TO 'user1'@'%' |
  27. | GRANT ALL PRIVILEGES ON `database2`.* TO 'user1'@'%' |
  28. +------------------------------------------------------------------+
  29. +-------------------------------------------------------------------------------
  30. | Grants for user1@10.x.x.x |
  31. +-------------------------------------------------------------------------------
  32. | GRANT USAGE ON *.* TO 'user1'@'10.x.x.x' |
  33. | GRANT ALL PRIVILEGES ON `database1`.* TO 'user1'@'10.x.x.x' |
  34. | GRANT ALL PRIVILEGES ON `database2`.* TO 'user1'@'10.x.x.x' |
  35. +-------------------------------------------------------------------------------
  36. Grants for user2@% |
  37. +---------------------------------------------------------+
  38. | GRANT USAGE ON *.* TO 'user2'@'%' |
  39. | GRANT ALL PRIVILEGES ON `database2`.* TO 'user2'@'%' |
  40. +---------------------------------------------------------+
  41. Grants for user2@10.x.x.x |
  42. +---------------------------------------------------------------------+
  43. | GRANT USAGE ON *.* TO 'user2'@'10.x.x.x' |
  44. | GRANT ALL PRIVILEGES ON `database2`.* TO 'user2'@'10.x.x.x' |
  45. +---------------------------------------------------------------------+
  46.  
  47. select * from user where user='user1';
  48. +---------------+----------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+------------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+-----------------------+-------------------------------------------+------------------+-----------------------+-------------------+----------------+
  49. | Host | User | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Show_db_priv | Super_priv | Create_tmp_table_priv | Lock_tables_priv | Execute_priv | Repl_slave_priv | Repl_client_priv | Create_view_priv | Show_view_priv | Create_routine_priv | Alter_routine_priv | Create_user_priv | Event_priv | Trigger_priv | Create_tablespace_priv | ssl_type | ssl_cipher | x509_issuer | x509_subject | max_questions | max_updates | max_connections | max_user_connections | plugin | authentication_string | password_expired | password_last_changed | password_lifetime | account_locked |
  50. +---------------+----------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+------------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+-----------------------+-------------------------------------------+------------------+-----------------------+-------------------+----------------+
  51. | % | user1 | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | | | | | 0 | 0 | 0 | 0 | mysql_native_password | *35E8CBE139AB3223B2E157A41D6916C9F1198827 | N | 2018-09-02 03:08:48 | NULL | N |
  52. | 10.x.x.x | user1 | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | | | | | 0 | 0 | 0 | 0 | mysql_native_password | *35E8CBE139AB3223B2E157A41D6916C9F1198827 | N | 2018-09-01 23:44:39 | NULL | N |
  53. +---------------+----------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+------------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+-----------------------+-------------------------------------------+------------------+-----------------------+-------------------+----------------+
  54.  
  55.  
  56. +---------------+--------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+------------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+-----------------------+-------------------------------------------+------------------+-----------------------+-------------------+----------------+
  57. | Host | User | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Show_db_priv | Super_priv | Create_tmp_table_priv | Lock_tables_priv | Execute_priv | Repl_slave_priv | Repl_client_priv | Create_view_priv | Show_view_priv | Create_routine_priv | Alter_routine_priv | Create_user_priv | Event_priv | Trigger_priv | Create_tablespace_priv | ssl_type | ssl_cipher | x509_issuer | x509_subject | max_questions | max_updates | max_connections | max_user_connections | plugin | authentication_string | password_expired | password_last_changed | password_lifetime | account_locked |
  58. +---------------+--------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+------------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+-----------------------+-------------------------------------------+------------------+-----------------------+-------------------+----------------+
  59. | 10.x.x.x | user2 | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | | | | | 0 | 0 | 0 | 0 | mysql_native_password | *35E8CBE139AB3223B2E157A41D6916C9F1198827 | N | 2018-09-02 04:24:32 | NULL | N |
  60. | % | user2 | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | | | | | 0 | 0 | 0 | 0 | mysql_native_password | *35E8CBE139AB3223B2E157A41D6916C9F1198827 | N | 2018-09-02 03:17:44 | NULL | N |
  61. +---------------+--------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+------------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+-----------------------+-------------------------------------------+------------------+-----------------------+-------------------+----------------+
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!