Advertisement
Guest User

Untitled

a guest
Oct 11th, 2017
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.44 KB | None | 0 0
  1. # Install
  2. sudo apt-get install mariadb-server
  3.  
  4. # Secure the server
  5. sudo mysql_secure_installation
  6.  
  7. # vim /root/.my.cnf and place the following
  8. [mysql]
  9. user=root
  10. password=...
  11.  
  12. # Create our actual app user
  13. mysql
  14. > CREATE USER 'deploy'@'localhost' IDENTIFIED BY '...';
  15. > GRANT ALL PRIVILEGES on * . * to 'deploy'@'localhost';
  16. > flush privileges;
  17.  
  18. # Now you can portforward
  19. ssh deploy@IPGOESHERE -L 3306:127.0.0.1:3306'
  20.  
  21. # Develop locally and use the database
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement