jordelver/gist:6185467

## gistfile1.md

      
    Raw
  

              gistfile1.md
            
          
    MySQL basics

Dump the database

mysqldump -u root -p <database> > /path/to/file.sql

Restore the database

mysql -u root -p <database> < /path/to/file.sql

Create a new user

CREATE USER '<username>'@'localhost' IDENTIFIED BY '<password>';
Grant privileges to the user

GRANT ALL PRIVILEGES ON <database>.* TO '<user>'@'localhost';