查询用户名的权限所在的ip,*代表全部,localhost是本机
use mysql;
select host,user from user;
创建用户名和密码,并指定ip的权限,比如用户是abc123,密码是123456
create user abc123@'%' identified by '123456';
grant all privileges on *.* to abc123@'%' with grant option;
查询用户名的权限所在的ip,*代表全部,localhost是本机
use mysql;
select host,user from user;
创建用户名和密码,并指定ip的权限,比如用户是abc123,密码是123456
create user abc123@'%' identified by '123456';
grant all privileges on *.* to abc123@'%' with grant option;