MySQL

• Transaction:
  • A collection of operations wherein each must succeed for the next to occur. If one fails, the database returns to its pre-transaction state.

• Connect to MySQL:
  • mysql -u exampleUser -p
• Create a new user:
  • CREATE USER 'exampleUser'@'localhost' IDENTIFIED BY 'SomeHardToGuessPassword';
• grant permissions to user:
  • GRANT ALL ON databaseName.* TO 'exampleUser'@'localhost';
• Create a new Database:
  • CREATE DATABASE DatabaseName;