mysql远程连接

43212gg

mysql远程连接

create user 'wubx'@'192.168.11.%' identified by 'wubxwubx';

grant all privileges on *.* to 'wubx'@'192.168.11.%' ;

如果需要限制只能访问DB1里的对象：
grant all privileges on db1.* to 'wubx'@'192.168.11.%' ;

desc mysql.user

select Host,User, authentication_string from mysql.user;

SELECT, PROCESS, SUPER,



grant SUPER on *.* to 'repl'@'192.168.0.%' ;

grant SELECT,create,delete,drop,update, PROCESS, SUPER, REPLICATION SLAVE on *.* to 'repl'@'192.168.0.%' ;
flush privileges;