一、创建用户
1、允许192.168.11.%网段进行连接
create user 'DengMeng'@'192.168.11.%' identified by 'root123.';
2、允许本地进行连接
create user 'DengMeng'@'localhost' identified by 'root123.';
3、允许所有主机进行连接
create user 'DengMeng'@'%' identified by 'root123.';
一、创建用户
1、允许192.168.11.%网段进行连接
create user 'DengMeng'@'192.168.11.%' identified by 'root123.';
2、允许本地进行连接
create user 'DengMeng'@'localhost' identified by 'root123.';
3、允许所有主机进行连接
create user 'DengMeng'@'%' identified by 'root123.';