mysql遠端連線

標籤：mysql遠端連線

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;

本文出自 “梁小明的部落格” 部落格，請務必保留此出處http://7038006.blog.51cto.com/7028006/1893626

mysql遠端連線