mysql 添加远程访问用户

mysql 添加远程访问用户：

insert into mysql.user(Host,User,Password) values ('10.12.167.132','patest',password('123456'));
flush privileges;

GRANT ALL PRIVILEGES ON *.* TO 'paptest'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
//'paptest'@'%'  %代表任何一个主机都可以连接
flush privileges;
远程连接

mysql -h 10.12.167.132 -P 3306 -u paptest -p123456

用下面的方法：

GRANT ALL PRIVILEGES ON dropship.* TO dropship@localhost IDENTIFIED BY 'dropship123' WITH GRANT OPTION;
flush privileges;