新增用户语句:
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;
delete from user where user='';
flush privileges;
测试连接成功!