Guest User

Untitled

a guest
Mar 1st, 2018
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.94 KB | None | 0 0
  1. mysql -u root
  2.  
  3. CREATE USER 'loyal'@'172.%' IDENTIFIED BY 'Test123';
  4. GRANT ALL PRIVILEGES ON *.* TO 'loyal'@'172.%';
  5.  
  6. CREATE USER 'loy'@'localhost' IDENTIFIED BY 'Test123';
  7. GRANT ALL PRIVILEGES ON *.* TO 'loyal'@'localhost';
  8.  
  9. flush privileges;
  10.  
  11. exit;exit;
  12.  
  13. mysql -u loyal -p loyal < main.sql
  14.  
  15. mysql -u loyal -p loyal
  16.  
  17. select * from BARCODE;
  18.  
  19. ## I get a dump of data
  20.  
  21. FROM registry.access.redhat.com/rhscl/mysql-57-rhel7
  22.  
  23. ENV MYSQL_USER=loyal
  24. ENV MYSQL_PASSWORD=loyal
  25. ENV MYSQL_DATABASE=loyal
  26. ENV MYSQL_ROOT_PASSWORD=loyal
  27.  
  28. COPY ./APP.sql /opt/app-root/src
  29. COPY ./BARCODE.sql /opt/app-root/src
  30. COPY ./CARD.sql /opt/app-root/src
  31. COPY ./main.sql /opt/app-root/src
  32.  
  33. ADD users.sql /docker-entrypoint-initdb.d
  34.  
  35. mysql -u root
  36.  
  37. CREATE USER 'loyal'@'172.%' IDENTIFIED BY 'Test123';
  38. GRANT ALL PRIVILEGES ON *.* TO 'loyal'@'172.%';
  39.  
  40. CREATE USER 'loyal'@'localhost' IDENTIFIED BY 'Test123';
  41. GRANT ALL PRIVILEGES ON *.* TO 'loyal'@'localhost';
  42.  
  43. flush privileges;
Add Comment
Please, Sign In to add comment