1,首先登录mysql后,创建新的用户
CREATE USER 'username'@'hostname' IDENTIFIED BY 'password';
2,分派权限
#注意此处是所有权限
GRANT ALL PRIVILEGES ON *.* TO 'username'@'hostname' IDENTIFIED BY 'password';
3,刷新权限
FLUSH PRIVILEGES;
1,首先登录mysql后,创建新的用户
CREATE USER 'username'@'hostname' IDENTIFIED BY 'password';
2,分派权限
#注意此处是所有权限
GRANT ALL PRIVILEGES ON *.* TO 'username'@'hostname' IDENTIFIED BY 'password';
3,刷新权限
FLUSH PRIVILEGES;