1 添加新用户
create user 'visitor'@'hostname' identity by 'password';
2 删除用户
drop user 'visitor'@'hostname';
3 重置密码
set password for 'visitor'@'hostname' = Password('newPassword');
4 查看权限
show grants for 'visitor'@'hostname';
5 分配权限
grant select,update on dbName.tableName to 'visitor'@'hostname';
grant all privileges on *.* to 'root'@'%' identified by 'password!' with grant option;
FLUSH PRIVILEGES;
- 注意有些情况下主机端口没有开放,可以一下命令来开启端口对外监听: iptables -I INPUT -s 0/0 -p tcp --dport 3306 -j ACCEPT