MySql创建用户

1. 创建用户derek,密码是1234，并且指定host为%，从而允许远程连接

 CREATE USER 'derek'@'%' IDENTIFIED BY '1234';

2. 授予derek所有权限

 GRANT ALL PRIVILEGES ON * . * TO 'derek'@'%';