一、创建账号、授权

  1. CREATE USER 'custom'@'localhost'
  2.   IDENTIFIED BY 'password';
  4. GRANT ALL
  5.   ON bankaccount.*
  6.   TO 'custom'@'localhost';
  8. CREATE USER 'custom'@'host47.example.com'
  9.   IDENTIFIED BY 'password';
  11. GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP
  12.   ON expenses.*
  13.   TO 'custom'@'host47.example.com';
  15. CREATE USER 'custom'@'%.example.com'
  16.   IDENTIFIED BY 'password';
  18. GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP
  19.   ON customer.addresses
  20.   TO 'custom'@'%.example.com';