daily pastebin goal
11%
SHARE
TWEET

Untitled

a guest Jun 18th, 2017 503 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. MySQL:  10.176.129.129
  2.  
  3. Want to connect from an app server and mysql: 10.176.128.136 AND 10.176.129.129
  4.  
  5. grant all on db_name.* to app@'10.176.129.129';
  6. grant all on db_name.* to app@'10.176.128.136';
  7.  
  8. +------------------+----------------+--------------------------------------+
  9. | User             | Host           | Password                             |
  10. +------------------+----------------+--------------------------------------+
  11. | app              | 10.176.128.136 | *811F168441E6B859910402931CF3D84D937 |
  12. | app              | 10.176.129.129 | *811F168441E6B859910402931CF3D84D937 |
  13.  
  14. update user set password=PASSWORD("my_pass") where User='app';
  15.  
  16. On the App server this works fine:
  17. mysql -u app -p -h 10.176.129.129 db_name
  18.  
  19. On the DB server, the same command blows up:
  20. ERROR 1045 (28000): Access denied for user 'app'@'10.176.129.129' (using password: YES)
RAW Paste Data
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
 
Top