新增xampp的mysql用户

新增用户语句：

insert into mysql.user(host,user,password) values("%","cmcpapi",password("PmFRb2VkgIuP7Adn"));

GRANT ALL PRIVILEGES ON *.* TO 'cmcpapi' IDENTIFIED BY 'PmFRb2VkgIuP7Adn' WITH GRANT OPTION;

FLUSH   PRIVILEGES;

此处如果提示没有登录权限，就删除mysql匿名用户：
delete from user where user='';

flush privileges;

测试连接成功！