Database Review

Commands

• mysql
  • mysql -u root -p -h foo.somehost.net
• SQL
  • use database;
  • Grant permissions
    • grant all privileges on db.* to 'joe'@'somehost' identified by 'somepass';
    • grant all privileges on db.* to 'tom'@'localhost' identified by 'somepass';
    • grant all privileges on db.* to 'tom'@'144.38.2.3' identified by 'somepass';
    • grant all privileges on db.* to 'tom'@'144.38.2.0/27' identified by 'somepass';
  • create database
  • INSERT, UPDATE, DELETE, SELECT

Topics

• Make sure you know how to allow remote connections
  • /etc/mysql/…./my.cnf bind address