Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # Install
- sudo apt-get install mariadb-server
- # Secure the server
- sudo mysql_secure_installation
- # vim /root/.my.cnf and place the following
- [mysql]
- user=root
- password=...
- # Create our actual app user
- mysql
- > CREATE USER 'deploy'@'localhost' IDENTIFIED BY '...';
- > GRANT ALL PRIVILEGES on * . * to 'deploy'@'localhost';
- > flush privileges;
- # Now you can portforward
- ssh deploy@IPGOESHERE -L 3306:127.0.0.1:3306'
- # Develop locally and use the database
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement