- 新增用户 : CREATE USER 'username'@'host' IDENTIFIED BY 'password';
- 分配权限 : GRANT privileges ON databasename.tablename TO 'username'@'host'
- 刷新权限 : flush privileges;
- 修改密码 : update mysql.user set authentication_string=password('123qwe') where user='root' and Host = 'localhost';
网友评论