firdoussross/Useful Shell Commands.md

## Useful Shell Commands.md

      
    Raw
  

              Useful Shell Commands.md
            
          
    Useful commands that I always tend to forget.

BASH

Zip all folders individually to it's own archives
$ for dir in *; do tar -czf ${dir}.tar.gz ${dir}; done

MySQL

Create databse, user and grant privileges
create database DATABASE_NAME;
grant usage on *.* to DATABASE_USER@localhost identified by 'PASSWORD’;
grant all privileges on DATABASE_NAME.* to DATABASE_USER@localhost ;