Grant user with MySQL (Create a New User and Grant Permissions)

建立使用者

建立擁有所有權限的使用者

方法一：

GRANT ALL ON *.* TO 'username'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;
FLUSH PRIVILEGES;

方法二：

GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;
FLUSH PRIVILEGES;

方法三：

CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost';
FLUSH PRIVILEGES;

建立指定權限的使用者

GRANT SELECT,INSERT,UPDATE,DELETE,CREATE ON database.* TO 'username'@'localhost' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;

建立擁有Replication權限的使用者

GRANT REPLICATION SLAVE ON *.* TO 'replication'@'host ip' IDENTIFIED BY 'password';