1.CREATE USER 'json'@'localhost' IDENTIFIED BY '123456';
2.GRANT ALL PRIVILEGES ON * . * TO 'json'@'localhost';
3.FLUSH PRIVILEGES;
4.use mysql;
5.update user set Host='%' where user='json';
6.FLUSH PRIVILEGES;
转载于:https://my.oschina.net/u/3238650/blog/2223104