创建账户:
create user 'fen'@'%' identified by '123456';
赋予权限:
grant all privileges on *.* to 'fen'@'%' with grant option ;
刷新:
flush privileges;
以下为备用方案:
mysql -u root -pvmwaremysql>use mysql;
mysql>update user set host = '%' where user = 'root';
mysql>select host, user from user;
select Host from user where user='root';