日期: 2006 年 2 月 19 日

• GRANT ALL ON *.* TO 'username'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;
• GRANT SELECT,INSERT,UPDATE,DELETE,CREATE ON db_name.* TO 'username'@'localhost' IDENTIFIED BY 'password';
• GRANT ALL PRIVILEGES ON *.* TO 'username'@'127.0.0.%' IDENTIFIED BY 'password' WITH GRANT OPTION;
• GRANT REPLICATION SLAVE ON *.* TO repl@"192.168.1.%" IDENTIFIED BY 'password';
• GRANT SELECT,INSERT,UPDATE,DELETE,CREATE ON db_name.* TO 'username'@'%' IDENTIFIED BY 'password';
• GRANT SELECT, LOCK TABLES ON *.* TO  'backup'@'localhost'
  IDENTIFIED BY 'backup_password'; # mysqldump
• GRANT SELECT ON *.* TO  'backup'@'localhost'
  IDENTIFIED BY 'backup_password'; # mysqldump
• FLUSH PRIVILEGES;


自行把 上述的 username, password, db_name 換掉即可.

閱讀全文〈MySQL 新增 User (Grant)〉