MySQL 远程访问权限

1 . 进入mysql库：

update user set host = '%' where host = 'localhost' ;

2. GRANT  [权限] ON[数据库名].[表命] TO ['用户名']@['ip地址'] identified by ['密码'] WITH [权限] OPTION  ;

例：GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION ;